System.Data.SQLite

Hi all,

I'm currently trying out the LINQ to SQLite and Entitiy Framework stuff in C#, and it seems to fit my needs perfectly. However, I'm having trouble inserting new rows into my tables.

I created a test table via the sqlite3 command line tool using this SQL string: "CREATE TABLE Test ( a INT, b INT, PRIMARY KEY (a) );" After generating the edmx, I tried this code to insert a row:

db = new testEntities();
Test x = new Test();
x.a = 2; x.b = 3;
db.AddToTest(x);
db.SaveChanges();

The last statement always throws a System.Data.OptimisticConcurrencyException and no rows are actually inserted. I can view data from the table just fine, using the LINQ query "from t in db.Test select t;". It's just SaveChanges() that doesn't work.

I compiled and ran the testlinq test suite from the source distribution and it worked. Also, I can insert rows into northwind.db in my own code. So did I maybe create my db file the wrong way?

Any help you be appreciated :)

Ok I'll have a look.  You're using the RTM, right?

 Thanks. I have "Version 9.0.30729.1 SP", no Express edition or beta, if that's what you're asking.

Hi!

I have the same problem.

The error is :

System.Data.SQLite.SQLiteException: Abort due to constraint violation
    Author.ID may not be NULL

My test table is:

CREATE TABLE [Author](   

    [ID] integer primary key,
    [AuthorName] nvarchar(20) NOT NULL

);

 My code is :

            SQLiteEntities context = new SQLiteEntities();

             Author newAuthor = new Author()
            {
                ID = 1,
                AuthorName= "tony"
            };

            context.AddToAuthor(newAuthor);
            context.SaveChanges();

But,when my table modifid to following,this code runned right:

CREATE TABLE [Author](   

    [ID] integer primary key autoincrement,
    [AuthorName] nvarchar(20) NOT NULL

);

why?

Hi,

 I have the same problem. I have made an example in the testlinq source:

Another example is:

Table:

CREATE TABLE [Countries] (
[CountryID] integer NOT NULL,
[CountryLong] nvarchar(255)  NULL,
[CountryShort] nvarchar(3) NULL,
 CONSTRAINT [PK_CountryID] PRIMARY KEY( [CountryID] ASC)
)

        Using db As DBModel.DBEntities = New DBModel.POIDBEntities
            db.AddToCountries(New DBModel.Countries With {.CountryID = 100,.POICountryLong = "The Netherlands", .POICountryShort = "NL"})
            db.SaveChanges()
        End Using

for some reason the CountryID is not used! Another ID will be put into the database (1).

Marcel

(PS Is there a way to see the SQL string before executing this so that I can see what is happening?)

I'll work on this.

How come CountryID is declared "integer primary key" and you're assigning it a string value of "100"?  Lose the quotes and it might return the value you're expecting.

Thanks!

The "100" was a typo. when I use 100 I have the same results.

This is working in the pending 57 release due out this week, or as soon as the new version of SQLite is out.  Whichever comes first.