I'm setting up a asp.net web server.
In page_load, i use async/await.
I want to know if the page thread can do something else while the operation is doing async / await.
For example, Can a page thread handle another page?
protected void Page_Load(object sender, EventArgs e)
{
//...
var taskResult = LoadData(sqlConn, sqlTran, 30)
if(taskResult.Result == true)
//...
}
public static async Task<Boolean> LoadData(SqlConnection sqlConn, SqlTransaction sqlTran, Int64 ID)
{
//...
using (var cmd = new SqlCommand("Proc_LoadData", sqlConn, sqlTran))
{
//..
using (var sqlData = await cmd.ExecuteReaderAsync().ConfigureAwait(false))
{
//..
}
}
//..
}