I'm using SqlKata to perform db queries.
This is what I'm trying to do:
var task1= GetData(id);
var task2 = HasPrivilege(Id);
await Task.WhenAll(task1, task2);
var data = await task1;
var hasPrivilege = await task2;
But I get the following error:
InvalidOperationException: BeginExecuteNonQuery requires an open and available Connection
I've registered SqlKata's QueryFactory
as below:
services.AddTransient(provider =>
{
var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection"));
var compiler = new SqlServerCompiler();
var queryFactory = new QueryFactory(connection, compiler);
queryFactory.Logger = compiled => Console.WriteLine(compiled.ToString());
return queryFactory;
});