Fill DataTable asynchronously?

by

SqlDataAdapter was never updated to include the TPL version of the methods. You could do this:

await Task.Run(() => da.Fill(dt));

But that would be creating a thread that would do nothing useful.

A good approach would be to use something like this:

public async Task<DataTable> CallDb(string connStr, string sql)
{
    var dt = new DataTable();
    var connection = new SqlConnection(connStr);
    var reader = await connection.CreateCommand().ExecuteReaderAsync();
    dt.Load(reader);

    return dt;
}

Of course, some changes like using statements should be made. However, here you are using asynchronous calls the right way.

More Related Contents:

  1. How to get HttpContext.Current in ASP.NET Core? [duplicate]
  2. HTTP Error 500.30 – ANCM In-Process Start Failure
  3. System.Text.Json API is there something like IContractResolver
  4. How do you multi-target a .NET Core class library with csproj?
  5. Add client certificate to .NET Core HttpClient
  6. Is ConfigurationManager.AppSettings available in .NET Core 2.0?
  7. How to load assemblies located in a folder in .NET Core console app
  8. What are the costs and possible side effects of calling BuildServiceProvider() in ConfigureServices()
  9. Command dotnet ef not found
  10. Should I take ILogger, ILogger, ILoggerFactory or ILoggerProvider for a library?
  11. HTTP Error 500.19 when publish .net core project into iis with 0x80070005
  12. Manipulating images with .NET Core
  13. Is there a way to make a console application run using only a single file in .NET Core?
  14. Switch between dotnet core SDK versions
  15. .Net Core 2.0 Process.Start throws “The specified executable is not a valid application for this OS platform”
  16. ASP.NET Core appsettings.json update in code
  17. How to auto create database on first run?
  18. .NET Core vs Mono
  19. Get List element position in c# using LINQ
  20. File permissions on Linux/Unix with .NET Core
  21. Why does System.Text Json Serialiser not serialise this generic property but Json.NET does?
  22. How to SetBasePath in ConfigurationBuilder in Core 2.0
  23. Is it possible to compile a single C# code file with the .NET Core Roslyn compiler?
  24. Is there a built in way of using snake case as the naming policy for JSON in ASP.NET Core 3?
  25. ReadKey InvalidOperationException application does not have a console
  26. Cannot find command ‘dotnet ef’
  27. ASP.NET Core modify/substitute request body
  28. Getting nested properties with System.Text.Json
  29. Net Core: Execute All Dependency Injection in Xunit Test for AppService, Repository, etc
  30. ASP.NET Core configuration for .NET Core console application

Leave a Comment