复制publicstatic void ADO_NET() { DateTime start = DateTime.Now; SqlConnection con = new SqlConnection("server=.;database=abc;uid=sa;pwd=123456"); SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = "insert into Users(UserName,据框架Password) values(@UserName,@Password)"; con.Open(); for (int i = 0; i < count; i++) { com.Parameters.Clear(); com.Parameters.AddWithValue("@UserName", "U_" + System.Threading.Thread.CurrentThread.ManagedThreadId); com.Parameters.AddWithValue("@Password", "P_" + i); if (com.ExecuteNonQuery() > -1) { ok2++; } } con.Close(); TimeSpan ts = DateTime.Now - start; Console.WriteLine("ADO.net [ADO.net]:" + ts.TotalSeconds + "[秒]--" + ok2); } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22. |
喜欢
讨厌