MSSQL - ALTER TABLE only allows new columns which are nullable or have a DEFAULT value specified
If you are on this page you likely got an error like the following: Msg 4901, Level 16, State 1, Line 8 ALTER TABLE only allows »
C# Dapper - How to execute a select statement using a list of Ids with an IN clause in MSSQL
Using Dapper you can easily map results of a query to an object or a list of objects. Sometimes you want to select a list of »
C# Dapper - How to make select, insert, update and delete statements
Dapper makes it easy to "Execute a query and map the results - if any - to a strongly typed List". This post demonstrates how to »
C# Dapper - Return inserted identity
This post describes two ways to get the generated identity of a newly inserted row. We will use the following table simple table with an Id »
C# - How to connect to a MSSQL database using a SqlConnection
You can use the SqlConnection class to connect to a MSSQL server. If we have a database called MyDb with a simple table called MyEntities: CREATE »
Entity framework - How to add static data using data seeding
I am not sure that the correct term is "static" data - it seems to be known as seeding, which is the term I will use. »
Entity framework - How to set the connection string of the DbContext
It seems that every guide I find on Entity framework, the database connectionString is fetched from the config file magically. I wanted to inject it instead »
Entity framework - Unable to create an object of type <type>. For the different patterns supported at design time see <link>
Today I was trying to make an initial migration using Entity framework. I encountered an error when calling dotnet ef migrations add InitialCreate: C:\Users\peter\ »
MSSQL - A network-related or instance-specific error occurred
I have witnessed this error quite a few times in my career. I see it every time there is something wrong with the network in a »
MSSQL - How to select JSON values from a column and parse them to decimals or integers using JSON_VALUE
In this post I show how to select and cast values from a column containing JSON so that you can work with the fields as you »