LinqToAccess

1.加载linq2db.dll或者NuGet->搜索‘linq2db.access’->安装(选其一)

2.mdb声明好数据库各字段的属性(可以用sql写好然后导出数据库，声明用EF)->偷懒方法

3.Linq正常操作增、删、改、查

            Context = new DataContext("Access", connectionString);
            var qery = from a in Context.GetTable<PFSymptom>()
                       where a.DRPFId == 11
                       select a;//查寻
            int resultCount = Context.GetTable<PFSymptom>().Where(a => a.DRPFId == 100)
                .Set(a => a.SCode, "8888888888888888888888888").Update();//更新

  
int qery = Context.GetTable<CreatePo>().Where(a => a.Po.Equals(comb_po.Text))
                                .Update(o => new CreatePo
                                {
                                    CreateDate = result.CreateDate,
                                    CreateName = result.CreateName,
                                    HexFile = result.HexFile,
                                    UpdateDate = result.UpdateDate,
                                    HexName = result.HexName,
                                    Po = result.Po,
                                    UpdateBy = result.UpdateBy
                                });//更新
  
             int  qery = Context.GetTable<PFSymptom>().Where(a => a.DRPFId == 100 && a.SDesc == "way").Delete();//删除
                
           PFSymptom sym = new PFSymptom()
            {
                DRPFId = 100,
                SDesc = "way",
                SCode = "way.lee",
                SDisableDate = DateTime.Now,
                SUpdateDate = DateTime.Now,
                SRemarks = "what are you doing",
                SUpdateBy = 1
            };
            //       Context.Required = false;

            Context.Insert(sym);//插入
            

源码下载地址：https://download.csdn.net/download/lw8014/11966674