Add to:
1 using(varEDM =Newnorthwindentities ())2 3 {4 5Customers C =NewCustomers {CustomerID ="C #", City ="Chengdu City", Address ="Sichuan, China", CompanyName ="Cnblogs", country ="China", Fax ="10086", Phone ="1008611", PostalCode ="610000", Region ="Tianfu Square", ContactName ="Windmill car. Net" };6 7 EDM. Addtocustomers (c);8 9 intresult =EDM. SaveChanges ();}
Delete:
using (varnew"C2"); EDM. DeleteObject (Deletec); int result = EDM. SaveChanges ();}
Modify:
1 using(varEDM =Newnorthwindentities ())2 {3Customers ADDC = EDM. Customers.firstordefault (cc = CC. CustomerID = ="C2");4ADDC. City ="CD";5ADDC. ContactName ="Cnblogs";6ADDC. Country ="CN";7 intresult =EDM. SaveChanges ();8}
Pagination + Sort:
1 Private StaticList<post> Getpostlist (intPageIndex,intpageSize)2 {3 intStartRow = (PageIndex-1) *pageSize;4 using(vardb =Newediblogentities ())5 {6 varquery = db. Post.orderbydescending (p =p.pubdate). Skip (StartRow). Take (pageSize);7 returnquery. ToList ();8 }9}
Entity Framework + MySQL usage notes