Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
Perform Join on three tables using EF
Fares Ayyad
Oct 18 2016 6:48 AM
273
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
Skip 1st line while reading from csv file.
vs2015 or even Blend crashes on startup....