AutoIncrement is not working with sqlite-net Client in windows phone universal App

Question

I am using sqlite-net for sqlite in my windows phone universal application I have following class with table and column attributes and using async connection to add data in sqlite all is working fine, But the Id column is not auto incremented neither it is a primary key. Does any one else face this issue? following is my code.

 [Table("Account")] public class Account { [PrimaryKey, AutoIncrement] [Column("Id")] public int Id { get; set; } [Column("FirstName")] public string FirstName { get; set; } [Column("LastName")] public string LastName { get; set; } [Ignore] public string FullName { get; set; } } SQLite.SQLiteAsyncConnection conn = new SQLite.SQLiteAsyncConnection("database.sqlite"); var result = await conn.CreateTableAsync<Account>(); var _accountList = new Account(); _accountList.FirstName = "Name 1"; _accountList.LastName = "------------"; var result1 = await conn.InsertAsync(_accountList); _accountList = new Account(); _accountList.FirstName = "Name 2"; _accountList.LastName = "------------"; result1 = await conn.InsertAsync(_accountList); var list = await conn.Table<Account>().ToListAsync(); var item = list;

on reading the table Id is always 0 for all records. Is there any way to fix this?

max · Accepted Answer · 2017-06-19 12:11:25Z

This is an old post, but maybe my answer can help someone, almost i hope so. First declare your Id field as nullable:

[PrimaryKey, AutoIncrement] [Column("Id")] public int? Id { get; set; }

Is important that your primary key is nullable, otherwise it will be sent to the Insert method with the value of "0" and SQLite won't change an already existing integer value, and the next insert you'll receive an error, becouse you're trying to put another "0" index in the table.

And, in your CreateTable section, specify the createFlags argument, that if omitted, defaults to "none".

This is how i do it. "_dbPath" is the path to the database file in IsolatedStorage:

using (_connection = new SQLite.SQLiteConnection(_dbPath)) { _connection.CreateTable<T>(SQLite.CreateFlags.ImplicitPK | SQLite.CreateFlags.AutoIncPK); }

This will made your Id field an indexed primary key, autoincremental.

Baby Groot · Accepted Answer · 2014-10-29 12:55:23Z

0

I think using the below code will help you.

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

edited Oct 29, 2014 at 12:55

Baby Groot

4,27939 gold badges55 silver badges70 bronze badges

answered Oct 29, 2014 at 12:52

user3898309

21

1 Comment

Brandon Griffin Over a year ago

exactly what i needed

konradowy · Accepted Answer · 2015-05-27 10:06:14Z

I had a similar issue.

Try to reset simulator:

Step 1: Goto C:\Program Files (x86)\Microsoft XDE\8.1\ Step 2: Run XdeCleanup.exe

and rerun you app.

It happened for me because I had created a database without primary key and auto increment and then added it to the code. But somehow the state without PK&AI was cached in simulator.

tbear · Accepted Answer · 2024-01-04 12:32:16Z

If you're using sqlite-net-pcl nuget, it might be because your using InsertOrReplace. See https://stackoverflow.com/a/77755612/14161217

Collectives™ on Stack Overflow

AutoIncrement is not working with sqlite-net Client in windows phone universal App

4 Answers 4

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Linked

Related