dotConnect for Oracle 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 OracleEntityProviderConfig.DatabaseScript.Schema, OracleEntityProviderConfig.DatabaseScript.Table, OracleEntityProviderConfig.DatabaseScript.Column, OracleEntityProviderConfig.DatabaseScript.Index, and OracleEntityProviderConfig.DatabaseScript.ForeignKey classes.

OracleEntityProviderConfig.DatabaseScript.Schema Settings

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

  • ModelObjectsOnly - this is the default value. Only the tables and sequences that model objects are mapped to are created/deleted.
  • AllSchemaObjects - all tables (and corresponding sequences used for auto-increment columns in Oracle prior to Oracle 12c) will be created/deleted from schemas or databases that model objects were mapped to. In Oracle 12c, the sequences will be created/deleted only if config.DatabaseScript.Column.NumericIdentityBehavior = ExplicitTriggerAndSequence.

  • 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: There is no possibility to delete the user that is currently connected in Oracle. Thus, to call the DeleteDatabase() method, the user must have grants to delete users and must not have any database objects that model objects are mapped to.

• DefaultTablespace - set the name of default tablespace for the created schema.
• Grants - pass the list of grants for the CREATE USER statement.
• Profile - set the existing profile to the created user.
• TemporaryTablespace - set the name of temporary tablespace for the created schema.

OracleEntityProviderConfig.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.
• IndexTablespace. Specifies the tablespace for the created index.

OracleEntityProviderConfig.DatabaseScript.Table Settings

• Tablespace - sets the name of the tablespace for the created tables.

OracleEntityProviderConfig.DatabaseScript.Column Settings

• NumericIdentityBehavior. This property manages generation of columns with StoreGenerationPattern="Identity". This property can have the following values:

  • Default - for Oracle12c a column GENERATED ALWAYS AS IDENTITY is created. For earlier Oracle server versions, a sequence and a trigger are created. This is the default value.
  • ExplicitTriggerAndSequence - a sequence and a trigger are created.
  • None - nothing is generated.
  • ImplicitSequence - a column GENERATED ALWAYS AS IDENTITY is created. This value is deprecated. Use one of the below values instead.
  • GeneratedAlwaysAsIdentity - a column GENERATED ALWAYS AS IDENTITY is created.
  • GeneratedByDefaultAsIdentity - a column GENERATED BY DEFAULT AS IDENTITY is created.
  • GeneratedByDefaultOnNullAsIdentity - a column GENERATED BY DEFAULT ON NULL AS IDENTITY is created.

• MaxStringSize. This property determines a default size of the VARCHAR2 and NVARCHAR2 columns for Oracle 12c if it was not set explicitly in the Code-First CreateDatabase()/Code-First Migrations functionality. This property can have the following values:

  • OracleMaxStringSize.Standard - This is the default value. It means 4000 for VARCHAR2 and 2000 for NVARCHAR2.
  • OracleMaxStringSize.Extended - 32767 for VARCHAR2 and 16383 for NVARCHAR2.

OracleEntityProviderConfig.DatabaseScript.Index Settings

• Tablespace - sets the name of the tablespace for the created indexes.