LINQ TO SQL操作大全整理

首先是通过建立相应的DBML文件，然后将需要的表拉进来，dbml文件取名为TestLinqContext.dbml

 

可以在相应的TestLinqContext.design.cs中将构造函数重写下，这样就不用每次都要取连接字符来构造了

 

每次使用的时候，首先建立对象TestLinqContext TLContext = new TestLinqContext();[这边的构造函数已经在上面重新写了，所以已经连接上了数据库]

 

1，Insert操作

        a）单一操作

	var newTest = new Test
	{

		TestName = "test1",

		TestProperty = "test1property"	
	};
	TLContext.Test.InsertOnSubmit(newTest);
	TLContext.SubmitChanges();

2，Update

        a）单一操作

	Test updateTest = TLContext.Where(tl => tl.TestName == "testname1").SingleOrDefault();	

	updateTest.TestProperty = "newtest1property";

	TLContext.SubmitChanges();

 
        b）多项操作
	var updateTests =from p in TLContest.Test where p.TestProperty = "CanRead" select p;	
	foreach(var updatelist in updateTests)
	{
		updatelist.TestProperty = "CanReadAndWrite";
	}
	TLContext.SubmitChanges();
3，Delete
        a）单一操作
	Test deleteTest = TLContext.where(tl => tl.TestName == "testname1").SingleOrDefault();	
	TLContext.Test.DeleteOnSubmit(deleteTest);
	TLContext.SubmitChanges();

 

        b）多项操作

	var deleteTests =from p in TLContest.Test where p.TestProperty = "CanRead" select p;	

	foreach(var deletelist in deleteTests)

	{

		TLContext.Test.DeleteOnSubmit(deletelist);	

	}

	TLContext.SubmitChanges();

        未完待续，这是个人理解到的步骤，以后仍要修改(o07-csy)