Dot Net Data Access Tour
A tour of different data access approaches in .NET 5+.
Note: This is meant to demonstrate different ways to make data access calls, not best practices (or even reasonably good practices) for building ASP.NET Core Web APIs.
Data Access Options (CRUD + Queries)
- ADO.NET Custom SQL
- ADO.NET Stored Procs
- Dapper Custom SQL
- Dapper Stored Procs
- EF Core + Custom Queries
- Repository layer
- Application layer
Running the App - Create the Database
EF and its Migrations are not required for all of these variants, but it does provide a quick and easy way to get your data in place if you want to run these samples. Just run this command from the
Run this command to get ef core tools
dotnet tool install --global dotnet-ef
dotnet ef database update