PROGRAMMING IN C#: IMPLEMENTING DATA ACCESS

Overview/Description
Data access and management is a critical aspect of most enterprise applications. In this course, you’ll learn how to implement data access in C# applications. You’ll also learn about I/O operations, consuming data, using LINQ, serialization, and using collections.

Target Audience
Individuals with knowledge of object-oriented programming who want to learn the fundamentals of Microsoft Visual C#; individuals preparing for the exam 70-483 Programming in C#

Prerequisites
None

Expected Duration (hours)
1.9

Lesson Objectives

Programming in C#: Implementing Data Access

 

  • start the course
  • use the FileStream class to read from and write to files on a file system
  • use the WebRequest class
  • parse network credentials safely
  • use GZIPStream
  • implement asynchronous programming with C#
  • use a LINQ query to select database data
  • use anonymous types in a select statement
  • update database records through the Entity Framework model
  • use LINQ query operators to operate on data sequences and query .NET arrays and collections
  • force LINQ query execution
  • consume data from a web service
  • create an extension method to add functionality to a class without extending it through inheritance
  • access stored procedures from a model
  • use the LINQ to XML provider to load XML and loop through collections
  • use the LINQ to XML provider to parse attributes and query multiple elements
  • use XMLSerializer to serialize and deserialize XML
  • serialize and deserialize JSON data
  • serialize and deserialize binary data
  • distinguish typed and non-typed collections
  • work with collections
  • use the Dictionary object
  • use the generic List object
  • use the generic Queue object
  • implement .NET interfaces

Course Number:
wd_pgcs_a04_it_enus

Expertise Level
Intermediate