Hello everyone, My project used sqlite3x, a sqlite c++ wrapper. Now for
some reason, I wanna upgrade sqlite3 to version 3.7.10.
I search the Internet hours, but I don't find the sqlite3x that support 3.7.
Have someone used sqlite3x? I need some advice.
sqlite3x web site is at:
I've reviewed your sample code. It would seem that the difference between
the two method overloads is that working one resolves to:
I will look into this. Thank you so much for all your effort and help.
Now I'm off to do some serious googling.
Truls.
Without a more complete example, it's hard to say exactly.
However, I suspect it may have something to do with the type(s) of Id and
firstId.
Whole project is at: https://github.com/trulsu/SQLiteTest
The table is defined as:
CREATE TABLE SqLite (
Id UNIQUEIDENTIFIER PRIMARY KEY ASC,
Name
Given a table (SqLite) with an Id that is defined as a UNIQUEIDENTIFIER (stored
as TEXT) I get the following results (firstId is a Guid matching the first
entry):
This fails (returns zero rows):
connection.SqLite.FirstOrDefault(s = s.Id == firstId )
This works (returns one row):
--- Den ons 2012-01-25 skrev Joe Mistachkin sql...@mistachkin.com:
The supported alternative here is the ObjectContext class
from the Entity Framework
Thank you. I will check this out.
I am not using the Entity Framework, so I will have to figure out how to create
an ObjectContext manually. I
I am trying out System.Data.SQLite.LINQ and I am getting crashes with
FirstOrDefault().
I have created a table with the SQL:
CREATE TABLE Person(
Id INTEGER PRIMARY KEY,
Name TEXT NOT NULL,
Age INTEGER NOT NULL
);
The C# class I am reading into is defined as:
I am trying out System.Data.SQLite.LINQ and I am getting crashes with
FirstOrDefault().
I have created a table with the SQL:
CREATE TABLE Person(
Id INTEGER PRIMARY KEY,
Name TEXT NOT NULL,
Age INTEGER NOT NULL
);
The C# class I am reading into is defined as:
Would it be possible to see the generated SQL statement (from inside
the Prepare method) that is causing the exception?
I have tried unsuccessfully to create the debug version of System.Data.SQLite ,
so that is why I put the project on github. If anyone has the time to check out
the project
