我想用sql查询获得最大代码(我的意思是列的最后一个id(
这是我的代码:
var qre = dbms.Database.SqlQuery<TCOD_BANKS>("SELECT MAX(CODE) FROM TCOD_BANKS");
var data_main11 = qre.ToList();
foreach (var x1 in qre)
{
var aasd = x1.CODE;
}
当我启动我的代码时,我看到这个错误
System.Data.Entity.Core.EntityCommandExecutionException: 'The data reader is incompatible with the specified 'DENAF1399Model.TCOD_BANKS'. A member of the type, 'CODE', does not have a corresponding column in the data reader with the same name.'
我的表是:TCOD_BANKS我的列id是:CODE作为int
请帮我
查询SELECT MAX(CODE) FROM TCOD_BANKS
将返回一个数字,因此您不能尝试读取具有TCOD_BANKS
类型项的结果集。试着从这样的结果中读取一个数字:
var qre = dbms.Database.SqlQuery<int>("SELECT MAX(CODE) FROM TCOD_BANKS").First();