Data Access Layer

CL1 (Qualified)
Manage connection strings and objects

Working with data providers

Connect to a data source by using a generic data access interface

Handle and diagnose database connection exceptions

Manage exceptions when selecting, modifying data

Build command objects and query data from data sources

Retrieve data source by using the DataReader

Manage data by using the DataAdapter and TableAdapter

Updating data

Entity Framework

Query data sources by using ORM (LINQ, Entity Framework, Nhibernate)

Model First VS Database First VS Code First Approaches

Entity Data Modeling Fundamentals Querying an Entity Data Model
 * Creating a Model
 * Modeling a Many-to-Many Relationship
 * Modeling a Self-Referencing Relationship
 * Splitting an Entity Among Multiple Tables
 * Splitting a Table Among Multiple Entities
 * Modeling Table per Type Inheritance
 * Modeling Table per Hierarchy Inheritance
 * Modeling Is-a and Has-a Relationships Between Two Entities
 * Creating, Modifying, and Mapping Complex Types
 * Querying Asynchronously
 * Updating with Native SQL Statements
 * Fetching Objects with Native SQL Statements
 * Querying a Model with Entity SQL
 * Returning Multiple Result Sets from a Stored Procedure
 * Comparing Against a List of Values
 * Filtering Related Entities
 * Applying a Left-Outer Join
 * Paging and Filtering
 * Grouping by Date
 * Grouping by Multiple Properties
 * Joining on Multiple Columns

CL2 (Competent)
Manage transactions

Manage data integrity

Executing asynchronous queries

Transform data by using ORM (LINQ, Entity Framework, NHibernate)

Caching data

Manage update conflicts between online data and offline data

Implement Synchronization Services

Working with untyped DataSets and Data Tables

Exposing DataTableReader from DataTable and DataSet

Working with strongly typed DataSets

Entity Framework

Manipulating data using LINQ

Understanding LINQ compilation

Loading Entities and Navigation Properties

Lazy Loading Related Entities

Using Include with Other LINQ Query Operators

Filtering and Ordering Related Entities

Modeling a Many-to-Many, Self-Referencing Relationship

Stored Procedures in the Entity Framework

Code First Migrations and Deployment with the Entity Framework

Async and Stored Procedures with the Entity Framework

Handling Concurrency with the Entity Framework 6