Interacting with SQLite.NET API

A typical db session using SQLite.NET is shown below. The interaction idioms are similar to the ADO.NET API and this makes direct knowledge application from ADO.NET to SQLite.NET trivial.

int retCode;
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
using (SQLiteTransaction transaction = connection.BeginTransaction())
using (SQLiteCommand cmd = new SQLiteCommand(commandText, connection))
retCode = cmd.ExecuteNonQuery();
} return (retCode > 0 ? true : false);

No comments:

Test driving ASP.NET MVC 5 with the Entity Framework Code First

The great advantage of MVC Code First is the automated code generation tools. We took a test drive of these features by developing a small ...