I want to make his method an Asynchronous Task

Question

I want to make his method an Asynchronous Task

Ronald Rex 1,666

I am new to Asynchronous Tasks. I want to make the below method an Asynchronous Task. Thanks !!!

public static List<PersonModel> LoadPeople()
{
    using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
    {
        var output = cnn.Query<PersonModel>("Select * from Person", new DynamicParameters());
        return output.ToList(); 
    }   
}

Anonymous

2023-11-07T07:01:04.56+00:00
Hi @Ronald Rex , Welcome to Microsoft Q&A,

To make the LoadPeople method asynchronous, you can use the async and await keywords and change the return type to Task<List<PersonModel>>. Additionally, you should use the asynchronous methods provided by SQLite to avoid blocking the UI thread while the database operation is in progress.

public static async Task<List<PersonModel>> LoadPeopleAsync() { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { // Use the Dapper async Query method to fetch data asynchronously var output = await cnn.QueryAsync<PersonModel>("Select * from Person", new DynamicParameters()); return output.ToList(); } }

Accepted answer

0 additional answers

Your answer

Anonymous

2023-11-07T07:01:04.56+00:00

Hi @Ronald Rex , Welcome to Microsoft Q&A,

To make the LoadPeople method asynchronous, you can use the async and await keywords and change the return type to Task<List<PersonModel>>. Additionally, you should use the asynchronous methods provided by SQLite to avoid blocking the UI thread while the database operation is in progress.

public static async Task<List<PersonModel>> LoadPeopleAsync() { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { // Use the Dapper async Query method to fetch data asynchronously var output = await cnn.QueryAsync<PersonModel>("Select * from Person", new DynamicParameters()); return output.ToList(); } }

Answer 1

Karen Payne MVP 35,586 Volunteer Moderator

Try the following assuming this is Dapper. I removed the parameter part as you have no parameters in this case.

Note that the caller will have to use await on the method below.

Also, check out the following class for more on Dapper and this article.

public static Task<List<PersonModel>> LoadPeople()
{
    using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
    {
        return (List<PersonModel>)await cnn.QueryAsync<PersonModel>("Select * from Person");
    }   
}

Share via

I want to make his method an Asynchronous Task

0 additional answers

Your answer