This question is locked. New answers and comments are not allowed.
Hi there..
I have developed a small layered MVC application. The layers are as follows:
1. Presentation Layer (MVC project)
2. Data Layer (Repository Pattern)
3. Business Logic Layer (Validator Layer)
4. Service Layer (Controllers of MVC connect to the data layer through this layer).
Uptil now all the work that i have done is pretty simple. Creating repositories for each table and then calling them through the service layer. but now i want to get data from two tables. into one grid. I have two tables and I have create a foreign key relationship between them. By refrencing the Primary key of the table i want to get other info. Can anyone tell me how is it possible? Also i will be able to provide code if this isnt understood.
Thanks
I have developed a small layered MVC application. The layers are as follows:
1. Presentation Layer (MVC project)
2. Data Layer (Repository Pattern)
3. Business Logic Layer (Validator Layer)
4. Service Layer (Controllers of MVC connect to the data layer through this layer).
Uptil now all the work that i have done is pretty simple. Creating repositories for each table and then calling them through the service layer. but now i want to get data from two tables. into one grid. I have two tables and I have create a foreign key relationship between them. By refrencing the Primary key of the table i want to get other info. Can anyone tell me how is it possible? Also i will be able to provide code if this isnt understood.
Thanks
1 Answer, 1 is accepted
0
Moiz
Top achievements
Rank 1
Rank 1
answered on 13 Jul 2011, 08:21 AM
ok i have achieved the desired result using sql views. if anyone wants to know i can provide them with the code files...