There are many benefits to adding a React application to your ASP.NET Core application. The fact that you can house your front-end React tools with your API .NET tools in one application has to be one of the biggest. So how do you go about doing it? Well, if you have not created your React […]

In-order to use Entity Framework successfully, you need to set your DbContext. But what exactly is it? The DbContext is the relationship between the database and your application. You will configure your connection to the database and which entities you wish to query against inside the DbContext. You can set the entities by storing them […]

Entity Framework migrations have been around for some time. They are particularly useful if you are using Entity Framework code-first migrations. Migrations recognise changes in your Entity Framework pattern and script those changes. You can then perform those changes against your database. What is Code-First? Code-first is when you build up your entities inside your […]

Entity Framework is a Object Relational Mapper (ORM) that relates objects and properties in your .NET application with tables and columns in your database. As a result of it’s relationship between application and database, it has become widely used in .NET applications. For the purpose of this article, it is assumed that your database is […]

Ever been wondering what happens behind-the-scenes in MVC to render a page in an ASP.NET application? Wonder no more! I will take you through the processes that MVC does to solve that very action. Routes The first stage is that it will look through your list of routes. Declaring the Pattern Now, each route has […]

Recently, I wrote about a way that you can use one route to direct traffic to different controllers and actions in ASP.NET Core MVC. In that example, I mentioned that there were six different types of pages that would be handled by one route. This is great, but the problem I experienced was the data […]

When using Dependency Injection in a .NET Framework application, there is a popular NuGet package out there that developers are using. Autofac is the Dependency Injection package where you can include your dependencies on the start up of an application, and reference them at several stages of your application. Not only is it available in […]

We are going to be expanding on the mediator design pattern and seeing how we can hook into it’s pipelines. However, if you are unfamiliar with what the mediator design pattern is, or just want a refresher, then I recommend reading my article entitled “How the Mediator Design Pattern Simplifies an Application“. From that, we […]

As your computer application gets more complex, more classes may be added. So, the more classes you add, the more difficult it can be to communicate between these classes. This can be a problem if these classes are located in different assemblies. This is where the mediator design pattern comes in. With the mediator design […]

The Object Catalog and Dynamic Management Views are some of the features that are stored in the sys schema. They contains many objects that are built-in to every SQL Server database. Information about the tables, stored procedures and views contained within your database can be retrieved through these objects. They also give you information, like […]

It can be frustrating when the cause of your slow web application is down to the queries it makes to the database. This can be down to many reasons, including: Computer hardware Large volumes of traffic querying the database simultaneously Too many joins with other tables Querying against a table that has lots of records […]