protected void Button1_Click(object sender, EventArgs e) { var n = CRL.Sharding.DB.DataBaseManage.Instance.Count(b => b.Id > 0); if (n > 0) { return; } CRL.Sharding.DB.DataBaseManage.Instance.CleanData(); //创建库分组 var db = new CRL.Sharding.DB.DataBase(); db.Name = "db1"; db.MaxMainDataTotal = 10; CRL.Sharding.DB.DataBaseManage.Instance.Create(db); CRL.Sharding.DB.DataBaseManage.Instance.Create(db); //创建表 var dbList = CRL.Sharding.DB.DataBaseManage.Instance.QueryList(); foreach(var item in dbList) { var table = new CRL.Sharding.DB.Table(); table.TableName = "MemberSharding"; table.IsMainTable = true; CRL.Sharding.DB.TableManage.Instance.Create(item, table, out error); var table2 = new CRL.Sharding.DB.Table(); table2.TableName = "OrderSharding"; table2.IsMainTable = false; table2.MaxPartDataTotal = 5; CRL.Sharding.DB.TableManage.Instance.Create(item, table2, out error); //创建分区 CRL.Sharding.DB.TablePartManage.Instance.Create(table2, out error); } }
protected void Button1_Click(object sender, EventArgs e) { var n = CRL.Sharding.DB.DataBaseManage.Instance.Count(b => b.Id > 0); if (n > 0) { return; } CRL.Sharding.DB.DataBaseManage.Instance.CleanData(); //创建库分组 var db = new CRL.Sharding.DB.DataBase(); db.Name = "db1"; db.MaxMainDataTotal = 10; CRL.Sharding.DB.DataBaseManage.Instance.Create(db); CRL.Sharding.DB.DataBaseManage.Instance.Create(db); //创建表 var dbList = CRL.Sharding.DB.DataBaseManage.Instance.QueryList(); foreach (var item in dbList) { var table = new CRL.Sharding.DB.Table(); table.TableName = "MemberSharding"; table.IsMainTable = true; CRL.Sharding.DB.TableManage.Instance.Create(item, table, out error); var table2 = new CRL.Sharding.DB.Table(); table2.TableName = "OrderSharding"; table2.IsMainTable = false; table2.MaxPartDataTotal = 5; CRL.Sharding.DB.TableManage.Instance.Create(item, table2, out error); //创建分区 CRL.Sharding.DB.TablePartManage.Instance.Create(table2, out error); } }