Home Documentation Playground

Query Execution

Query Execution

SqlKata provide an easy way to execute your queries, by using the famous package Dapper.

Installing Database Providers

In order to execute the queries, you need to install the needed Drivers for each Database Provider.

Sql Server

For Sql Server install System.Data.SqlClient package

dotnet add package System.Data.SqlClient

Postgre Sql

For Postgre Sql install Npgsql package

dotnet add package Npgsql

MySql

For MySql install MySql.Data package

dotnet add package MySql.Data --version 8.0.9-dmr