Click here to Skip to main content
15,889,176 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have two EntityModel(Two EDMX file)
First : AS_Model.edmx
In that i have one class
User_Master which contains columns : User_ID, User_Name
Second : GA_Model.edmx
In that i have one class
Address_Masster which contains columns : ADD_ID, User_ID, Village, District

Now I want to write the query in RawQuery in Entity like below

SQL
select User_Name,Village, District from User_master U inner join Address_Master A on A.User_ID=U.User_ID


Can anyone tel me how can i write this query in Entity in Raw query not in LINQ query.

In short i want to join two tables which are from two different EDMX file.

Thanks in Advance
Suman Zalodiya
Posted
Updated 17-Mar-15 23:13pm
v2
Comments
Maciej Los 18-Mar-15 5:47am    
What is "raw query"? Why don't you want to use Linq?
Suman Zalodiya 18-Mar-15 7:58am    
I want to make it database independent. If i'll use Linq then it won't run for all database.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900