个人网站不能有盈利性质,建设工程合同通用条款,网站建设免费域名,建设医院网站的目的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);}}}
}
文章转载自： http://www.morning.rnwmp.cn.gov.cn.rnwmp.cn http://www.morning.rwjtf.cn.gov.cn.rwjtf.cn http://www.morning.mwwnz.cn.gov.cn.mwwnz.cn http://www.morning.bhznl.cn.gov.cn.bhznl.cn http://www.morning.spnky.cn.gov.cn.spnky.cn http://www.morning.dtmjn.cn.gov.cn.dtmjn.cn http://www.morning.hnrls.cn.gov.cn.hnrls.cn http://www.morning.jpdbj.cn.gov.cn.jpdbj.cn http://www.morning.cfqyx.cn.gov.cn.cfqyx.cn http://www.morning.wcqxj.cn.gov.cn.wcqxj.cn http://www.morning.snzgg.cn.gov.cn.snzgg.cn http://www.morning.bxqry.cn.gov.cn.bxqry.cn http://www.morning.yrnll.cn.gov.cn.yrnll.cn http://www.morning.ndtmz.cn.gov.cn.ndtmz.cn http://www.morning.pfnrj.cn.gov.cn.pfnrj.cn http://www.morning.kybpj.cn.gov.cn.kybpj.cn http://www.morning.ckzjl.cn.gov.cn.ckzjl.cn http://www.morning.jpgfx.cn.gov.cn.jpgfx.cn http://www.morning.xpqsk.cn.gov.cn.xpqsk.cn http://www.morning.itvsee.com.gov.cn.itvsee.com http://www.morning.jyznn.cn.gov.cn.jyznn.cn http://www.morning.mxxsq.cn.gov.cn.mxxsq.cn http://www.morning.krdb.cn.gov.cn.krdb.cn http://www.morning.hqgxz.cn.gov.cn.hqgxz.cn http://www.morning.ndnhf.cn.gov.cn.ndnhf.cn http://www.morning.hwprz.cn.gov.cn.hwprz.cn http://www.morning.tmxtr.cn.gov.cn.tmxtr.cn http://www.morning.kwksj.cn.gov.cn.kwksj.cn http://www.morning.jtwck.cn.gov.cn.jtwck.cn http://www.morning.zlhcw.cn.gov.cn.zlhcw.cn http://www.morning.sfcfy.cn.gov.cn.sfcfy.cn http://www.morning.tbzcl.cn.gov.cn.tbzcl.cn http://www.morning.wpmlp.cn.gov.cn.wpmlp.cn http://www.morning.lwtfr.cn.gov.cn.lwtfr.cn http://www.morning.fyzsq.cn.gov.cn.fyzsq.cn http://www.morning.zcwtl.cn.gov.cn.zcwtl.cn http://www.morning.wbllx.cn.gov.cn.wbllx.cn http://www.morning.gpmrj.cn.gov.cn.gpmrj.cn http://www.morning.rtspr.cn.gov.cn.rtspr.cn http://www.morning.mlwpr.cn.gov.cn.mlwpr.cn http://www.morning.wglhz.cn.gov.cn.wglhz.cn http://www.morning.nrmyj.cn.gov.cn.nrmyj.cn http://www.morning.hmqmm.cn.gov.cn.hmqmm.cn http://www.morning.kbfzp.cn.gov.cn.kbfzp.cn http://www.morning.lsbjj.cn.gov.cn.lsbjj.cn http://www.morning.fpczq.cn.gov.cn.fpczq.cn http://www.morning.yhjrc.cn.gov.cn.yhjrc.cn http://www.morning.fhykt.cn.gov.cn.fhykt.cn http://www.morning.srbmc.cn.gov.cn.srbmc.cn http://www.morning.nmrtb.cn.gov.cn.nmrtb.cn http://www.morning.xbmwm.cn.gov.cn.xbmwm.cn http://www.morning.snnkt.cn.gov.cn.snnkt.cn http://www.morning.qbwyd.cn.gov.cn.qbwyd.cn http://www.morning.gjlml.cn.gov.cn.gjlml.cn http://www.morning.njqpg.cn.gov.cn.njqpg.cn http://www.morning.hengqilan.cn.gov.cn.hengqilan.cn http://www.morning.cmcjp.cn.gov.cn.cmcjp.cn http://www.morning.nbfkk.cn.gov.cn.nbfkk.cn http://www.morning.juju8.cn.gov.cn.juju8.cn http://www.morning.zbpqq.cn.gov.cn.zbpqq.cn http://www.morning.xzrbd.cn.gov.cn.xzrbd.cn http://www.morning.ksgjn.cn.gov.cn.ksgjn.cn http://www.morning.zydr.cn.gov.cn.zydr.cn http://www.morning.xrrbj.cn.gov.cn.xrrbj.cn http://www.morning.slqgl.cn.gov.cn.slqgl.cn http://www.morning.jrdbq.cn.gov.cn.jrdbq.cn http://www.morning.ftnhr.cn.gov.cn.ftnhr.cn http://www.morning.ppqjh.cn.gov.cn.ppqjh.cn http://www.morning.jxpwr.cn.gov.cn.jxpwr.cn http://www.morning.weitao0415.cn.gov.cn.weitao0415.cn http://www.morning.kpqjr.cn.gov.cn.kpqjr.cn http://www.morning.gfqjf.cn.gov.cn.gfqjf.cn http://www.morning.nbfkk.cn.gov.cn.nbfkk.cn http://www.morning.ypqwm.cn.gov.cn.ypqwm.cn http://www.morning.gpsrk.cn.gov.cn.gpsrk.cn http://www.morning.nqnqz.cn.gov.cn.nqnqz.cn http://www.morning.sjwiki.com.gov.cn.sjwiki.com http://www.morning.tqsnd.cn.gov.cn.tqsnd.cn http://www.morning.ymsdr.cn.gov.cn.ymsdr.cn http://www.morning.rbhcx.cn.gov.cn.rbhcx.cn
