Hello friends, Sometimes we get the data that needs to be unique but can also get NULL records. Existing ways to achieve uniqueness doesn’t allow NULLs (Primary Key) or allow max one NULL (Unique Constraint). Let’s take an example to understand this better. Suppose, you have an Employee table with fields like Id, FirstName, MiddleName,… Continue reading Store Multiple NULL values with unique data in SQL Server
Enable CORS in ASP.NET Core Web API
Hello friends, As we know that in Web API, CORS is by default disabled due to security reasons. and hence if a client tries to access API in different server and port, you can end up with error as “Origin http://localhost:xxxx is not allowed by Access-Control-Allow-Origin“ To enable it in ASP.NET Core Web API, there… Continue reading Enable CORS in ASP.NET Core Web API
Working with Prototype Design Pattern
Hello friends, I am resuming series on design patterns. Today we will go through another design pattern called Prototype. It falls under a creational pattern category. Before talking about its implementation let’s begin with defining it. A prototype is a design pattern that believes and enforces object cloning or copying over new object creation. But… Continue reading Working with Prototype Design Pattern