Skip to content

Database Providers

Entity Framework Core Generator (efg) supports the following databases.

  • SQL Server
  • PostgreSQL
  • MySQL
  • Sqlite
  • Oracle

Database Schema

The database schema is loaded from SchemaSaurus for each supported provider.

Usage

The provider can be set via command line or via the configuration file.

Set via command line

efg generate -c <ConnectionString> -p <Provider>

Set in configuration file

database:
  connectionString: 'Data Source=(local);Initial Catalog=Tracker;Integrated Security=True'
  provider: SqlServer

Supported provider values are SqlServer, PostgreSQL, MySQL, Sqlite and Oracle.

Oracle

Use Oracle as the provider value to generate from an Oracle database schema.

database:
  connectionString: 'User Id=<User>;Password=<Password>;Data Source=<Host>:<Port>/<ServiceName>'
  provider: Oracle

Oracle provider support includes sequences and foreign keys. Schema filtering, identity columns, temporal tables and change tracking are not supported by the current Oracle provider defaults.