How to wait for the response of sql query execution?

Question

ASP.NET

There is a rather long running SQL query
In C # I fill the List through it through EF in this way

lstGrafic = db.Database.SqlQuery<GraficInfo>(
                                                            s,
                                                            new SqlParameter("@dateStart", this.dateStart)
                                                        )
                                                        .OrderBy(x => x.VD)
                                                        .ToList();

I get an error

System.ComponentModel.Win32Exception (0x80004005): Operation timed out

If you go through the debugger step by step or just put it after
Thread.Sleep(30 * 1000);
, then everything works out the rules.
But this approach seems to me a crutch. Are there any good practices for properly handling waiting for a result from a sql query?

Answer 1

Use async/await. You need to wait in a separate thread.

Answer 2

use the TPL library or async/await. it's just that when you need a response from the database, just turn on the "wait" method (the wait method for TPL, await for async) and when it works, do whatever you want.