Where is SqliteDataReader in sqlite

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.

链接地址: http://www.djcxy.com/p/11116.html

上一篇: PHP:不能成功执行protoc

下一篇: SqliteDataReader在sqlite中的位置