Retrieve the Inserted ID after executing ExecuteSqlCommand?

Question

I would like to retrieve the inserted ID after executing this command:

db.Database.ExecuteSqlCommand("INSERT INTO Table_Ressources (IdTypeRessource, IdSociete, IdTypeFormatIntitule_UR)Values (1,1,1);

How should I do it please?

Here the primary key colum is identity column and it's none of the columns specified here in question? — Chetan, Feb 21 '17 at 14:10

score 2 · Answer 1 · edited May 23 '17 at 10:29

You want to use OUTPUT with ExecuteScalar to return the ID of the record INSERTED (or even updated).

INSERT INTO Table_Ressources (IdTypeRessource, IdSociete, IdTypeFormatIntitule_UR) 
OUTPUT INSERTED.Id
VALUES (1,1,1);

The statement will return the ID of the inserted record.

Some reference:

score 0 · Answer 2 · answered Feb 21 '17 at 14:12

0

Try adding SELECT SCOPE_IDENTITY() to the command, and look at the return value of ExecuteSqlCommand

answered Feb 21 '17 at 14:12

Tsahi Asher

score 0 · Answer 3 · answered Feb 21 '17 at 14:14

0

You need to use the "ExecuteScalar" instead of "ExecuteSqlCommand". The ExecuteScalar does what you need as explained here:

answered Feb 21 '17 at 14:14

Balbinator

3 Answers3