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
Additional Options
- 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 WebDataDemo
folder:
Run this command to get ef core tools
dotnet tool install --global dotnet-ef
dotnet ef database update