1. Data Access

Data Access Project

The project that houses the data access layer is: WavePoetry/WavePoetry.DataAccess. The old data access (only referenced by the Test project) is: WavePoetry/WavePoetry.OldDataAccess.

Database Context/Connection

The application uses the Microsoft Entity Framework and the DbContext class is: WavePoetry/WavePoetry.DataAccess/WavePoetryModel.Context.cs.

Entity Types

The DbContext class contains DbSet properties for all the different entities represented by the database's tables. The classes for the DbSets are located in WavePoetry/WavePoetry.DataAccess and are as follows:

• award.cs
• award_categories.cs
• award_to_category.cs
• award_to_contact.cs
• contact.cs
• contact_categories.cs
• contact_to_category.cs
• review.cs
• shipment.cs
• title.cs
• user.cs

Querying the database

Classes that handle querying the database are located in WavePoetry/WavePoetry.DataAccess. They are suffixed with "Data" and are as follows:

• AdminData.cs
• AwardData.cs
• ContactData.cs
• ReviewData.cs
• ShipmentData.cs
• TitleData.cs