Binding to Data via Entity Framework or LINQ to SQL (Database First)
3 min to read
The DevExpress MVC VerticalGrid supports binding to an existing data source using the LINQ or the Entity Framework.
If you already have a database, the LINQ to SQL ORM Framework or the Entity Framework ORM can automatically generate a data model that consists of classes and properties that correspond to existing database objects such as tables and columns. This development approach is called "Database First".
This topic describes how to bind the MVC VerticalGrid to a data source using the "Database First" development approach.
Refer to the following MSDN Learning Center article to learn more about the LINQ to SQL ORM Framework: LINQ to SQL.
Entity Framework ORM
Before you start, make sure you have the Entity Framework installed. Learn more about how to get the Entity Framework from the following MSDN tutorial: Get Entity Framework.
Create an Entity Framework data model. The following walkthrough demonstrates how to reverse engineer a model from an existing database: Entity Framework Database First.
Rebuild the solution before going on to the next step.
Step 2. Add the VerticalGrid to the required View
Open the required View file (Index.cshtml in this topic), focus on the position in the code where you would like to insert the VerticalGrid, and right-click -> select "Insert DevExpress MVC Extension v19.2…"
The Insert Extension Wizard opens. Navigate to the tab with the Data extensions and select the VerticalGrid. Define the extension name and the partial view name. In the 'Model class' item select the data model class, in the 'Data context class' item select the data context class, select the columns you wish to display within the VerticalGrid and select the key field.
After performing these operations, the Insert Extension Wizard generates a partial view that contains the VerticalGrid's settings and inserts the necessary code into the corresponding controller class. As a result, you have a fully functional MVC VerticalGrid bound to an existing data source.