> 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: http://
> 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
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):
connec
--- Den ons 2012-01-25 skrev Joe Mistachkin :
> 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 guess I'm off Googli
> 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
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:
[TableAttribute(Name="Pers
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:
[TableAttribute(Name="Pers
8 matches
Mail list logo
