in controller NLPEntities _Context = new NLPEntities(); List<ShipmentData> _shipData = new List<ShipmentData>(); var _shipmentdata = (from sh in _Context.Shipments join inct in _Context.Incoterms on sh.IncotermId equals inct.Id select new { sh.Piece, ...