Kijan pou m konekte yon app C# ak SQL Server?

Question

Mwen gen yon app konsòl .NET e mwen vle li done nan yon baz SQL Server lokal. Mwen pa konn ki pakè pou m itilize.

Accepted Answer

Pou yon ti app, **Dapper** senp e rapid. Enstale pakè yo:

```bash
dotnet add package Microsoft.Data.SqlClient
dotnet add package Dapper
```

```csharp
using Dapper;
using Microsoft.Data.SqlClient;

var cs = "Server=localhost;Database=Lekol;Trusted_Connection=True;TrustServerCertificate=True";
await using var conn = new SqlConnection(cs);

var eleves = await conn.QueryAsync<Eleve>(
    "SELECT Id, Non, Klas FROM Eleves WHERE Klas = @klas",
    new { klas = "NS4" });

foreach (var e in eleves) Console.WriteLine($"{e.Id} {e.Non}");

record Eleve(int Id, string Non, string Klas);
```

Pwen enpòtan:
- Toujou itilize **paramèt** (`@klas`), pa janm konkatene tèks nan SQL la (injection SQL).
- `TrustServerCertificate=True` bon pou devlopman lokal sèlman.
- Pou yon app ki pi gwo ak anpil tab, gade **Entity Framework Core**.

1 Repons