110,538
社区成员
发帖
与我相关
我的任务
分享
DevV8GlobalDataEntities oJsBaseContect = new DevV8GlobalDataEntities();
JobsDBHKEntities oJsResumeContect=new JobsDBHKEntities();
var oJsBase = oJsBaseContect.JsGlobal_JobSeekerBase.ToList();
var oJSResume = oJsResumeContect.JsResumes.ToList();
var query = from j in oJsBase
join r in oJSResume on j.Id equals r.JobSeekerId
where r.CreateCountry == "HK" && j.Id == 100003000010087
select new
{
j.Id,
r.ResumeTitle
};
foreach (var item in query)
{
Console.WriteLine(item.ResumeTitle);
}
Select * From ERP_Global(数据库).dbo.Base(表)
Inner Join ACM_User on ....
Where ....