LINQ to SQLite完美解决方案

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

2、安装好后就和LINQTO sql 一样了！

3、查询（增删改查和LINQTO 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