select-enum.cs

namespace selectenum
{
    using ServiceStack.DataAnnotations;
    using ServiceStack.OrmLite;
    using ServiceStack.Text;

    enum MyEnum
    {
        FirstValue,
        SecondValue
    }

    class DataObject
    {
        [AutoIncrement]
        public int Id { get; set; }
        public MyEnum Value { get; set; }
    }

    class MainClass
    {
        public static void Main (string[] args)
        {
            var factory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);
            using(var db = factory.OpenDbConnection())
            {
                db.CreateTable<DataObject>();
                var obj = new DataObject { Value = MyEnum.SecondValue };
                db.Save(obj);

                obj.PrintDump();

                var myvalue = db.Scalar<MyEnum>(db.From<DataObject>()
                    .Where(o => o.Id == obj.Id)
                    .Select(o => o.Value));

                myvalue.PrintDump();
            }
        }
    }
}