Linq操作SQL数据库

LINQ操作数据库包括连接，插入，查询，更新，删除，现在把这些常用的操作记录下来，以备查看：

一：数据库的连接

 

string connectStr = ConfigurationManager.ConnectionStrings[1].ConnectionString.ToString();
DataContext dc = new DataContext(connectStr);

二：数据库的插入：

string connectStr = ConfigurationManager.ConnectionStrings[1].ConnectionString.ToString();
DataContext dc = new DataContext(connectStr);
student stu = new student();
stu.id = 19;
stu.name = "linq";
stu.@class =""001""
Table<student> table = dc.GetTable<student>();
table.InsertOnSubmit(stu);
dc.SubmitChanges();
dataGridView1.DataSource = table;
dataGridView1.Refresh();

三：数据库的查询：

string connectStr = ConfigurationManager.ConnectionStrings[1].ConnectionString.ToString();
DataContext dc = new DataContext(connectStr);

StudentDataSet db = new StudentDataSet();
db = this.studentDataSet;
var a = from p in db.student
        where p.id > 1
        select p;
dataGridView1.DataSource = a.AsDataView();
dataGridView1.Refresh();

四：数据库的更新：

 

五：数据库的删除：

 删除有两种方法：

1：

string sqlStr = "Data Source=Sheng;Initial Catalog=Student;Integrated Security=True";
DataContext dc = new DataContext(sqlStr);
Table<student> stu = dc.GetTable<student>();
var a = (from s in stu
        where s.id == 8
        select s
        ).First();
stu.DeleteOnSubmit(a);
dc.SubmitChanges();

2:

studentDataContext dxc = new studentDataContext();
student delete1 = dxc.student.Single(c => c.id == 19);
stu.DeleteOnSubmit(delete1);
dxc.student.DeleteOnSubmit(delete1);
dxc.SubmitChanges();