How To

How to find all the dependencies of a table in SQL Server

3/14/2025 4:49:56 AM 0

When working with a database in SQL Server, understanding the dependencies between tables, views, procedures, and other objects is essential. Often, you might need to track how tables are interconnected, especially when trying to identify which other tables, views, or stored procedures depend on a particular table.

How to Find Objects Referencing a Table in SQL Server

3/14/2025 4:41:24 AM 0

Renaming a table in SQL Server can be a tricky task, especially when there are numerous objects such as columns, stored procedures, functions, or views that rely on that table.

How to use JsonConverterFactory in C#

3/14/2025 3:45:51 AM 2

To use a JsonConverterFactory in C#, you need to create a custom JsonConverterFactory subclass and implement the necessary methods.

How to serialize non-public properties using System.Text.Json

3/14/2025 3:30:37 AM 15

By default, System.Text.Json.JsonSerializer only serializes public properties. If you need to serialize non-public properties, you have two main options:

The JSON value could not be converted to System.DateTime

3/14/2025 3:19:03 AM 11

When using System.Text.Json to deserialize a DateTime value, an error occurs if the value is not in the expected format. The default expected format is the ISO-8601-1:2019 format, such as 2025-03-12T12:35:34+00:00.

Case sensitivity in SQL Server

3/14/2025 3:13:35 AM 1

In SQL Server, the collation property controls case sensitivity. Case sensitivity can affect how data is sorted and queried, even down to column names, which must match exactly in a case-sensitive database setting.

Try/finally with no catch block in C#

3/14/2025 3:05:32 AM 2

In C#, a try/finally block is particularly useful when you need to guarantee certain actions will always be executed at the end of a method, regardless of whether an exception was thrown.

Parsing a DateTime from a string in C#

3/14/2025 2:56:59 AM 2

In C#, you can convert a string to a DateTime using the following methods:

Async/Await with a Func delegate in C#

3/14/2025 2:23:28 AM 213

To make a Func delegate awaitable, you need to return a Task from the delegate.

How to batch read with Threading.ChannelReader in C#

3/13/2025 3:13:43 AM 13

In scenarios involving a consumer/producer model, batching the consumption of items can be highly beneficial. Whether you’re inserting a bulk of records into a database or sending multiple data packets over HTTP, sending individual items one by one can be inefficient.

How to ignore JSON deserialization errors in C#

3/13/2025 3:05:04 AM 29

A single deserialization error can cause the entire process to fail.

JsonException: A possible object cycle was detected

3/13/2025 2:56:52 AM 14

When serializing objects in .NET, you may encounter a JsonException due to circular references between objects.