System.Data.SQLite

 Hi there,

Does anyone happen to know if there is a way in the Entity Framework to return me the ID of a just inserted row, assume the column is an integer type and is Identity column?  This feature should be similar to scope_identity() in T-SQL, or last_rows_affected() for Sqlite.  But since I'm not using sprocs, so I'm just wondering if there is a way to do this just within my C# code with linq to EF?  Maybe call on some functions or something, does anyone know?

Thank you so much,

Identity columns get its value after the entity is saved.

Given the following table:

CREATE TABLE T2 ( ID INTEGER PRIMARY KEY AUTOINCREMENT, Value TEXT)

The following code shows you the id for the inserted row:

using (TestEntities entities = new TestEntities())
{
    T2 t2 = new T2();
    t2.Value = "some value";
    entities.AddToT2(t2);
    entities.SaveChanges();

    Console.WriteLine(t2.ID);

}