using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SQLite.CodeFirst;
using XzXdDw.App.Model;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Data.SQLite;
using System.Data.Entity.Infrastructure.Interception;

namespace XzXdDw.App.EFContext
{
    internal class RHDWContext: DbContext
    {
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            //modelBuilder.Entity<TaskInfo>().Map(m =>
            //{
            //    m.MapInheritedProperties();
            //    m.ToTable("TaskInfo");

            //});
            this.Database.Log = msg =>
            {
                Console.WriteLine(msg);
            };

            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
            modelBuilder.Configurations.AddFromAssembly(typeof(RHDWContext).Assembly);

            var sqliteConnectionInitializer = new SqliteCreateDatabaseIfNotExists<RHDWContext>(modelBuilder);
            Database.SetInitializer(sqliteConnectionInitializer); 
            DbInterception.Add(new SqliteInterceptor());//拦截器
            base.OnModelCreating(modelBuilder);
        }
        public RHDWContext() : base("DbCon") { } //配置使用的连接名
        public DbSet<XlInfo> XlInfos { set; get; }

        public DbSet<TaskInfo> TaskInfos { set; get; }

        public DbSet<TxInfo> TxInfos { get; set; }

        public DbSet<SatInfo> SatInfos { get; set; }


        public DbSet<CheckRes> CxRes { get; set; }
        public DbSet<CgRes> CgRes { get; set; }
        public DbSet<PosRes> PosRes { get; set; }

        public DbSet<XDPosRes> XDPosRes { get; set; }
        public DbSet<XZPosRes> XZPosRes { get; set; }

        public DbSet<SysSetings> SysSetings { get; set; }


    }
}