Databases

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
  • Unique Indexes

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.

Official Support

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.

Setting Up Database Provider

You can read more about how to configure your application for the different databases in their respective sections.

SQLite SQLServer / SQLAzure