EF Core integration
Microsoft's EF Core is the de facto ORM for .NET, with which you can work with major database providers, such as SQL Server, Oracle, MySQL, PostgreSQL, and Cosmos DB. It is the default database provider when you create a new ABP solution using the ABP command-line interface (CLI).
The startup template uses SQL Server by default. If you prefer another database management system (DBMS), you can specify the -dbms
parameter while creating a new solution, like so:
abp new DemoApp -dbms PostgreSQL
SqlServer
, MySQL
, SQLite
, Oracle
, and PostgreSQL
are directly supported.
Other Databases
You can refer to ABP's documentation to learn about up-to-date supported database options and how to switch to another database provider that the ABP CLI does not support out of the box: https://docs.abp.io/en/abp/latest/Entity-Framework-Core-Other-DBMS.
In the next sections, you will learn how to configure the DBMS (although it is already done in the startup...