Data Access Using C#

Access a SQL database using both database-first and code-first approaches.

course image

Course details

ceus icon CEUs 1.8

schedule icon Schedule Evenings

location icon Location Online, North Campus

cost icon Cost

Registration details

Data Access Using C#

Access a SQL database using both database-first and code-first approaches.

What you’ll be able to do — competencies

  • 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
  • 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
  • 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

Course description

expand drawer icon collaspe drawer icon

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.

Prerequisites

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

Syllabus

expand drawer icon collaspe drawer icon

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

Next available start dates

Online — Evenings

Registration open expand drawer icon collaspe drawer icon
Data Access Using C#
hours icon

Total classroom hours

21 hours

schedule icon

Schedule

Online

Evenings, 6:30 PM - 9:30 PM, 7 T Th - 10/20/2020 - 11/10/2020

cost icon

Total cost

$749

instructor icon

Instructor: Shankar Pal

notes icon

Notes

Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started