8,497
社区成员
发帖
与我相关
我的任务
分享
/*通过field_baseinfo.field_code查询得到crop_manageinfo.field_base_id
条件:field_baseinfo.id = crop_manageinfo.field_base_id
*/
select crop_manageinfo.field_base_id from crop_manageinfo where crop_manageinfo.field_base_id =(
select field_baseinfo.id from field_baseinfo where field_code = '1-1' )
crop_manageinfo.Where(a=>a.field_base_id==field_baseinfo.Where(b=>b.field_code=="1-1"
).Select(c=>c.id).Single()).Select(d=>d.field_base_id);
public string FindFieldIdByFieldcode(string fieldCode)
{
return dataContext.crop_manageinfo.Where(a => a.field_base_id == dataContext.field_baseInfo.Where(b => b.field_code == fieldCode
).Select(c => c.id).Single()).Select(d => d.field_base_id).ToString();
}
SELECT [t0].[field_base_id]
FROM [dbo].[crop_manageinfo] AS [t0]
WHERE [t0].[field_base_id] = ((
SELECT [t1].[id]
FROM [dbo].[field_baseInfo] AS [t1]
WHERE [t1].[field_code] = @p0
))
crop_manageinfo.Where(a=>a.field_base_id==field_baseinfo.Where(b=>b.field_code=="1-1"
).Select(c=>c.id).Single()).Select(d=>d.field_base_id);
var query=from cm in crop_manageinfo
join fb in field_baseinfo
on cm.field_base_id equals fb.id
where fb.field_code == "1-1"
select cm.field_base_id ;