Can't insert into a table with an integer primary key
Posted: Sat 18 Dec 2010 17:47
I've tried everything I can think of, including uninstalling and reinstalling version 3.0 of dotConnect for SQLite. I've also created a very simple (single table, 2 field) database to eliminate the possibility of it being the complexity of the database being a problem.
Whenever I try to insert a row into a table with a primary key set, it fails with the following very unhelpful exception:
The table has 2 fields:
MyID, an integer PK with autoincrement
Text1, a nullable text field
If I remove autoincrement and set the ID manually, it has no effect. Changing whether it's nullable or not also has no effect. If I remove the PK, the exception goes away.
Here's the test code I'm using:
Someone please help, this is driving me nuts!
Whenever I try to insert a row into a table with a primary key set, it fails with the following very unhelpful exception:
Code: Select all
System.InvalidCastException was unhandled
Message="Specified cast is not valid."
Source="System.Data.Linq"
StackTrace:
at System.Data.Linq.Mapping.MetaAccessor`2.SetBoxedValue(Object& instance, Object value)
at Devart.Data.Linq.aa.e()
at Devart.Data.Linq.b.a()
at Devart.Data.Linq.y.a(DataContext A_0, ConflictMode A_1)
at Devart.Data.Linq.y.b(DataContext A_0, ConflictMode A_1)
at Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
at Devart.Data.Linq.DataContext.SubmitChanges()
at SqliteLinqTest.Form1.button1_Click(Object sender, EventArgs e) in C:\Users\Simon\Documents\Visual Studio 2008\Projects\SqliteLinqTest\SqliteLinqTest\Form1.cs:line 25
(Irrelevent stuff removed)MyID, an integer PK with autoincrement
Text1, a nullable text field
If I remove autoincrement and set the ID manually, it has no effect. Changing whether it's nullable or not also has no effect. If I remove the PK, the exception goes away.
Here's the test code I'm using:
Code: Select all
MainDataContext dc = new MainDataContext();
TestTable tt = new TestTable();
tt.Text1 = "Some text";
dc.TestTables.InsertOnSubmit(tt);
dc.SubmitChanges();