public void TextDapperContextMul() { //TODO 主从 数据库使用下划线_作为分隔符 DbEntityMap.InitMapCfgs(); //init datasourse IDbDatasource dbDatasource = new DbDataSource(); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.master_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenter;User ID = sa; Password = db123;", ["aa.dataSource.master_AaCenter.provider"] = "SqlServer" }); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.slave_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenterS1;User ID = sa; Password = db123;", ["aa.dataSource.slave_AaCenter.provider"] = "SqlServer" }); IDapperContext dapperContext = new DapperContext(); IVillageRepository villageRepository = new VillageRepository(dapperContext); IUserInfoRepository userInfoRepository = new UserInfoRepository(dapperContext); DbContextHolder.SetDbSourceMode("slave"); try { var user = userInfoRepository.Count(); var model = villageRepository.Get(new Guid("6D880321-DB17-4B32-9F0A-CE9F3F25AA01")); } catch (Exception ex) { throw ex; } }
public void TextDapperContext() { //TODO 主从 数据库使用下划线_作为分隔符 DbEntityMap.InitMapCfgs(); //init datasourse IDbDatasource dbDatasource = new DbDataSource(); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.master_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenter;User ID = sa; Password = db123;", ["aa.dataSource.master_AaCenter.provider"] = "SqlServer" }); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.slave_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenterS1;User ID = sa; Password = db123;", ["aa.dataSource.slave_AaCenter.provider"] = "SqlServer" }); IDapperContext dapperContext = new DapperContext(); IDapperContext dapperContextSlave = new DapperContext(); DbContextHolder.SetDbSourceMode("master"); IUserInfoRepository _userInforepository = new UserInfoRepository(dapperContext); IVillageRepository villageRepository = new VillageRepository(dapperContext); villageRepository.Insert(new Village { Id = Guid.NewGuid(), VillageName = "aa", GmtCreate = DateTime.Now, GmtModified = DateTime.Now }); DbContextHolder.SetDbSourceMode("slave"); var model = villageRepository.Get(new Guid("6D880321-DB17-4B32-9F0A-CE9F3F25AA01")); model.VillageName = "bbb"; villageRepository.Update(model); //var obj = _userInforepository.Insert(new UserInfo() //{ // RealName = "111", // UserName = "******", // GmtCreate=DateTime.Now, // LastLoginDate=DateTime.Now, // GmtModified=DateTime.Now //}); var users = _userInforepository.QueryAll(); var userList = _userInforepository.From(sql => sql.Select() .Where(p => p.RealName.Contains("成")) .OrderBy(x => x.SysNo) .Page(1, 20) ); var count = userList.ToList().Count(); //动态where Expression <Func <UserInfo, bool> > expression = p => p.RealName == "成天"; var where = DynamicWhereExpression.Init <UserInfo>(); where = where.And(x => x.RealName == "成天"); var dynamicUsers = _userInforepository.From(sql => sql.Select() .Where(where) .OrderBy(x => x.SysNo) .Page(1, 20) ); var count2 = dynamicUsers.ToList().Count(); }