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()));
}
}
}
