I'm looking for the counterpart of this T-SQL query:
SELECT *
FROM dbo.HSE_FOOD_INSPECTIONS i
INNER JOIN dbo.HSE_TYPE_OF_FOODS t
ON i.HSTOF_TYPE_OF_FOOD_ID=t.TYPE_OF_FOOD_ID
The expected result type should be IEnumerable<HseFoodInspection>.