摘要:
select top PageSize * from( select row_number() over(order by id) as rows,* ) as t where rows > (PageSize*(PageIndex-1)) select * from( select row_number() over(order by id) as rows,* ) as ... 阅读全文
摘要:
var db = new DBEntities(); var query = from m in db.tables select new{ m.id,m.name }.ToList().Select(m=>new tables{m.id,m.name}).ToList(); 将赋值操作分为两步 参 阅读全文
摘要:
//参数直接写参数名 string Sql = "select * from [table] where field like @field"; //参数值里面加上通配符,varchar类型查询也不加单引号 var Param = new {field = "%{ParamValue}%"}; // 阅读全文