#A super simple unit of work implementation on top of the NPoco micro ORM.#

For information about NPoco, see https://github.com/schotime/NPoco

using Shouldly;
using Xunit;

namespace NPoco.UoW
{
    public class Example
    {
        [Fact]
        public void CreateAContextAndUseASession()
        {
            IDatabase database = new Database("Your connection name");
            //Ideally your context object should be not long lived.  Request
            //scoping is ideal (if used in an MVC / web type scenario).  Contexts are 
            //cheap.

            Context context = new Context(database);

            using (var session = context.OpenSession())
            {
                var db = session.Database;
                var james = new User{Email = "[email protected]"};
                var john = new User {Email = "[email protected]"};
                
                db.Insert(james);
                db.Insert(john);

                using (var innerSession = context.OpenSession())
                {
                    var nonExistentUser = new User {Email = "[email protected]"};
                    innerSession.Database.Insert(nonExistentUser);
                    //the inner session is not committed, because we didn't call innerSession.SaveChanges()
                    //easy way to roll back in tests, just dont call SaveChanges().  If an exception is hit before
                    //SaveChanges(), then its rolled back as well.
                }
                session.SaveChanges();

                var users = db.Fetch<User>();
                users.Count.ShouldBe(2);
                //the outer session is committed (so james and john are committed to the db)
            }
        }

        [TableName("dbo.User")]
        [PrimaryKey("Id")]
        public class User
        {
            public int Id { get; set; }
            public string Email { get; set; }
        }
    }
}