Ensure Uniqueness of Nullable Columns
How do you ensure that duplicate keys are prevented on a column that allows NULL values?
How do you ensure that duplicate keys are prevented on a column that allows NULL values?
A colleague of mine had a requirement in which he was interested to put the configuration settings of an ASP.NET Core application inside a SQL Server table and read them at startup of the application with a mechanism similar to what we already have for JSON files; also he wanted to have the ability that these variable being overridden or override other settings if applicable. In this article, I am going to describe how that could be achievable and how to implement such feature.