Programming in C#: Implementing Data Access

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

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