LINQ to SQLite完美解决方案，linqsqlite

LINQ to SQLite完美解决方案，linqsqlite

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完美解决方案