Edit Question - KnowledgeHub

Title Body

There are some articles which indicate that async database calls are bad idea in .NET. Should my database calls be Asynchronous? Should my database calls be Asynchronous Part II On C# Async CTP, there is a System.Data.SqlClient.SqlCommand extension called ExecuteReaderAsync . I have some operations as below on my existing code: var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["hubConnectionString"].ConnectionString; using (var conn = new SqlConnection(connectionString)) { using (var cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "sp$DetailsTagsGetAllFromApprovedPropsWithCount"; cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { //do the reading } conn.Close(); } } There are several operations like this on my code. So, I am having thoughts on converting those to async. But on the other hand, I am not seeing much attraction on this approach out there (maybe I am not looking at the right direction, who knows!). So, is there any disadvantages of using this new async programming model here? Edit: Assuming I refactor the code as below: public async Task<IEnumerable<Foo>> GetDataAsync() { List<Foo> foos = new List<Foo>(); var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["hubConnectionString"].ConnectionString; using (var conn = new SqlConnection(connection

Tags (comma-separated) Cancel