[Solved] Get last inserted Id?

[Dirk]

In your DataStorageDemoXaml the database is created in the following way:

//table: Cities{CityID, CityName, Population} ; CityID field is autoincremental and auto generated
context.Insert(new Cities() { CityName = "New York", State = "New York", Population = 8300000 });
context.Insert(new Cities() { CityName = "Los Angeles", State = "California", Population = 3800000 });

//table: BikeStores {StoreID, CityFK, StoreName, StoreAddress}; StoreID field is autoincremental and auto generated
context.Insert(new BikeStores { CityFK = 1, StoreName = "Bikes for NY", StoreAddress = "8175 Thunder Bear Ramp" });

This is not realistic, even if it is a demo.
How can I know that the CityFK of New York is '1'?
How can I get the CityId of New York after inserting the dataset?

[Dirk]

Ok, I've found a solution.

context.Insert(new Cities() { CityName = "New York", State = "New York", Population = 8300000 });
context.SaveChanges();
string query = "select last_insert_rowid() as id from Cities";
var lastId = context.GetScalar<int>(query);

I have always to call SaveChanges and use the special query to get the last Id.
Is there no better way implemented?

[Bulent]

Hi Dirk,

Thank you for the good question.

Currently, we do not support database schema and particularly table relationships and foreign keys. That's why the developers should use some workarounds in order to maintain relations between tables. Your solution is good enough and it solves the issue.
We will add your request in our backlog and we will consider some improvements to simplify this scenario. 

Please, let me know should you have any other questions.

Regards,

Bulent
Telerik