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).
After completing this course, you should be proficient in the following: