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
相关文档:
http://topic.csdn.net/u/20100113/17/b52a1ef4-54a8-4333-8119-a161869c1eef.html
---------------------------------
-- Author: liangCK 小梁
-- Title : 查每个分组前N条记录
-- Date : 2008-11-13 17:19:23
---------------------------------
--> 生成测试数据: #T
IF OBJECT_ID(' ......
---1、添加数据文件
use master
go
--Fam200901
alter database RedfDB
add filegroup FGAM200901
go
alter database RedfDB
add file(name='FGAM200901',filename='D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Fam200901.mdf',
size=20,maxsize=40,filegrowth=10% ......
ORA-07445 与 PL/SQL Developer 案例一则
作者:eygle |English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接:http://www.eygle.com/archives/2009/02/ora_07445_plsql_developer.html
--------------------------------------------------------------------------------
前几天,又有一个 ......
一、常用数据类型:
Number:数字类型
Int:整数型
Pls_integer:整数型,产生溢出的错误
Binary_integer:整数型
Char:定长字符,最长255个字符
Varchar2:变长字符,最长2000个字符
Long:变长字符,最长2GB
Date:日期型
Boolean:布尔型
二、定义常量
格式:常量名 constant &nbs ......