EntityFramework6.0對枚舉的支持/實體添加后會有主鍵反回

2019-11-14 16:28:50

字體：大中小

來源：轉載

供稿：網友

實驗

直接上代碼,看結果

實體類

[Flags]    public enum FlagsEnum    {        Day = 1,        Night = 2    }    public class EntityWithEnum    {        public int ID { get; set; }        public FlagsEnum ValidTime { get; set; }    }

數據庫上下文

public partial class CodeFirstModel : DbContext   {        public CodeFirstModel()            : base("name=CodeFirstModel")        {        }        public virtual DbSet<EntityWithEnum> EntityWithEnum { get; set; }}

Sql server LocalDb的連接字符串

<connectionStrings>    <add name="CodeFirstModel" connectionString="data source=(LocalDb)/MSSQLLocalDb;initial catalog=TestDb;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework" PRoviderName="System.Data.SqlClient" />  </connectionStrings>

主函數

static void Main(string[] args)        {            //CreateDatabaseIfNotExists            //DropCreateDatabaseIfModelChanges            //DropCreateDatabaseAlways            Database.SetInitializer(new DropCreateDatabaseIfModelChanges<CodeFirstModel>());            using (var context = new CodeFirstModel())            {                context.Database.Initialize(true);            }            using(CodeFirstModel db = new CodeFirstModel())            {        EntityWithEnum entity = new EntityWithEnum() { ValidTime = FlagsEnum.Day };                db.EntityWithEnum.Add(entity);                entity = new EntityWithEnum() { ValidTime = FlagsEnum.Night };                db.EntityWithEnum.Add(entity);                entity = new EntityWithEnum() { ValidTime = FlagsEnum.Night| FlagsEnum.Day };                db.EntityWithEnum.Add(entity);                db.SaveChanges();                Console.WriteLine("{0}:/t{1}", entity.ID, entity.ValidTime);                Console.WriteLine("-------------------");                var entitys = from e in db.EntityWithEnum                              where e.ValidTime.HasFlag(FlagsEnum.Day)                              select e;                foreach (var item in entitys)                {                    Console.WriteLine("{0}:/t{1}", item.ID, item.ValidTime);                }                            }            Console.ReadKey(true);}