private void button2_Click(object sender, EventArgs e) { int count = int.Parse(textBox1.Text); using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) { using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) { IList lstData = null; if (chkDataTable.Checked) { DataTable dt = getDataTable(count, 1); lstData = dt.Select(); } else { lstData = getListData(count, 1); } using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute()) { bulk.WriteToServer("MbfsFucDtl", "AddObject", lstData); } MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes())); } } }
private void button8_Click(object sender, EventArgs e) { string name = "@Name"; string name2 = "@Name"; using (MB.Util.MethodTraceWithTime trace = new MB.Util.MethodTraceWithTime("")) { Microsoft.Practices.EnterpriseLibrary.Data.Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase(); if (db is Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase) { name = ":" + name.Substring(1, name.Length - 1); } double d1 = trace.GetExecutedTimes(); } using (MB.Util.MethodTraceWithTime trace = new MB.Util.MethodTraceWithTime("")) { using (MB.Orm.Persistence.DatabaseConfigurationScope scop = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) { Microsoft.Practices.EnterpriseLibrary.Data.Database db2 = MB.Orm.Persistence.DatabaseHelper.CreateDatabase(); if (db2 is Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase) { name = ":" + name.Substring(1, name.Length - 1); } else if (db2 is Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase) { name = "@" + name.Substring(1, name.Length - 1); } else { } } double d2 = trace.GetExecutedTimes(); } }
private void button3_Click(object sender, EventArgs e) { using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) { for (int i = 0; i < 10000; i++) { Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase(); using (SqlConnection cn = new SqlConnection(db.ConnectionString)) { cn.Open(); } } } }
private void button6_Click(object sender, EventArgs e) { int count = int.Parse(textBox1.Text); List <MY_TABLE_MAINInfo> myEntitys = new List <MY_TABLE_MAINInfo>(); int beginID = 1; for (int i = 0; i < 1000; i++) { myEntitys.Add(new MY_TABLE_MAINInfo() { ID = beginID++, NAME = "CCCC", CODE = "BB", ADDRESS = "PPP" }); } using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("MB.MBFS")) { Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase(); using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) { //using (SqlConnection cn = new SqlConnection(db.ConnectionString)) { // cn.Open(); // using (SqlTransaction tran = cn.BeginTransaction()) { // try { using (TransactionScope scopeTran = new TransactionScope()) { using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute()) { bulk.WriteToServer("MY_TABLE_MAIN", "UpdateObject", myEntitys); } // string data = MB.RuleBase.Common.DatabaseExcuteByXmlHelper.NewInstance.ExecuteScalar<string>("MY_TABLE_MAIN", "SelectObject", 10); scopeTran.Complete(); // throw new Exception("ERROR"); } // tran.Commit(); // // throw new Exception(); // } // catch { // tran.Rollback(); // } //} MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes())); } } }
private void button4_Click(object sender, EventArgs e) { int count = int.Parse(textBox1.Text); using (MB.Orm.Persistence.DatabaseConfigurationScope scope = new MB.Orm.Persistence.DatabaseConfigurationScope("SQL SERVER")) { Database db = MB.Orm.Persistence.DatabaseHelper.CreateDatabase(); using (MB.Util.MethodTraceWithTime t = new MB.Util.MethodTraceWithTime("BLUCK", count)) { using (SqlConnection cn = new SqlConnection(db.ConnectionString)) { cn.Open(); using (SqlTransaction tran = cn.BeginTransaction()) { try { IList lstData = null; if (chkDataTable.Checked) { DataTable dt = getDataTable(count, 1); lstData = dt.Select(); } else { lstData = getListData(count, 1); } using (MB.RuleBase.BulkCopy.IDbBulkExecute bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute(tran)) { bulk.WriteToServer("MbfsFucDtl", "AddObject", lstData); } tran.Commit(); // throw new Exception(); } catch { tran.Rollback(); } } } MessageBox.Show(string.Format("总共执行的时间有{0} 毫秒", t.GetExecutedTimes())); } } }