C#

public static DataTable ReadDataByCommand(this SqlCommand command, bool mapResultsToDatabase = true)
        {
            try
            {
                using (var sqlDataAdapter = new SqlDataAdapter(command))
                {
                    var resultTable = new DataTable();

                    if (mapResultsToDatabase)
                    {
                        sqlDataAdapter.FillSchema(resultTable, SchemaType.Mapped);
                    }

                    sqlDataAdapter.Fill(resultTable);

                    return resultTable;
                }
            }
            catch (SqlException ex)
            {
                var exNew = new Exception(command.BuildErrorMessage(), ex);
                throw exNew;
            }
            catch (InvalidOperationException ex)
            {
                var exNew = new Exception(command.BuildErrorMessage(), ex);
                throw exNew;
            }
            catch (Exception ex)
            {
                var exNew = new Exception(command.BuildErrorMessage(), ex);
                throw exNew;
            }
        }

MessageBox.Show(!string.IsNullOrWhiteSpace(_signature) 
    ? $"This is my signature:{Environment.NewLine}{_signature}": "404-Signature not found");

Quote:

Please note that the "DbConnection" is defined within the class and the class is registered as Singleton.

Quote:

Cascadia Code is a new monospaced font from Microsoft that provides a fresh experience for command-line applications and text editors. Cascadia Code was developed alongside Windows Terminal. This font is most recommended to be used with terminal applications and text editors such as Visual Studio and Visual Studio Code.

Dave Kreskowiak wrote:

but the FontDialog provided by the system (which the .NET class of the same name wraps) will not show them.

internal class PostSections
{
    public string title { get; set; }
    public string[] highlight { get; set; }
    public string[] highlight2 { get; set; }
    public bool highlightFirstWord { get; set; }
    public bool sendToValidation { get; set; }
    public string startDate { get; set; }
    public string endDate { get; set; }

    public List<Sectionquery> sectionQueries { get; set; }
}

var queries = new List<Sectionquery>()

queries.Add(new SectionQuery() { ... });
queries.Add(new SectionQuery() { ... });
...

var newPost = new PostSections()
     {
         title = "Title of Book",
         highlight = list.ToArray(),
         highlight2 = list.ToArray(),
         highlightFirstWord = false,
         sendToValidation = false,
         startDate = "2022-11-22T00:00:00.000Z",
         endDate = "2022-11-22T00:00:00.000Z",

         sectionQueries = queries
     };

int count = ....;
var sections = new Sectionquery[count];
for (int i=0; i < count; i++)
{
  sections[i].id = ...
  sections[i].name = ...
}
newPost.sectionQueries = sections ;

var newPost = new PostSections()
{
  ...     
  sectionQueries = new Sectionquery[] 
   { 
     new {
           "1", // id
           "xxx", // name
           ...
         },
     new {
           "2", // id
           "yyy", // name
           ...
         },
   }
};

switch (number)
{
    case > 70:
    {
        ...
        break;
    }
    case > 50:
    {
        ...
        break;
    }
    case > 30:
    {
        ...
        break;
    }
    case > 20:
    {
        ...
        break;
    }
}

switch (number)
{
    case > 70:
    {
        // Process > 70
        // Process > 50
        // Process > 30
        // Process > 20
        break;
    }
    case > 50:
    {
        // Process > 50
        // Process > 30
        // Process > 20
        break;
    }
    case > 30:
    {
        // Process > 30
        // Process > 20
        break;
    }
    case > 20:
    {
        // Process > 20
        break;
    }
}