var hydropsPositionsQry = from a in _smartWaterOneMapContext.HydropsPosition.Where(s => s.IsDeleted == false)
join b in _smartWaterOneMapContext.StStbprpB.Where(s => s.IsDeleted == false)
on a.Stcd equals b.Stcd into temp1
from t1 in temp1.DefaultIfEmpty()
select new
{
Hp = a,
Status = t1 != null ? t1.Status : null
};