Hello
How could i perform join for three tables using entity framework.
The three tables are : Vehicle, Container,Custom_Captions
This is the sql statement:
- SELECT capt_ar as VehicleState,cont_name,vehl_drivername,vehl_name,vehl_entrancedate,vehl_customsdec,cont_rampid
- FROM Container INNER JOIN
- Vehicle ON Container.cont_vehicleid = Vehicle.vehl_VehicleID INNER JOIN
- Custom_Captions ON Vehicle.vehl_state = Custom_Captions.Capt_Code
- where capt_family='vehl_state'
- and vehl_Deleted is null and cont_Deleted is null
- and vehl_ClearanceCompany=471