Using LINQ to Entities in the data access layer
Next we will modify the
data access layer to use LINQ to Entities to retrieve and update products. We will first create
GetProduct to retrieve a product from the database and then create
UpdateProduct to update a product in the database.
Adding a reference to the BDO project
Now we have the BDO project in the solution, we need to modify the data access layer project to reference it.
- In the Solution Explorer, right-click on the LINQNorthwindDAL project.
- Select Add Reference....
- Select the LINQNorthwindBDO project from the Projects tab under Solution.
- Click on the OK button to add the reference to the project.
Creating GetProduct in the data access layer
We can now create the
GetProduct method in the data ...