Databases
StackOverflow2013
Postsdbo
POMono on OS X: System.Data.SQLite does not work
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMono on OS X: System.Data.SQLite does not work
    primarykey
    data
    text
    <p>I am planning to do a project using Mono and SQLite as the database. Development is to be done primarily on a Mac. I have successfully setup Mono and tested System.Data.SQLite(managed dll). Simple test applications work perfectly.</p> <p>However when I tried to use <code>DataTable</code> in my code it throws a runtime exception. Following is the code snippet:</p> <pre><code>public static void Main (string[] args) { string connectionString = "Data Source=emp.db"; try { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { string query = "SELECT firstname, lastname FROM employees"; using (SQLiteCommand comm = new SQLiteCommand(query, conn)) { conn.Open(); comm.CommandText = query; using (SQLiteDataReader reader = comm.ExecuteReader()) { while (reader.Read()) { string firstname = reader.GetString(0); string lastname = reader.GetString(1); Console.WriteLine("Name: " + firstname + " " + lastname); } DataTable dt = new DataTable(); dt.Load(reader); // line 39 where problem occurs } } } } catch (Exception e) { Console.WriteLine(e); } } </code></pre> <p>The above code get built successfully but does not run on my development machine and gives the following output on the terminal.</p> <p>The output when I run the application is as below:</p> <pre><code>Name: John Doe Name: Eric Smith System.EntryPointNotFoundException: sqlite3_column_origin_name at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_column_origin_name (intptr,int) at System.Data.SQLite.SQLite3.ColumnOriginalName (System.Data.SQLite.SQLiteStatement stmt, Int32 index) [0x00000] in &lt;filename unknown&gt;:0 at System.Data.SQLite.SQLiteDataReader.GetSchemaTable (Boolean wantUniqueInfo, Boolean wantDefaultValue) [0x00000] in &lt;filename unknown&gt;:0 at System.Data.SQLite.SQLiteDataReader.GetSchemaTable () [0x00000] in &lt;filename unknown&gt;:0 at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction missingSchAction, MissingMappingAction missingMapAction, System.Data.Common.DataTableMappingCollection dtMapping) [0x0003b] in /private/tmp/monobuild/build/BUILD/mono-2.10.6/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:284 at System.Data.DataTable.Load (IDataReader reader, LoadOption loadOption) [0x0001f] in /private/tmp/monobuild/build/BUILD/mono-2.10.6/mcs/class/System.Data/System.Data/DataTable.cs:2853 at System.Data.DataTable.Load (IDataReader reader) [0x00011] in /private/tmp/monobuild/build/BUILD/mono-2.10.6/mcs/class/System.Data/System.Data/DataTable.cs:2838 at SQLiteApp.MainClass.Main (System.String[] args) [0x00086] in /Users/nayaabkhan/Projects/SQLiteApp/SQLiteApp/Main.cs:37 </code></pre> <p>I was surprised to see that the same above executable worked perfectly under windows, but was failing on my development machine.</p> <p>Searching on the internet, I found that this problem has to do something with the sqlite dynamic library and must be compiled with SQLITE_ENABLE_COLUMN_METADATA. I've tried to compile sqlite with the SQLITE_ENABLE_COLUMN_METADATA as well. I don't know where to put the compiled <code>libsqlite3.0.dylib</code>.</p> <p>Any help will be appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USnayaab
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWelcome to SO! This is a well-written question for a first-time asker. I tip my bonnet to you.
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. USAmy
    2. COHey thanks for appreciation lnuyasha.
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. USnayaab
    3. COWhere did you download the managed library? I'm trying to find a place to download it on the mac but can't find any.
      singulars
      1. POMono on OS X: System.Data.SQLite does not work
      1. USMaurício Linhares
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload