System.Data.SQLite

 I've written an app that uses Microsoft JET.  So I have data adapters like:

               daGenres = New OleDbDataAdapter(SQL & "Genres", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName)
then I populate the tables with commands like:

            daGenres.Fill(ds, "Genres")
            objCB = New OleDbCommandBuilder(daGenres)
            Dim objColGenres() As DataColumn = {ds.Tables("Genres").Columns.Item("ID")}
            ds.Tables("Genres").PrimaryKey() = objColGenres

and then use table select commands to get collections of datarows that I want to work on and then access individual fields by:

           title = row("title")

So if I wanted to switch to System.Data.SQLite, does this entail rewriting all my code that touches the database, or can SQLite use the OleDB constructs in VB.NET?

Thanks

Dan

Robert implemented a managed ADO.NET provider, but not a native Ole DB provider. So, if you want to use Robert's System.Data.SQLite, you need to rewrite your application, you need to replace all OleDbConnection, OleDbCommand, OleDbDataAdapter, etc. with SQLiteConnection, SQLiteCommand, SQLiteDataAdapter, etc. This is because you are not taking advantage of ADO.NET factory pattern, and you are not using ADO.NET base classes and interfaces like DbDataAdapter, DbCommand, IDataReader, and so on.

 Once I do that, can I use VB.NET's datatables?

Of course yes.