write join using lambada expression

Int64 productInfoId = 0;
using (var etgEntities = new DBETNetEntities())
{

var result = from profile in etgEntities.TbUserProfile
join product in etgEntities.tbProductInfo
on profile.UserInfoID equals product.UserInfoID
where profile.UserProfileID == userProfileId
select product;

productInfoId = result.FirstOrDefault().ProductInfoId;
}
return productInfoId;

Advertisement