Retrive data from two tables in asp.net mvc using ADO.Net Entity Framework
- by user192972
Please read my question carefully and reply me.
I have two tables as table1 and table2.
In table1 i have columns as AddressID(Primary Key),Address1,Address2,City
In table2 i have columns as ContactID(Primary Key),AddressID(Foriegn Key),Last Name,First Name.
By using join operation i can retrive data from both the tables.
I created a Model in…