You will begin this tutorial by making two changes to the database, both of which require corresponding changes to the data model that you created in the Getting Started with the Entity Framework and Web Forms tutorials.In one of those tutorials, you made changes in the designer manually to synchronize the data model with the database after a database change.In the third tutorial in this series you will add sorting and filtering functionality to the application.
In this tutorial, you will use the designer's Update Model From Database tool to update the data model automatically.
In Visual Studio, open the Contoso University web application you created in the Getting Started with the Entity Framework and Web Forms tutorial series, and then open the table, but no foreign key relationship is defined in the database.
You will also create an abstraction layer between your BLL and DAL that facilitates automated unit testing of the BLL.
This abstraction layer is implemented by creating an interface and using the interface when you instantiate the repository in the business-logic class.
To make it easier to do that, you will create a view in the database.
The view will consist of just the data needed by the drop-down list: the full name (properly formatted) and the record key.
This makes it possible for you to provide the business-logic class with a reference to any object that implements the repository interface.
For normal operation, you provide a repository object that works with the Entity Framework.
Like the Getting Started series, this tutorial series uses the ASP. This lets you combine the advantages of an n-tier approach with the benefits of using a Web Forms control for data access.
NET Web Forms model and assumes you know how to work with ASP. The control gives you more flexibility in other ways as well.
In Server Explorer, expand file, right-click the design surface, and select Update Model from Database. Store), right-click v Instructor Name and select Properties.