WF8 & C# & SQLite & autoincrement & Fail

Question

I try to use the SQLite Library for WP8.

I defined a table:

class ShoppingItem { [SQLite.PrimaryKey] public int Id {get; set;} public string Name {get; set;} public string Shop {get; set;} public bool isActive {get; set;} }

According to http://www.sqlite.org/autoinc.html a value is assigned to Id automatically by sqlite, if no value for Id has been given. Right?

So I try to insert new entries by

using (var db = new SQLiteConnection(m_DatabasePath)) { db.Insert(new ShoppingItem() { Name = anItem, Shop = aShop, isActive = aIsActive, }); }

When I insert a first item, it gets the ID 0. Well, why not. When I insert a second item, i get a SQLiteException with the awesome message "Constraint". So how can I insert a new entry without giving an id?

btw.: As an alternative solution, I tried to add a null value to id, but this resulted in a compilation error. :(

... db.Insert(new ShoppingItem() { Id = null, // <- does not compile Name = anItem, ...

No, but I do not think this is necessary, according to sqlite.org/autoinc.html — Christian Graf
– Christian Graf, Commented Mar 18, 2013 at 10:05

CL. · Accepted Answer · 2013-03-18 10:40:03Z

4

Your ShoppingItem does not know that the field is autoincrementing, so it assigns a default value of zero.

Use:

[SQLite.PrimaryKey, SQLite.AutoIncrement] public int Id {get; set;}

answered Mar 18, 2013 at 10:40

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Christian Graf Over a year ago

yeah, it works, thank you. But I don't understand why I have to add the AutoIncrement flag, as the AutoIncrement should be done automatically by SQLite?! Or is my problem a matter of the SQLite lib for C#?

CL. Over a year ago

The problem is that C# automatically assigned a value.

Collectives™ on Stack Overflow

WF8 & C# & SQLite & autoincrement & Fail

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related