Untitled

Mono on OS X: System.Data.SQLite does not work

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

    }

}

       

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 <filename unknown>:0

  at System.Data.SQLite.SQLiteDataReader.GetSchemaTable (Boolean wantUniqueInfo, Boolean wantDefaultValue) [0x00000] in <filename unknown>:0

  at System.Data.SQLite.SQLiteDataReader.GetSchemaTable () [0x00000] in <filename unknown>: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