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 […]

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 […]

With so many JavaScript frameworks out there, it can be difficult to choose which one you should focus on. But, if you are looking for a career as a front-end developer, the job description is likely to include a JavaScript framework. But which one should you focus on? Companies might not be using the framework […]

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 […]

Over the last few weeks, I’ve been exploring the functionality of XUnit. For anyone who doesn’t know, XUnit is one of the unit testing frameworks that are available for .NET. Here are some of the topics I’m going to cover. How to set up a test project In-order to create a test, you need to […]

Common SQL features regularly used in your web application will include the normal CRUD operations. However, SQL Server has many more features. Here are three that I picked out that you may not use too often: Check Constraints Check constraints is a way that you can check the integrity of your data when you are […]

As online security is becoming ever more important, having an SSL certificate on your website is an absolute must! If you are not sure whether the website you are visiting is secure or not, you can tell by the start of the web address. If the web address starts with https://, it’s running on an […]

I recently got more involved in the design side of a website. Traditionally, my main focus has been on server-side technologies and that has always been my strong point, but it’s good to refresh your skills in areas that you don’t have interaction on a daily basis. As you probably know, CSS (cascade style sheets) […]

.NET Core was born back in June 2016, and at time of writing, it’s now on to version 2.2, with a preview of version 3 available for download. But if you are still using .NET Framework for some or all of your projects, then it might not be obvious what’s different with .NET Core, or […]

Using an Angular project as a Single Page Application (SPA) is relatively straight forward in .NET Core. The ASP.NET Core project already has extensions that allow you to do this. You can find the Microsoft.AspNetCore.SpaServices.Extensions from Nuget and add it to your project. If you are running in development mode, you can use the AngularCliBuilder […]