Preview course for free

Preview this course for free.

To preview this course, you will need to create a free account. Once you register, we'll send
you right along and you will get access to the first task in the course (day 1).


No credit card or payment info is required. Existing users, sign-in to begin.

Preview this course for free.

To preview this course, you will need to create a free account. Once you register, we'll send
you right along and you will get access to the first task in the course (day 1).


No credit card or payment info is required. Existing users, sign-in to begin.

Take a class, join the instructor-supported online learning revolution.

Choose a class date below to get started. Every class comes with a complimentary subscription which begins immediately even if your class doesn't start for a week or two. You can be learning in just minutes.

Upcoming classes: Choose this date >>


Take this course.

You'll need to get a subscription to join this course.
Our subscriptions start at $29.

View your subscription options
Course Summary

The Introduction to data access in C# course is for C# developers who are comfortable in the language but have yet to dig into data-access via LINQ (aka language integrated query).

We begin by studying the foundations of LINQ and derivative data technologies (e.g. Entity Framework). This includes a quick review of the in-memory collections in C#, delegates and lambda expressions, and iterators (both explicit iterator classes and via the yield return keyword).

Next, we hit the main focus of the class: LINQ. This is a language concept which can be mapped to many data sources (database, in-memory collections, XML files, etc). The simplest way to learn LINQ is to start with a variant called LINQ to Objects which allows you to treat in-memory collections as databases.

After you are familiar with LINQ, we'll move on to two more key data sources which play well with LINQ: LINQ to XML and Entity Framework.

At the end of this course, you should be able to connect to a database or process an XML file using LINQ. You will know how to model your database entities in C# classes. You will have a solid foundation for building data-driven applications on most any .NET platform you choose going forward (e.g. ASP.NET or WPF).

Course Objectives

After completing this course, you should be proficient in the following:

  • Work with collections of items.
  • Define and use delegates as method parameters.
  • Write your own lambda expressions.
  • Use an iterator method to expose a large data set.
  • Write basic LINQ queries against in-memory collections.
  • Call LINQ methods like sum() max() and average().
  • Join data based on a shared key.
  • Create an XML document using LINQ to XML.
  • Use LocalDB as a development database.
  • Read database data with Entity Framework 4.
Edit video url:

Edit Course Objectives











Change objectives

Tasks

Search tasks

tasks found
Save
Preview this task « This task is available right now for free, no payment info required.
Work with collections of items
10 Activities | Time: 1h 11m | Types: Article (5) | Practice (3) | Video (2)
Define and use delegates as method parameters
15 Activities | Time: 1h 46m | Types: Blog (4) | Practice (7) | Video (4)
Use lambda expressions to call methods that require delegate parameters
9 Activities | Time: 1h 49m | Types: Article (2) | Practice (4) | Video (3)
Write an iterator method to expose a large data set
11 Activities | Time: 1h 19m | Types: Article (4) | Blog (2) | Practice (2) | Run (2) | Video (1)
Filter and Order Data Using LINQ to Objects
12 Activities | Time: 1h 27m | Types: Article (3) | Blog (1) | Practice (4) | Video (4)
Aggregate, Group, and Join Data Using LINQ to Objects
10 Activities | Time: 1h 38m | Types: Article (2) | Blog (2) | Practice (3) | Video (3)
Read and query an XML file using LINQ to XML
13 Activities | Time: 2h 8m | Types: Article (5) | Blog (1) | Practice (5) | Video (2)
Create an XML document using LINQ to XML
10 Activities | Time: 1h 19m | Types: Article (5) | Practice (4) | Video (1)
Use LocalDB as a development database
4 Activities | Time: 40m | Types: Blog (1) | Practice (2) | Video (1)
Read database data with Entity Framework 4
11 Activities | Time: 3h 24m | Types: Blog (1) | Practice (5) | Video (5)