LINQ to SQLite完美解决方案

 

1、下载安装LinqConnectExpress(就是LinqConnect免费版)

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

LINQ to SQLite

 

LINQ to SQLite

LINQ to SQLite

 

LINQ to SQLite

 

LINQ to SQLite

 

LINQ to SQLite

 

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

 

更多。。。。等待更新

 
 
posted @ 2014-08-26 10:50  Bruce-He  阅读(1647)  评论(0编辑  收藏  举报
成都共享办公室