Linq Óësql·½Ê½ Ìí¼ÓÊý¾ÝЧÂʱȽÏ

Ëù²âÊÔ»·¾³Îª£ºMs sqlserver 2008£¬visual studio 2008
²âÊÔÊý¾ÝΪ10ÍòÌõ
 Linq·½Ê½ ´úÂ룺
/// <summary>
/// Linq ·½Ê½
/// </summary>
public static void Linq_insert()
{
DataClassesDataContext dataContext = new DataClassesDataContext();
for (int i = 0; i < 100000; i++)
{
Bulletin bulletin = new Bulletin()
{
ID = 10000 + i,
content = "18:00Ö±²¥ÑǹÚÊ׶ûVSɽ¶«£¬¾´ÇëÆÚ´ý£¡£¡£¡",
date = DateTime.Now,
title = "18:00Ö±²¥ÑǹÚÊ׶ûVSɽ¶«"
};
dataContext.Bulletin.InsertOnSubmit(bulletin);
}
dataContext.SubmitChanges();
}
SQL ·½Ê½  ´úÂ룺
public static void SQL_insert()
{
SqlConnectionStringBuilder strB = new SqlConnectionStringBuilder();
strB.DataSource = ".";
strB.InitialCatalog = "MyBulltin";
strB.UserID = "sa";
strB.Password = "123";
SqlConnection conn = new SqlConnection(strB.ToString());
SqlCommand comm = null;
string sql = "insert into Bulletin(id,content,date,title) values(@id,@content,@date,@title)";
comm = new SqlCommand(sql, conn);
conn.Open();
for (int i = 0; i < 100000; i++)
{
SqlParameter[] param=new SqlParameter[]{
new SqlParameter("@id",i+10000),
new SqlParameter("@content","18:00Ö±²¥ÑǹÚÊ׶ûVSɽ¶«£¬¾´ÇëÆÚ´ý£¡£¡£¡"),
new SqlParameter("@date",DateTime.Now),
new SqlParameter("@title","18:00Ö±²¥ÑǹÚÊ׶ûVSɽ¶«")
};
comm.CommandText = sql;
comm.Parameters.AddRange(param);
comm.ExecuteNonQuery();
comm.CommandText = string.Empty;
comm.Parameters.Clear