Access a SQL Server database by applying the Entity Framework using both the database-first and code-first approaches. Use Language-Integrated Query (LINQ) to query and update arrays, entities and XML documents. Acquire the skills needed for working with various types of data stores using LINQ and the Entity Framework in your C# applications.

• Structured Query Language: (SQL) Level 1 or equivalent knowledge
• C# Programming: 2 or equivalent knowledge
• Visual Studio experience

Objective 1

Query and update relational data applying the database-first approach for creating an Entity Data Model (EDM) using the Entity Framework (EF) and LINQ to Entities.

• Connect, query and update a database using ADO.NET
  Query data in arrays and generic lists using LINQ to Objects
• Create an EDM using the database-first approach, and query and update relational data using the EDM and LINQ to Entities
• Insert, update and delete rows in a database using the EDM and state management

Objective 1 Assignments

Book A

• Chapter 1: pages 3–7
• Chapter 2: page 32 (Server Explorer)
• Chapter 8: pages 121–133
• Chapter 9: pages 125–139
• Chapter 10: pages 153–159
• Chapter 13: 213–223
• Chapter 14: pages 225–231, 241–242
• Chapter 17
• Chapter 19: pages 315–319
• Complete labs in class
• Complete skill check A (Required)

Objective 2

Create a database and an EDM by applying the code-first approach using the EF, and query and update relational data using the EDM and LINQ to Entities.

• Create a database and an EDM by applying the code-first default approach for querying and updating relational data
• Create a database and an EDM by applying attributes with the code-first approach for querying and updating relational data
• Audit concurrency issues using the code-first approach
• Check for concurrency issues using the Concurrency Manager and the code-first approach

Objective 2 Assignments

• Book B: read Chapter 23: pages 929–993 (Exclude Interception)
• Complete labs in class
• Complete skill check B (Required)

Objective 3

Import and export data between a SQL Server database and XML files using LINQ to Entities to create XDocument objects for exporting to XML files and LINQ to XML to create entity objects for importing from XML files.

• Create, query and update an XML file using LINQ to XML
• Export data from a database table to an XML file
• Import data from an XML file using LINQ to XML and load it into a database table

Objective 3 Assignments

• Book B: read chapter 24
• Complete labs in class
• Complete skill check C (Required)
• Complete course evaluation