Database Connectivity Using Entity FrameworkAssignment OverviewThe previous unit covered using...

Question

Database Connectivity Using Entity Framework

Assignment Overview

The previous unit covered using ADO.NET to access a local database server. Using ADO.NET, you wrote and executed your own SQL statements to retrieve and update information. For this assignment, you will use Microsoft's Entity Framework (EF) to provide the data access layer in your registration application. Entity Framework is an object-relational mapper that uses the specific classes in your program to handle the retrieval and updating of data.

Assignment Instructions

Starting with the code from u06a1, reuse the user interface code.
Using the code-first workflow, revise the code for the Course class so that it uses the .NET Entity Framework to provide the data layer in the application.
Document the revisions to the code with comments.
Zip the completed Visual Studio solution and submit it as an attachment for this assignment.

Assignment Requirements

Be sure to do the following:

Write a syntactically correct C# console program that compiles and runs without warnings or errors.
Modify C# classes for domain-specific objects to work with Entity Framework to provide data access.
Use the .NET Entity Framework (code-first workflow) to map classes in an application to database tables.

unit-6-assignment-1-bjiheuma.zip

Bikram · Accepted Answer

C# windows App, Sql Server table access using Entity Framework Code First Approach.
1. Tables before we run the Project.
2. Project started.
3. Course table populated.
4. Course selected
3. Complete Registration, RegisteredCourses table populated.

Database Connectivity Using Entity Framework Assignment Overview The previous unit covered using ADO.NET to access a local database server. Using ADO.NET, you wrote and executed your own SQL...