Instalando Dapper para usar com MySQL
- #Dapper
- #MySQL
Configurando Dapper e banco de dados MySQL
- Instalando Dapper
dotnet add package Dapper
- Instalando MySQL Data
dotnet add package Mysql.Data
Dentro de appsettings.json
{
"ConnectionStrings": {
"Default": "server=localhost;user=root;password=senhaUser;database=estacionamento_dapper;"
}
}
program.cs
using System.Data;
using MySql.Data.MySqlClient;
builder.Services.AddControllersWithViews();
var connectionString = builder.Configuration.GetConnectionString("Default");
builder.Services.AddScoped<IDbConnection>((sp) =>
new MySqlConnection(connectionString));