这个语句 错在哪里哦

[阿里帽子]

sqlchaxun = ss + hh + ff + mm;

string strSql = "select COUNT(*) from (select ROW_NUMBER() over(order by [al].sj desc) as rowid ,* from [al] where zt = '0' " + sqlchaxun + ") as A INNER JOIN [sx] ON sxid=[sx].id INNER JOIN [fg] ON fgid=[fg].id INNER JOIN [hx] ON hxid=[hx].id INNER JOIN [mj] ON mjid=[mj].id INNER JOIN [sjs] ON sjsid=[sjs].id ";

var query = udc.ExecuteQuery<int>(strSql);

int wz = Convert.ToInt32(query);

//int wz = (from u in udc.al where u.zt == 0 where u.hxid == 1 select u).Count();


return wz;




框架 3.5

[阿里帽子]

var query = udc.ExecuteQuery<int>(strSql); 不能返回一个int 结果吗

[欧皇神降术]

query.ToInt32（）试下

[大葡萄八块一斤]

var query = udc.ExecuteQuery<int>(strSql).First();

[三楼の郎]

用ExecuteScalar