Month: February 2020

How to parse the name parts from a full name using SQL

Sometimes I come across situations where I need to extract the individual parts of a full name from a database record that relates to a person e.g. a customer or an employee. This may be part of general application logic or perhaps something that needs to be carried out during a database migration. For example,…

Time to Reflect… How to add properties to a C# object dynamically at runtime

InProgramming

Have you been searching for a way to dynamically add properties to an object at runtime using C#? If so, you may have come across how to do this using ExpandoObject. However, after some further research, perhaps you’ve determined that it’s not what you are really looking for. For example, you might be trying to…

Month: February 2020

How to parse the name parts from a full name using SQL

Time to Reflect… How to add properties to a C# object dynamically at runtime

How to print SQL Server messages to the output immediately

Introduction to the SQL Server MERGE statement

Operating on data via a SQL Server Stored Procedure efficiently with Table-Valued Parameters using C#