LINQ to SQLite完美解决方案

2014 年 8 月
一	二	三	四	五	六	日
	1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

1、下载安装LinqConnectExpress（就是LinqConnect免费版）

2、安装好后就和LINQ TO SQL 一样了！

3、查询（增删改查和LINQ TO SQL 完全一样，你可以不用改一句代码！）

CrmDemoDataContext context = new CrmDemoDataContext();

var query = from it in context.Companies

orderby it.CompanyID

select it;

foreach (Company comp in query)

Console.WriteLine("{0} | {1} | {2}", comp.CompanyID, comp.CompanyName, comp.Country);

Console.ReadLine();

4、增加

CrmDemoDataContext context = new CrmDemoDataContext();
// Create a new category
ProductCategory newCategory = new ProductCategory();
newCategory.CategoryID = 1000;
newCategory.CategoryName = "New category";
// Create a new product
Product newProduct = new Product();
newProduct.ProductID = 2000;
newProduct.ProductName = "New product";
newProduct.Price = 20;
// Associate the new product with the new category
newProduct.ProductCategory = newCategory;
context.Products.InsertOnSubmit(newProduct);
// Send the changes to the database.
// Until you do it, the changes are cached on the client side.
context.SubmitChanges(); 

5、更新

product.ProductName = "Edited product";
product.Price = 15;
context.SubmitChanges(); 

6、删除

context.products.DeleteOnSubmit(newProduct);
context.productcategories.DeleteOnSubmit(newCategory);
context.SubmitChanges(); 

更多。。。。等待更新

链接

近期文章

热门标签

新人福利，免费薅羊毛

============ 欢迎各位老板打赏~ ===========

与本文相关的文章

发表评论