Schema omitted from Code First generated script

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Globox
Posts: 4
Joined: Fri 14 Jul 2017 10:04

Schema omitted from Code First generated script

Post by Globox » Tue 08 Aug 2017 11:51

Hello!

We have a problem creating tables in a specific schema using Entity Framework 6.
The migration code from which the SQL script is generated looks like this:

Code: Select all

 CreateTable(
                "dbo.Users",
                c => new
                    {
                        Id = c.Long(nullable: false, identity: true),
                        Type = c.Int(nullable: false, defaultValue: 1,
                            annotations: new Dictionary<string, AnnotationValues>
                            {
                                { 
                                    "EnumValues",
                                    new AnnotationValues(oldValue: null, newValue: "1,2,3,4,5,6")
                                },
                            }),
                        Timestamp = c.DateTimeOffset(nullable: false, precision: 7),
                        EntityTypeName = c.String(nullable: false, maxLength: 128),
                        EntityId = c.Long(nullable: false),
                        UserId = c.Int(),
                        OriginalPropertyValues = c.String(),
                    })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Users", t => t.UserId)
                .Index(t => t.UserId);
However, after running Update-database, the script sent to the database looks like this:

Code: Select all

-- Script was generated by Devart dotConnect for Oracle, Version 9.4.314
-- Product home page: http://www.devart.com/dotconnect/oracle
-- Database version: Oracle 12.2.0.1
-- Script date 2017.08.08. 13:48:28

CREATE TABLE "Users" ( 
  "Id" NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY NOT NULL,
  "Type" NUMBER(10) DEFAULT 1 NOT NULL,
  "Timestamp" TIMESTAMP(7) WITH TIME ZONE NOT NULL,
  "EntityTypeName" NVARCHAR2(128) NOT NULL,
  "EntityId" NUMBER(19) NOT NULL,
  "UserId" NUMBER(10) NULL,
  "OriginalPropertyValues" NCLOB NULL,
  PRIMARY KEY ("Id")
)
Note the schema name 'dbo' missing this time, thus it creates the table for the currently logged in user (which has all the privileges to create objects in another schema).

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: Schema omitted from Code First generated script

Post by Shalex » Thu 10 Aug 2017 10:45

Please set config.Workarounds.IgnoreDboSchemaName=false;

EITHER in a static constructor of the context:

Code: Select all

    var config = Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
    config.Workarounds.IgnoreDboSchemaName=false;
OR in *.config:

Code: Select all

  <configSections>
  <section name="Devart.Data.Oracle.Entity"   type="Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfigurationSection,   Devart.Data.Oracle.Entity.EF6, Version=9.4.236.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
  </configSections>  
...
  <Devart.Data.Oracle.Entity xmlns="http://devart.com/schemas/Devart.Data.Oracle.Entity/1.0">
    <Workarounds IgnoreDboSchemaName="false" />
  </Devart.Data.Oracle.Entity>
For more information, refer to https://www.devart.com/dotconnect/oracl ... tions.html.

Post Reply