Chapter 19B. Displaying Data in MVC
Most web applications display data from a database. In this lesson I show you how to use the DataLayer
that you created in the previous lesson to display data in an ASP.NET MVC application.
REFERRING TO THE DATALAYER
To use the DataLayer
from the previous lesson you must first add a reference to the assembly. You can do this a couple of ways:
Add the
DataLayer
project to the current solution and add a reference to theDataLayer
project.Add a reference directly to the
DataLayer
assembly (DLL).
Either way, you need to add the connection string to the web.config
file. This is the connection string from Lesson 18:
<add name="RecipeDBEntities" connectionString= "metadata=res://*/DataModel.csdl|res: //*/DataModel.ssdl|res://*/DataModel.msl;provider=System.Data.SqlClient;provider connection string="DataSource=.\SQLEXPRESS; AttachDbFilename=C:\ASPNETTrainer\DataLayer\Recipes.mdf;IntegratedSecurity=True; Connect Timeout=30;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
This is the reference to the Entity Data Model that I use throughout this lesson:
RecipeDBEntities _entity = new RecipeDBEntities();
USING VIEWDATA
The SelectList
class represents a list from which the user can select an item. In this case, the CategoryList will be used to populate a drop-down list. This is a Select
action method that reads all of the records in the Category table, sorts them by Name, and returns them to the Select view using the ...
Get ASP.NET 4 24-Hour Trainer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.