Data Access Using C#
Access a SQL database using both database-first and code-first approaches.
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
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
- Structured Query Language: (SQL) Level 1 or equivalent knowledge
- C# Programming: 2 or equivalent knowledge
- Visual Studio experience
Syllabus
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
Data Access Using C#
Total classroom hours
21 hours
Schedule
Online
Evenings, 6:30 PM - 9:30 PM, 7 T Th - 5/11/2023 - 6/1/2023
Quarter: Spring
Total cost
$749
Instructor: Shankar Pal
Shankar’s expertise lies in database management systems, data analytics, cloud computing and computer networking. He received his Ph.D. in Computer Science. He has worked in Microsoft SQL Server and Bing Advertising groups and has networking experience from F5 Networks and Motorola Solutions.
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