Installing a database provider
EF Core can use several different databases by using NuGet libraries as plugin database providers. You can find providers for MS SQL Server, MySQL, PostgreSQL, Oracle DB, and SQLite.
Since installing any SQL database server can be cumbersome, you will use SQLite, which also has the same query commands you would use in other databases. Entity Framework, being an ORM, handles all the compatibility of the query commands across different databases.
SQLite does not require a database server to run it and runs on Windows, Macbook, and Linux without any hassle. The easy setup and portability of SQLite make the perfect fit for your database provider while learning about EF Core and DbContext
.
So what software do you need now? You can download and install DB Browser for SQLite from https://sqlitebrowser.org/ or SQLiteStudio from https://sqlitestudio.pl/, which is both cross-platform and open source.
Important note
Installing a database server in...