ExecuteStoreCommand返回

ExecuteStoreCommand返回-1，EntityFramework，C＃？(ExecuteStoreCommand returns -1 , EntityFramework , C#?)

我想获得下一个自动递增的主键， 在这里我理解使用T-SQL来做到这一点。 所以我写了以下方法：

public int GetLastNewsID() { const string command = @"SELECT IDENT_CURRENT ('{0}') AS Current_Identity;"; int id = EntityModel.ExecuteStoreCommand(command, "News"); return id; }

但它返回-1，而它现在必须是4。

PS：当我在SQL Management Studio中执行T-SQL下面时，它返回4

USE T; GO SELECT IDENT_CURRENT ('NEWS') AS Current_Identity; GO

I wanna get the next automatically incrementing primary key, Here I understood to use T-SQL for doing that. So I wrote the following method :

public int GetLastNewsID() { const string command = @"SELECT IDENT_CURRENT ('{0}') AS Current_Identity;"; int id = EntityModel.ExecuteStoreCommand(command, "News"); return id; }

but it returns -1, whereas it must be 4 right now.

P.S: When I execute below T-SQL in SQL Management Studio , it returns 4

USE T; GO SELECT IDENT_CURRENT ('NEWS') AS Current_Identity; GO

最满意答案

您需要使用ExecuteStoreQuery

public int GetLastNewsID() { const string command = @"SELECT IDENT_CURRENT ({0}) AS Current_Identity;"; var id = EntityModel.ExecuteStoreQuery<decimal>(command, "News").First(); return Convert.ToInt32(id); }

SQL查询将返回一个decimal因此您需要将其转换为int 。

You need to use ExecuteStoreQuery

public int GetLastNewsID() { const string command = @"SELECT IDENT_CURRENT ({0}) AS Current_Identity;"; var id = EntityModel.ExecuteStoreQuery<decimal>(command, "News").First(); return Convert.ToInt32(id); }

The SQL query will return a decimal so you need to convert it to int.