C#

Quote:

I want a popup asking me which one I want to use.

<system.web>
    <authentication mode="Windows" />
    <authorization>
        <deny users="?" />
    </authorization>
</system.web>

<system.webServer>
    <security>
        <authentication>
            <windowsAuthentication enabled="true" />
            <basicAuthentication enabled="true" />
            <anonymousAuthentication enabled="false" />
        </authentication>
    </security>
</system.webServer>

Quote:

This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false".

<section name="anonymousAuthentication" overrideModeDefault="Deny" />
<section name="basicAuthentication" overrideModeDefault="Deny" />
<section name="windowsAuthentication" overrideModeDefault="Deny" />

Quote:

The specified name does not begin with COM / com or does not resolve to a valid serial port. Parameter name: portName ParamName = portName "

public async Task<List<ReportData>> GetReportData(ReportArgsEntity args)
{
    // Make sure we're not blocking the UI thread:
    await Task.Yield().ConfigureAwait(false);
    
    using (var connection = new SqlConnection("..."))
    using (var command = new SqlCommand("...", connection))
    {
       await connection.OpenAsync();
       
       using (var reader = await command.ExecuteReaderAsync(CommandBehavior.CloseConnection))
       {
           var results = new List<ReportData>();
           
           while (await reader.ReadAsync())
           {
               ...
           }
           
           return results;
       }
    }
}

Richard Deeming wrote:

First of all, you should really be using Task.Run instead:

Task.Factory.StartNew(someAction, CancellationToken.None, TaskCreationOptions.DenyChildAttach, TaskScheduler.Default);

public static async Task<List<T>> ToListAsync(this IQueryable<T> query, DbContext context, CancellationToken cancellationToken = default)
{
    if (query is null) throw new ArgumentNullException(nameof(query));
    if (context is null) throw new ArgumentNullException(nameof(context));
    
    using (var command = (SqlCommand)context.GetCommand(query))
    {
        await command.Connection.OpenAsync(cancellationToken);
        
        using (var reader = await command.ExecuteReaderAsync(CommandBehavior.CloseConnection, cancellationToken))
        {
            return _context.Translate<T>(reader).ToList();
        }
    }
}

Richard Deeming wrote:

using (var reader = await command.ExecuteReaderAsync(CommandBehavior.CloseConnection, cancellationToken))
{
return _context.Translate<T>(reader).ToList();
}

public Task<List<ReportData>> GetReportData(ReportArgsEntity args)
{
    var t = Task.Run(() => 
    {
        var results = new List<ReportData>();

        using (var dc = GetDataContecxt())
        {
            results = (from c in dc.Companies
                        join ih in dc.InvoiceHeaders on c.Id equals ih.CustomerId
                        join id in dc.InvoiceDetails on ih.Id equals id.HeaderId
                        where c.Completed
                        select new ReportData
                        {
                            // Add data to properties here
                        }).ToList();
        }

        return results;
    });

    return t;
}

public async Task<List<ReportData>> GetReportData(ReportArgsEntity args)
{
    // Move the execution off the UI thread:
    await Task.Yield().ConfigureAwait(false);
    
    var query = from c in dc.Companies
                join ih in dc.InvoiceHeaders on c.Id equals ih.CustomerId
                join id in dc.InvoiceDetails on ih.Id equals id.HeaderId
                where c.Completed
                select new ReportData
                {
                    // Add data to properties here
                };
    
    return await query.ToListAsync(dc);
}