I'm trying to port an iOS application that uses native Sqlite3 and makes heavy use of SqliteDataReader
.
On the target platform I use SQLIte-Net (https://github.com/praeclarum/sqlite-net) and there the SqliteDataReader class does not exist.
What are my best options to convert this? The usage of the reader is always code like this:
SqliteConnection oConn = AppDelegateBase.MasterDatabase.CreateDBMSConnection();
using ( SqliteCommand oCmd = new SqliteCommand ( "SELECT * FROM ATable"), oConn ) )
using ( var oReader = oCmd.ExecuteReader ( ) )
{
while ( oReader.Read ( ) )
{
int val = Convert.ToInt32(oReader["someColumn"]);
}
oReader.Close ();
}
There is no IDataReader/IDataRecord implementation in sqlite-net, because sqlite-net is not ADO adapter .net implementation.
You should check examples on GitHub page first. You should not use SQL language, like described here. If you need ADO imlementation, there are other SQLite libraries for C#, like System.Data.SQLite (official), sqlite-csharp and Mono.Data.Sqlite.
Ive used the System.Data.SQLite ADO adapter successfully in a few projects. I believe it has an a SQLDataReader class. Im not sure if its that same implementation you are after however.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With