NULL - это специальное значение, которое используется в SQL для обозначения отсутствия данных. Оно отличается от пустой строки или нулевого значения, так как NULL означает отсутствие какого-либо значения в ячейке таблицы. История появления NULL в SQL довольно интересна и длинна. В начале 1970-х годов Д. Камерер (D. Chamberlin) и Р. Бойд (R. Boyce) предложили использовать реляционную модель для полной замены иерархических и сетевых моделей данных, которые были актуальны в то время....

Dapper is a lightweight ORM (Object-Relational Mapping) framework for .NET Core and is commonly used to query databases in .NET Core applications. Here are some of the advanced features of Dapper in .NET Core: Multi-Mapping: Dapper allows you to map multiple database tables to a single class. This is useful when you need to retrieve data from multiple tables and map them to a single object. ...

Handy guide how to enhance rating in Google and stand out from the crowd. You’ve deployed a promising website, but Google doesn’t show it in search results at all. I know how you feel. And if you don’t have many visitors, it’s like treasure lost in the desert. The possible reason why search engines ignore your web is because of poor web accessibility and SEO. These two aspects should not be underestimated when...

Accessibility may seem like a highly technical subject, but it’s really about simplicity. Website structure is a significant component of Search Engine Optimization (SEO). It only makes sense to consider SEO and accessibility together so that all users can access your website’s content, regardless of their ability. Since site structure is also a major component of SEO, it only makes sense to consider accessibility and SEO together. In fact, there’s so...

Continuous Integration (CI) allows you to continuously integrate code into a single shared and easy to access repository. Continuous Delivery (CD) allows you to take the code stored in the repository and continuously deliver it to production. CI/CD creates a fast and effective process of getting your product to market before your competition as well as releasing new features and bug fixes to keep your current customers happy. In this blog,...

Often, GraphQL is presented as a revolutionary new way to think about APIs. Instead of working with rigid server-defined endpoints, you can send queries to get exactly the data you’re looking for in one request. And it’s true — GraphQL can be transformative when adopted in an organization, enabling frontend and backend teams to collaborate more smoothly than ever before. But in practice, both of these technologies involve sending an...

Confused about choosing between struct and class in C#? Read this article to understand the differences and make an informed decision. In C#, there are two primary object types that developers can use to build their code: structs and classes. While these two types may seem similar at first glance, they have some key differences that set them apart from each other. In this article, we’ll explore what structs and classes are,...

Microservice architecture is one of the most discussed software architecture trends at the moment, and it has forever changed the way enterprise applications are built. Rather than the slow, complex monolithic approach of the past, developers and companies everywhere are turning to a microservices architecture to simplify and scale their structures. In fact, even companies like Amazon, Netflix, Spotify, and Uber have made the transition. Whether you want to get started with...

JavaScript is a versatile programming language that allows developers to create dynamic and interactive web applications. One common task in web development is to refresh or reload a web page, either to update its content or to trigger certain actions. In this article, we will explore different ways to refresh a page in JavaScript and understand the pros and cons of each approach. Why refresh a page in JavaScript? Refreshing a web page...

HTTP/3 is the latest version of the HTTP protocol, built on top of the QUIC transport protocol. It offers several advantages over its predecessors, including faster and more reliable connections, improved security, and reduced latency. In this article, we will explore how to implement HTTP/3 in your ASP.NET Core application. Step 1: Install the Microsoft.AspNetCore.Server.Kestrel.Https NuGet package To use HTTP/3 in your ASP.NET Core application, you need to install the Microsoft.AspNetCore.Server.Kestrel.Https NuGet...

Nowadays, everybody so concerned about DDD and how to implement business logic properly that people just forget about existence of other layers. Bada-bing bada-boom, other layers do exist. Shocked, don’t ya? Take your sit, you will be even more shocked when you realize this story dedicated to Application layer, also known as the least popular layer. I’ve seen multiple projects: some have it, some just don't understand what should be there and...

The main thing that you should know about Software Architecture reads as follows, “Graphical interface and data should be separated”. The worst thing you could do to your program is writing your code inside Form1.cs, HomeController.cs, MainWindow.cs etc. Do not write your code inside forms. Do not write your code inside controls. Do not write your code inside controllers. This may sound familiar to you. After all, this is the main...

Exploring nullability improvements in C# and the !, ?, ??, and ??= operators. Null is famously quoted as being the "billion-dollar mistake" due to the quantity of NullReferenceExceptions that we see in code (particularly when just starting out). The prevalence of null forces a significant amount of developer attention doing things like: Validating that parameters are not null. Writing conditional logic to prevent NullReferenceExceptions from occurring. ...

Constructor We have been using constructors in object-oriented programming languages such as Java, C++, etc. A constructor is a special type of static method which can be invoked using thenew keyword and used to initialize the fields of a newly created object. Problem with Constructors The name of the constructor must match the name of the class, hence you cannot give a meaningful name to the constructor. ...

Learn the key differences between abstract classes and interfaces in C# programming, and understand when to use each one effectively. In object-oriented programming, abstract classes and interfaces serve as blueprints for creating objects in C#. While they have some similarities, they each have unique features that make them suited for different situations. In this article, we will take a deep dive into abstract classes and interfaces in C#, examining the nuances and...

Clean code is a set of programming practices that emphasize the readability, maintainability, and simplicity of code. Writing clean code is essential because it helps developers to understand and modify code more efficiently, which can save time and reduce the risk of introducing errors. Benefits of Clean Code: Readability: Clean code is easy to read and understand, making it easier to maintain, debug, and update. When code is...

Master the art of caching in .NET applications to improve performance and user experience. Caching is a powerful technique to improve application performance and response times. By temporarily storing the results of expensive operations or frequently accessed data, you can reduce the load on your system and provide faster response times to users. In this article, I will explore various caching strategies and techniques in .NET to help you become a...

The HTTP protocol lets browsers and other applications request resources from a server on the internet, for example, to load a web page. HTTP/3 is the latest version of this protocol, which was published by the Internet Engineering Task Force (IETF) as a proposed standard under RFC 9114 in June 2022. It aims to make the web faster and more secure by providing an application layer over QUIC, a next-generation transport...

Introduction This article demonstrates Middleware concepts in ASP.NET Core. At the end of this article, you will have clear understanding on below points: What is Middleware? Why Middleware ordering is important? Understanding of Run, Use and Map Method. How to create a Custom Middleware? How to enable directory browsing through Middleware? What is Middleware? Middleware is a piece...

Application security is becoming a more and more important topic on a day-to-day basis. Unauthorized access to protected data can potentially cost millions of dollars in the form of various financial penalties. Almost every application needs some reliable tool to manage its users’ identities and accesses. There are a bunch of solutions on the market — both free and paid — that promise to provide such features. In today’s article, I...