LINQ to SQLite完美解决方案

LINQ to SQLite完美解决方案 

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();

 

更多。。。。等待更新

原文来自： LINQ to SQLite完美解决方案