How to show multiple database table data in one view in MVC

Nagesh Bulbule

10y834.NET

Hello,

Below is my database example for understanding clearly

Database Name

Master1 & Master2 are different databases

1. Master1

Country

(

ID int,

CountryName varchar(50)

)

2. Master2

State

(

ID int,

StateName varchar(50),

CountryID int

)

There is no relationship on table

My question is

How to show these two table data into one view in asp.net mvc

I have one ViewModel as StateVM

One Controller as StateController

so please clear me how to show data using entity framework and Join.

how to show data in State View with proper country name

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel10y ago
Accepted answer
Hi ,
refer this link

http://www.codeproject.com/Articles/687061/Multiple-Models-in-a-View-in-ASP-NET-MVC-MVC

http://www.codeproject.com/Articles/730953/Cascading-Dropdown-List-With-MVC-LINQ-to-SQL-and-A
Vinay Singh10y ago
Prepare a model class and assign the both the table values and return it to view and display it on view.
http://www.asp.net/mvc/overview/getting-started/introduction/accessing-your-models-data-from-a-controller