public async Task <string> ExecuteSQLAsync(string query)
{
NpgsqlConnection conn = (NpgsqlConnection)AssignmentService.GetDbConnection();
await conn.OpenAsync();
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
DbDataReader reader = await cmd.ExecuteReaderAsync();
string output = "";
do
{
output += await GetSQLResultAsync(reader);
}while (await reader.NextResultAsync());
reader.Close();
return(output);
}