SQL Server Merge

-

SQL Server has a MERGE statement that lets you do multiple actions in one statement - possibly inserts, updates, and deletes all at once.

Here's an example that shows this in action.

View code on GitHub

Comments

Post a Comment

Popular posts from this blog

DotNet CLI

-
Image
Don't be afraid of using the .NET CLI and skipping Visual Studio. Visual Studio Code is a fantastic IDE for .NET projects - obviously not as powerful as Visual Studio, but it's significantly lighter and faster, and the integrated terminal is desperately needed in Visual Studio. The .NET CLI is actually incredibly easy to work with. This video shows some of the basic commands. See the documentation for more. View code on GitHub
Read more

Switch Expressions

-
Image
The switch statement in C# has been there since the beginning. Originally it was for a simple data type only, and you could only go through cases of constant values. Now there's so much more. View code on GitHub
Read more

C# Yield

-
Image
When building a method that returns IEnumerable, you can use the yield keyword to return results one at a time, rather than returning a full collection. This is useful if your collection would be very large, or if you want results as fast as you can rather than waiting. View code on GitHub
Read more