LINQ2DB SQLite Application

When using Linq2db SQLite, it was not found to add, delete the operation that was originally to introduce a new namespace Linqtodb.

1 using Linqtodb;

Insert:

1             User Unew = New user (), 2             unew.name = "Test", 3             Unew.password = "one"; 4             db. Insert (unew);

Update:

1  using (var db = new Databasehelper1db (@ "Data source=f:\yun\volcanocloudtest\databasehelper2.db3; version=3; Password=1 ")) 2             {3                 db. USERS4                   . Where (U = u.id = = 1) 5                   . Set (p = = p.name, "test") 6                   . Update (); 7             }

Delete:

1             using (var db = new Databasehelper1db (@ "Data source=f:\yun\volcanocloudtest\databasehelper2.db3; version=3; Password=1 ")) 2             {3                 db. USERS4                   . Where (U = u.id = = 1) 5                   . Delete (); 6             }

　　

In addition, LINQTODB also support access (see a lot of comrades looking for LINQ to access, some people also use charges, which may be the Gospel) and so on more than 10 databases, using similar methods, this article has been very long (I like short articles, easy to read), so not to repeat, If you want to use the comrades, do it yourself.

End

This article is my first in the Garden (debut), I hope you can correct me, if I could help you, I said Gray often happy. January 6, 2015 at the library.

LINQ2DB SQLite Application