1 回答

TA貢獻1829條經驗 獲得超7個贊
我發現它無需編寫第二個select語句即可獲取 ID 和編號。這是我的代碼:
using (Database db = new Database())
{
Thing thing = new Thing();
string sql = @"insert into Things()
values ();
select ID, Number
from Things
where @@rowcount > 0 and ID = scope_identity();";
KeyMapper recentlyRecevedKeys = await db
.Database
.SqlQuery<KeyMapper>(sql)
.FirstAsync();
thing.ID = recentlyRecevedKeys.ID;
thing.Number = recentlyRecevedKeys.Number;
}
// Nested class
private class KeyMapper
{
public int ID { get; set; }
public string Number { get; set; }
}
- 1 回答
- 0 關注
- 124 瀏覽
添加回答
舉報