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);
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.
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 ...
This little excursion in numerical analysis was prompted by the rather flaky IRR Excel function available in Microsofts' Excel API. We w...
This solution resolved my SQLite connection string configuration. The code makes use of the SQLiteConnectionStringBuilder class. The databas...
After starting out on the XBAP route and quickly hitting the sandbox limit it was time to actually move to an application paradigm that wou...