.NET tutorials

Setting up your DbContext for Entity Framework in .NET Core

How to set up a connection string, adding entities, setting up migrations and overriding any methods for your Entity Framework Core DbContext.

Hooking into Mediator pipelines

Using the MediatR library, we are going to hook into the pipelines, RequestPreProcessor and RequestPostProcessor. See a .NET Core MVC video on MediatR.

Examples using the sys schema in SQL Server

Use objects in the sys Schema to retrieve information about database tables, columns, views, stored procedures and info about clients connected to your DB.

How to create and read CSV, Excel and PDF files in .NET for free

Save time and money by automating CSV, Excel and PDF files in .NET. Working examples of how you can write and read these popular documents.

How to use SignalR when receiving a message from a RabbitMQ queue in .NET Core

Use the IHostApplicationLifetime parameter and Dependency Injection to consume a RabbitMQ on startup and send a SignalR message once a message is received.

Using LINQ expressions to build dynamic queries in Entity Framework

Make use of LINQ expressions to produce a Lambda expression dynamically. Build an expression for Entity Framework with the following clauses: And, Or, Any.

How the Mediator design pattern simplifies an application

See the benefits of the mediator design pattern with MediatR. Example of how to set up a request, send it through a request handler and return a response.

A beginners guide to xUnit

Use XUnit, the unit testing framework to create "Fact" and "Theory" methods and how you can use your constructor and the IDisposable objects in tests.

An efficient way of handling multiple actions through one route

Using a singleton is Dependency Injection to run and store all the different types of URL's and routing those URL's to different controllers and actions in MVC.

Changing controllers and actions using one route in ASP.NET Core

Find out how to build the functionality to direct one route to multiple controllers and actions in ASP.NET Core MVC and how it differs to ASP.NET MVC.