读书人

求了句linq写法关于条件查询的isn

发布时间: 2011-12-29 22:09:38 作者: rapoo

求了句linq写法,关于条件查询的,isnull
var q = db.company_job.Count(u => u.sate == true && u.selectjob == Convert.ToInt32(rselectjob3.SelectedValue));

如何改成下面这句?
from company_job where selectjob=isnull(@selectjob,selectjob) and sate =1

谢谢

[解决办法]
var q = db.company_job.Count(u => u.sate == true
&& u.selectjob == (Convert.ToInt32(rselectjob3.SelectedValue) == xxx ? u.selectjob : Convert.ToInt32(rselectjob3.SelectedValue)));


????

读书人网 >.NET

热点推荐