How to perform queries via SqlKata?

515 Views Asked by At

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;
});
0

There are 0 best solutions below