LINQ (Language Integrated Query) is a uniform way of querying different datasources. You will see what LINQ is, and see some examples of datasources you can use it on.
Topics:
In this module you will get an overview of the different additions and enhancements added to the .NET languages to make LINQ possible.
Topics:
In this module you will learn the basic query-functionalities of LINQ. You will learn how to filter, select, order and group your data.
Topics:
Sometimes you need somewhat more than just basic queries. You will see how to create union queries, aggregate data and more.
Topics:
How do you query XML ? You could have a look at XPath, but you can't really call that easy and readable. Linq to XML allows you to create queries using all the operators you have seen. Next to that, you can also use LINQ to XML to generate XML. No string-concatenation needed !
Topics:
When a database is designed, the ideal is to normalize data, i.e. avoid duplicate data. When designing the objectmodel for an application you try to come up with a design which is best suited for solving your businessproblems. This means that mapping tables to classes one-on-one is often a bad idea. The Entity Framework allows us to map the relational world to the world of objects, allowing more complex mapping.
Topics:
In this module you will learn the basics of creating models for the Entity Framework. Different mappingstrategies will be discussed.
Topics:
What comes first: the database or the application ? Entity Framework gives multiple options: database first, or model first. Or you just start writing your classes, using Code First.
Topics:
In this module you will learn how Entity Framework tracks if you changed any data. You will also see how to create, update and delete data.
Topics:
Entity Framework Code First allows you to map your self-written classes to the database. Mapping will be defined by using attributes or by using the Fluent API. And you can even have a database generated for you when you run the application.
Topics:
When using Code First, you can have a database generated based on your code. What if you add some additional properties and classes later on? With Code First Migrations you can upgrade or downgrade your database to a specific version of your code. No dropping of databased needed.
Topics:
In this module you will learn how to use transactions while working with the database. You will also see how concurrency is handled by the Entity Framework.
Topics:
With .NET Core also comes Entity Framework Core. A new implementation of EF, which can run cross-platform, on Windows, Mac and Linux. You will get a look at the differences between EF Core and EF 6
Topics:
Mapping in EF Core uses conventions, or Fluent API. You will see how to use Fluent API in EF Core.
Topics:
LINQ is the integrated query language in VB.NET and C#. LINQ will provide you with a unified query language to query data coming from databases, XML documents, .NET collections, SharePoint,... This training starts with a deep dive into the concepts of LINQ. Part two will provide you with an in depth training on Entity Framework and shows you the different code strategies in querying databases.
This course targets professional C# or VB.NET programmers who are well experienced with .NET and who are interested to learn about the new programming models introduced with LINQ and Entity Framework.