Last Updated: 2018-12-19
All data access in Piranha is implemented using
Linq Queries over
Entity Framework Core. In that sense Piranha should be compatible with all databases that have a provider for Entity Framework Core available. We try to keep the schema of Piranha as simple as possible only using:
Primary Key Constraints
Foreign Key Constraints
This way we try to stay clear of things that we know are implemented differently in different providers, for example
auto-increment columns. Some packages rely on external components (like
ASP.NET Identity) that does not have this approach, and for these we provide multiple packages managaging database migrations.
We only test and support SQLite, SQLServer and SQLAzure, the packages we have available for other database providers (for example MySql) are community initiatives. If you encounter any issues with other database providers than the ones specified above, support for these should be handled by the people providing these packages.