Where is SqliteDataReader in sqlite-net?

Question

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 ();
}

Epinasty

Why do you want the DataReader class separately? The code you posted works very well. The oReader is your IDbDataReader object. Better use the ADO.NET version posted by tHand – Snailfish

And you dont need the reader.Close when you are wrapping it in a using clause – Snailfish

I'min the same boat - just posted a query on SO with a further explanation of what I'm trying to do - did you solve your issue? #21490926 – Plow

No, never solved it. However your question does not seem to be about Sqlie.Net (the ORM) but about Sqlite in general. – Epinasty

Answer 1

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.

Competition

Answer 2

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.

Tophole