FoxLearn | How to

How to Query JSON in SQL Server

3/20/2025 2:27:07 AM 30

Since SQL Server 2016, Microsoft has provided built-in support for managing and querying JSON data. This enables users to store, retrieve, and manipulate JSON documents directly within SQL Server.

How to modify JSON in SQL Server

3/20/2025 2:18:50 AM 28

In SQL Server, there are a couple of ways to modify JSON data within a table:

How to Check if an IP range is valid in C#

3/20/2025 2:03:58 AM 30

If you have an IP range defined by a starting and ending IP address (e.g., from user input or a configuration file), you can validate it using the following steps:

Merge two dictionaries in-place in C#

3/20/2025 1:57:16 AM 46

When merging two dictionaries, you have the option to either perform the merge in-place or create a new dictionary and copy the values over.

Generating XML Documentation and Including It in a NuGet Package in C#

3/20/2025 1:50:18 AM 40

XML documentation comments in C# serve two main purposes:

How to Read a custom config section from app.config in C#

3/20/2025 1:48:17 AM 25

In this article, I’ll show you how to retrieve a custom configuration section from app.config and load it into your own configuration class.

Duplicate 'AssemblyVersion' attribute in C#

3/20/2025 1:35:43 AM 35

When you try to add the AssemblyVersion attribute to your project, for example, to auto-increment the version:

Invoke or BeginInvoke cannot be called on a control until the window handle has been created

3/20/2025 1:32:36 AM 13

In a WinForms project, if you try to call Invoke or BeginInvoke on a control before the window handle has been created, you'll encounter the following exception:

How to convert string into Secure string in C#

3/19/2025 8:40:37 AM 781

A SecureString in C# is designed to securely store confidential information such as passwords and PIN codes. It ensures that sensitive data is encrypted and remains protected in memory.

How to retrieve the Executable Path in C#

3/19/2025 8:38:39 AM 3.02K

In C#, you can retrieve the executable path of the current application using the System.Reflection namespace.

Connection string password with special characters in C#

3/19/2025 8:34:39 AM 2K

When you create a connection string in C# that includes a password with special characters, it's important to properly format and escape those characters to ensure the connection string is interpreted correctly.

Async/Await with a Func delegate in C#

3/19/2025 8:29:30 AM 325

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

How To