做网站什么样的域名好,珠海高端网站建设,织梦网站背景,婚纱摄影网站设计思路Microsoft.EntityFrameworkCore新的版本不支持FrameWork框架。 这里举例使用旧版本实现数据存取 首先下载 Microsoft.EntityFrameworkCore 版本控制在2.1.14以下 同样下载Microsoft.EntityFrameworkCore.sqlite
举例时间记录 public class RunTimeInfo{[Key]public int Id { g…Microsoft.EntityFrameworkCore新的版本不支持FrameWork框架。 这里举例使用旧版本实现数据存取 首先下载 Microsoft.EntityFrameworkCore 版本控制在2.1.14以下 同样下载Microsoft.EntityFrameworkCore.sqlite
举例时间记录 public class RunTimeInfo{[Key]public int Id { get; set; }[Description(统计小时)]public DateTime TimeInfo { get; set; }[Description(运行时间)]public string RunTime { get; set; }public RunTimeInfo Clone(){return new RunTimeInfo(){TimeInfo this.TimeInfo,RunTime this.RunTime};}}public class DynamicModelCacheKeyFactoryRun : IModelCacheKeyFactory{public object Create(DbContext context) context is EfContextRunInfo dynamicContext? (context.GetType(), dynamicContext.CreateDateTime): (object)context.GetType();}public class EfContextRunInfo : DbContext{public DateTime CreateDateTime { get; set; }public static string connectionString{get{return $Data Source{Environment.CurrentDirectory}\\RunTime\\{DateTime.Now.ToString(yyyy-MM-dd)}.db;}}public bool IsSave true;public string DynamicConnectionString;public DbSetRunTimeInfo MdDatas { get; set; }public EfContextRunInfo(){}protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder){if (!optionsBuilder.IsConfigured){optionsBuilder.UseSqlite(IsSave ? connectionString : DynamicConnectionString).ReplaceServiceIModelCacheKeyFactory, DynamicModelCacheKeyFactoryRun();}}protected override void OnModelCreating(ModelBuilder modelBuilder){modelBuilder.EntityRunTimeInfo(entity {entity.ToTable(CreateDateTime.ToString(yyyyMMdd));entity.Property(e e.Id).IsRequired().HasColumnName(Id).HasColumnType(INTEGER).ValueGeneratedOnAdd();entity.Property(e e.TimeInfo).IsRequired().HasColumnName(TimeInfo).HasColumnType(DATETIME);entity.Property(e e.RunTime).IsRequired().HasColumnName(RunTime).HasColumnType(TEXT);entity.HasKey(Id);});}}添加数据查找数据 static ConcurrentQueueRunTimeInfo runTimeInfo new ConcurrentQueueRunTimeInfo();public Form1(){InitializeComponent();}private void btnSave_Click(object sender, EventArgs e){AddRunTimeData();}public static bool AddRunTimeData(){using (EfContextRunInfo context new EfContextRunInfo { CreateDateTime DateTime.Now }){try{if (!Directory.Exists(${Environment.CurrentDirectory}\\RunTime\\)){// 文件夹不存在则创建Directory.CreateDirectory(${Environment.CurrentDirectory}\\RunTime\\);}context.Database.EnsureCreated();//RelationalDatabaseCreator databaseCreator (RelationalDatabaseCreator)context.Database.GetServiceIDatabaseCreator();//databaseCreator.CreateTables();}catch (Microsoft.Data.Sqlite.SqliteException ex){//Logger.Debug(ex.Message);}catch (Exception ex){MessageBox.Show(ex.Message);return false;}while (runTimeInfo.TryDequeue(out var mdData)){context.MdDatas.Add(mdData);}context.SaveChangesAsync();}return true;}private void btnAddData_Click(object sender, EventArgs e){runTimeInfo.Enqueue(new RunTimeInfo() { TimeInfo DateTime.Now, RunTime 1 });}ListRunTimeInfo mdDataList new ListRunTimeInfo();private void btnQuary_Click_1(object sender, EventArgs e){using (EfContextRunInfo context new EfContextRunInfo { CreateDateTime DateTime.Now, IsSave false, DynamicConnectionString $Data Source{Environment.CurrentDirectory}\\RunTime\\{DateTime.Now.ToString(yyyy-MM-dd)}.db }){try{context.Database.EnsureCreated();var mdDatas context.MdDatas.Where(md md.Id2);mdDataList mdDataList.Union(mdDatas.ToList()).ToList();}catch (Microsoft.Data.Sqlite.SqliteException ex){//Debug.WriteLine(ex.Message);}catch (Exception ex){MessageBox.Show(ex.Message);}}}
}
