dotConnect for PostgreSQL allows configuring creating and deleting database objects in the CreateDatabase() and DeleteDatabase() methods. These customizations are rather useful for the Code First approach. You can tweak the behaviour of the methods using the PgSqlEntityProviderConfig.DatabaseScript.Schema and PgSqlEntityProviderConfig.DatabaseScript.ForeignKey classes.

• DeleteDatabaseBehaviour. This enumeration determines the behavior of the DeleteDatabase() function.

  • ModelObjectsOnly - this is the default value. Only the tables that model objects are mapped to are created/deleted.
  • AllSchemaObjects - all tables will be created/deleted from schemas or databases that model objects were mapped to.

  • Schema - entire schema, containing model objects, is created/deleted. If the model contains objects from other schemas, these schemas will be created/deleted as well.

    Note that if there are model objects, mapped to database objects in other schemas, these schemas are created/deleted only when using the following database initialization strategies: CreateDatabaseIfNotExists, DropCreateDatabaseIfModelChanges, DropCreateDatabaseAlways or when explicitly using the CreateDatabase()/DeleteDatabase() methods of the ObjectContext class or the Database class that is used with DbContext instead of using a database initialization strategy. If you use the MigrateDatabaseToLatestVersion database initialization strategy, you need to generate a code-based migration and add SQL commands for creating/deleting necessary schemas using the Sql() method of the DbMigration class.

    If several schemas are specified in the Schema connection string parameter, all of these schemas are created/deleted.

  • Database - the entire database is deleted when calling DeleteDatabase(). When calling CreateDatabase(), dotConnect for PostgreSQL tries to create the database. The user must have enough privileges for these actions (for example, by default, postgres user has such privileges). If several schemas are specified in the Schema connection string parameter, all of these schemas are created/deleted.
• AuthorizationUsername - set the authorization user name.
• Extensions - when DeleteDatabaseBehaviour is set to DeleteDatabaseBehaviour.Database, this string list allows you to specify the list of extensions that will be automatically loaded when the database is created. This setting is ignored if DeleteDatabaseBehaviour is set to other value than DeleteDatabaseBehaviour.Database.

PgSqlEntityProviderConfig.DatabaseScript.ForeignKey Settings

• Enabled. Turns on/off generation of foreign constraints. The default value is true.
• IndexCreation. When set to true, an index is created for the columns being parts of the foreign key. The default value is true.