Category Archives: c#

C# Marking Deprecated Code As Obsolete

Posted on April 30, 2024 by briancaos

If a certain piece of code is no longer relevant or needed, or if it’s no longer maintained, you can mark it as obsolete. Use the [Obsolete] tag to mark the code. You can mark a function: Or you can … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , | Leave a comment

C# Game Of Life

Posted on April 16, 2024 by briancaos

The Game Of Life is a cell life simulator devised by the Cambridge mathematician John Conway. The simulator serves as an excellent coding example to learn new programming languages. The rules are simple. You have a grid in a predetermined … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , | 2 Comments

C# Connect to 2 or more databases using a Datacontext

Posted on January 29, 2024 by briancaos

This is more of a design pattern than it is a requirement. I use this technique when my application grows in size. When my application needs to connect to 2 or more databases, I use this encapsulation method to allow … Continue reading →

Posted in .net, .NET Core, c#, General .NET, Microsoft Azure | Tagged , , , , , , , , , , | Leave a comment

C# SqlBulkCopy insert a list of objects

Posted on December 8, 2023 by briancaos

The SqlBulkCopy class is able to bulk insert data from anything that comes from a DataTable or can be read using a SqlDataReader. So what do you do if you have an array of objects? You have to convert the … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , | 1 Comment

C# Convert array of objects into a DataTable

Posted on December 8, 2023 by briancaos

This extension method lets you convert an array of objects into a DataTable. DataTables are used for SQL inserts. This solution is not mine, in fact it has been copied so many times that I don’t know who came up … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , | 1 Comment

C# Inject ILogger into Dapper Polly Retry Policy

Posted on November 22, 2023 by briancaos

There are many articles describing how to make a retry policy when using Dapper. I especially like this extension method implementation. But you cannot inject any class into extension methods because extension methods reside in a static class. Therefore you … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , , , | Leave a comment

C# Dapper Async Bulk Inserts

Posted on November 21, 2023 by briancaos

In order for Dapper to do bulk inserts, you need a third-party library: UPDATE 2023-12-08: Please note that Z.Dapper.Plus is a licensed product and you must pay to use it. For a solution without licensing, check out this article: C# … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , | 1 Comment

C# Dapper convert numbers to 2 decimals

Posted on October 30, 2023 by briancaos

I had this problem when inserting numbers into a SQL database using Dapper. All of my numbers did not round correctly when being inserted, even when using Math.Round() before doing the insert. My class is something like this: And before … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , | 1 Comment

C# Application Insights Errors are Logged as Traces – How do I log them as Exceptions?

Posted on July 27, 2023 by briancaos

So when I log to Application Insights, I first follow this guide to set up Application Insights AND File logging: C# Log to Application Insights and File from your .NET 6 Application To create a log statement, I can now use … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , | 1 Comment

C# ‘SHA256Managed’ is obsolete: ‘Derived cryptographic types are obsolete. Use the Create method on the base type instead.’

Posted on July 25, 2023 by briancaos

So my code gives me this warning: Warning SYSLIB0021  ‘SHA256Managed’ is obsolete: ‘Derived cryptographic types are obsolete. Use the Create method on the base type instead.’ The code that warns me are: The reason is that SHA256Managed, SHA512Managed, SHA1Managed and … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , , , , | Leave a comment