```c#
using System.Data;
using ServiceStack.DataAnnotations;
using ServiceStack.OrmLite;

namespace Test
{
    class Program
    {
        public class Person
        {
            [AutoIncrement]
            public int Id { get; set; }

            public string Name { get; set; }
        }

        public static void Main(string[] _)
        {
            var factory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);

            using (var db = factory.OpenDbConnection())
            {
                db.CreateTable<Person>();

                var person = new Person { Name = "Paul" };
                var personId = db.Insert(person); // Id is also auto set.

                using (var trans = db.OpenTransaction(IsolationLevel.ReadCommitted))
                {
                    person = db.Single(db.From<Person>().Where(x => x.Name == "Paul"));
                    person = db.SingleById<Person>(personId);

                    person.Name = "Another name";

                    db.Save(person);

                    trans.Commit();
                }
            }
        }
    }
}
```