Most common problems

DependenciesEntityFramework (>= 6.0.0 && < 7.0.0)Oracle.ManagedDataAccess (>= 12.1.2400 && < 12.2.0)

public class FoobarEntityConfiguration : EntityTypeConfiguration<Foobar>{  public FoobarEntityConfiguration()  {    ToTable("Foobar");    // More configuration here ...  }}

private void EnableDebugLogs(DbContext context){  context.Database.Log = s => Debug.WriteLine(s); // SQL writer}

public class FooDbContext : DbMigrationsConfiguration<FooDbContext>{  protected override void OnModelCreating(DbModelBuilder modelBuilder)  {    modelBuilder.HasDefaultSchema(" < Your connection string user here > ".ToUpper()); // Make sure it‘s upper case !  }}

public class FooMigrationConfiguration : DbMigrationsConfiguration<FooContext>{  public FooMigrationConfiguration()  {	DatabaseHelper.SetMigrationDirectory(this, " i.e. Contexts\Foo\Migrations  ");  }}public static void SetMigrationDirectory<TContext>(DbMigrationsConfiguration<TContext> migration, string migrationsPath) where TContext : DbContext{  if (string.IsNullOrEmpty(migrationsPath))  {    throw new ArgumentException($"{nameof(migrationsPath)} cannot be null or empty.");  }  if (migrationsPath.Contains("/"))    throw new ArgumentException($"Invalid {nameof(migrationsPath)}. Path should be valid Windows path. Use backslashes instead of slashes.");  migration.MigrationsDirectory = migrationsPath;}

<!--NLog configuration--><!--For more info visit: https://github.com/NLog/NLog website --><nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"      xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd"      autoReload="true"      throwExceptions="true"      internalLogLevel="Off"      internalLogFile="App_Data\nlog-internal.log" >  <targets>    <!--Puts logs into database-->    <target name="db" xsi:type="Database" commandType="Text" connectionStringName="FoobarDbContext">      <commandText>        insert into FOOBARSCHEMA."FOOBARTABLE"("Id", "Level", "Logger", "Message", "StackTrace", "Date", "TenantId", "UserId")        values(sys_guid(), :LogLevel, :Logger, :Message, :StackTrace, systimestamp, :TenantId, :UserId)      </commandText>      <!--Reserved words by Oracle (don‘t use them as variable names: Level, Date-->      <parameter name="LogLevel" layout="${level}"/>      <parameter name="Logger" layout="${logger}"/>      <parameter name="Message" layout="${message}"/>      <parameter name="StackTrace" layout="${exception:format=Message,Type,Method,StackTrace,Data:separator=\r\n\r\n:maxInnerExceptionLevel=10:innerFormat=Message,Type,Method,StackTrace,Data:innerExceptionSeparator=\r\n\r\n}"/>      <parameter name="TenantId" layout="${event-properties:item=TenantId}"/>      <parameter name="UserId" layout="${event-properties:item=UserId}"/>    </target>  </targets>  <rules>    <logger name="*" minlevel="Warn" writeTo="trace,db" />  </rules></nlog>

<appSettings file="AppSettings.config" />

<connectionStrings>       <add name="ApplicationDbContext"       providerName="Oracle.ManagedDataAccess.Client"       connectionString="User Id=ApplicationDbContext;Password=P4S5W0RD;Data Source=OracleDataSource;Persist Security Info=true" /></connectionStrings><entityFramework>  <defaultConnectionFactory type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework" />    <providers>    <provider invariantName="Oracle.ManagedDataAccess.Client"              type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  </providers></entityFramework><system.data>  <DbProviderFactories>    <remove invariant="Oracle.ManagedDataAccess.Client" />    <add name="ODP.NET, Managed Driver"         invariant="Oracle.ManagedDataAccess.Client"         description="Oracle Data Provider for .NET, Managed Driver"         type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  </DbProviderFactories></system.data><oracle.manageddataaccess.client>  <version number="*">  <dataSources>  <dataSource alias="OracleDataSource"              descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=http://www.mamicode.com/(SERVICE_NAME=ORC)))" />  </dataSources>  </version></oracle.manageddataaccess.client>

Could not load type ‘OracleInternal.Common.ConfigBaseClass‘ from assembly ‘Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342‘.

gacutil /u Oracle.ManagedDataAccess

C:\...\packages\Oracle.ManagedDataAccess.12.1.2400\bin\x64λ gacutil /u Oracle.ManagedDataAccessMicrosoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.33440Copyright (c) Microsoft Corporation.  All rights reserved.Assembly: Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=MSILUninstalled: Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=MSILNumber of assemblies uninstalled = 1Number of failures = 0

Type is not resolved for member ‘Oracle.ManagedDataAccess.Client.OracleException,Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342‘.

gacutil /i <dll_path>

Id = c.Guid(nullable: false, identity: true),

Id = c.Guid(nullable: false, identity: false, defaultValueSql: "SYS_GUID()"),

"Oracle 11.2.0.2.0 does not support APPLY" exception

properties["quartz.jobStore.driverDelegateType"] = "Quartz.Impl.AdoJobStore.OracleDelegate, Quartz";

["quartz.dataSource.default.provider"] = "OracleODPManaged-1211-40",

begin  execute immediate  ‘    create table "SCHEMA"."__MigrationHistory"    (      "MigrationId" nvarchar2(150) not null,      "ContextKey" nvarchar2(300) not null,      "Model" blob not null,      "ProductVersion" nvarchar2(32) not null,      constraint "PK___MigrationHistory" primary key("MigrationId", "ContextKey")    )  ‘;exception  when others then    if sqlcode <> -955 then      raise;    end if;end;/

BEGIN   FOR cur_rec IN (SELECT object_name, object_type                     FROM user_objects                    WHERE object_type IN                             (‘TABLE‘,                              ‘VIEW‘,                              ‘PACKAGE‘,                              ‘PROCEDURE‘,                              ‘FUNCTION‘,                              ‘SEQUENCE‘                             ))   LOOP      BEGIN         IF cur_rec.object_type = ‘TABLE‘         THEN            EXECUTE IMMEDIATE    ‘DROP ‘                              || cur_rec.object_type                              || ‘ "‘                              || cur_rec.object_name                              || ‘" CASCADE CONSTRAINTS‘;         ELSE            EXECUTE IMMEDIATE    ‘DROP ‘                              || cur_rec.object_type                              || ‘ "‘                              || cur_rec.object_name                              || ‘"‘;         END IF;      EXCEPTION         WHEN OTHERS         THEN            DBMS_OUTPUT.put_line (   ‘FAILED: DROP ‘                                  || cur_rec.object_type                                  || ‘ "‘                                  || cur_rec.object_name                                  || ‘"‘                                 );      END;   END LOOP;END;/

using System;using System.Data.Entity.ModelConfiguration.Configuration;/// <summary>/// String property configuration helpers./// More info about Oracle Data Provider mapping can be found here https://docs.oracle.com/cd/E63277_01/win.121/e63268/entityCodeFirst.htm/// </summary>public static class OracleStringPropertyConfigurationExtensions{  /// <summary>  /// Configures string property for valid NVarChar2 column.  /// Sets max length and encoding.  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <param name="maxLength">Column value max size. Size cannot be greater than 2000 bytes.</param>  /// <returns>Property configuration</returns>  public static StringPropertyConfiguration IsNVarChar2(this StringPropertyConfiguration property, int maxLength = NVARCHAR2_MAX)  {    if (property == null) throw new ArgumentNullException(nameof(property));    if (maxLength > NVARCHAR2_MAX) throw new ArgumentException($"Oracle nvarchar2 column accepts strings that are not greater than {NVARCHAR2_MAX}.");    property      .HasMaxLength(maxLength)      .IsUnicode(true);    return property;  }  /// <summary>  /// Configures string property for valid NVarChar2 column.  /// Sets max length and encoding.  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <param name="maxLength">Column value max size. Size cannot be greater than 4000 bytes.</param>  /// <returns>Property configuration</returns>  public static StringPropertyConfiguration IsVarChar2(this StringPropertyConfiguration property, int maxLength = VARCHAR2_MAX)  {    if (property == null) throw new ArgumentNullException(nameof(property));    if (maxLength > VARCHAR2_MAX) throw new ArgumentException($"Oracle varchar2 column accepts strings that are not greater than {VARCHAR2_MAX}.");    property      .HasMaxLength(maxLength)      .IsUnicode(false);    return property;  }  /// <summary>  /// Configures string property for valid NVarChar2 column.  /// Sets max length and encoding.  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <param name="maxLength">Column value max size. Size must be greater than 4000 bytes.</param>  /// <returns>Property configuration</returns>  public static StringPropertyConfiguration IsClob(this StringPropertyConfiguration property, int? maxLength = null)  {    if (property == null) throw new ArgumentNullException(nameof(property));    if (maxLength < CLOB_MIN) throw new ArgumentException($"To configure column as CLOB type set its max length to be greater or equal than {CLOB_MIN}.");    property.IsUnicode(false);    // String Length    if (maxLength.HasValue) property.HasMaxLength(maxLength);    else property.IsMaxLength();    return property;  }  /// <summary>  /// Configures string property for valid NVarChar2 column.  /// Sets max length and encoding.  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <param name="maxLength">Column value max size. Size must be greater than 4000 bytes.</param>  /// <returns>Property configuration</returns>  public static StringPropertyConfiguration IsNClob(this StringPropertyConfiguration property, int? maxLength = null)  {    if (property == null) throw new ArgumentNullException(nameof(property));    if (maxLength < NCLOB_MIN) throw new ArgumentException($"To configure column as NCLOB type set its max length to be greater or equal than {NCLOB_MIN}.");    property.IsUnicode(true);    // String Length    if (maxLength.HasValue) property.HasMaxLength(maxLength);    else property.IsMaxLength();    return property;  }  private const short NVARCHAR2_MAX = 2000;  private const short VARCHAR2_MAX = 4000;  private const short CLOB_MIN = 4001;  private const short NCLOB_MIN = CLOB_MIN;}

using System.Data.Entity.ModelConfiguration.Configuration;/// <summary>/// Binary property configuration helpers./// More info about Oracle Data Provider mapping can be found here https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm/// </summary>public static class OracleBinaryPropertyConfigurationExtensions{  /// <summary>  /// Configures property to map the type BLOB.  /// BLOB is equivalent of MSSQL Image type.  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <returns>Property configuration</returns>  public static BinaryPropertyConfiguration IsOracleImage(this BinaryPropertyConfiguration property)  {    if (property == null) throw new ArgumentNullException(nameof(property));    property.HasColumnType("BLOB");    return property;  }}

using System.Data.Entity.ModelConfiguration.Configuration;/// <summary>/// Decimal property configuration helpers./// More info about Oracle Data Provider mapping can be found here https://docs.oracle.com/cd/E63277_01/win.121/e63268/entityCodeFirst.htm/// </summary>public static class OracleDecimalPropertyConfigurationExtensions{  /// <summary>  /// Configures property to map the type Number with given scale and precision.  /// https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <param name="precision">Number of digits in a number.</param>  /// <param name="scale">Scale is the number of digits to the right of the decimal point in a number.</param>  /// <returns>Property configuration</returns>  public static DecimalPropertyConfiguration IsNumber(this DecimalPropertyConfiguration property, byte precision, byte scale)  {    if (property == null) throw new ArgumentNullException(nameof(property));    if (precision < 1 || precision > 38)      throw new InvalidOperationException("Precision must be between 1 and 38.");    if (scale > precision)      throw new InvalidOperationException("Scale must be between 0 and the Precision value.");    property      .HasColumnType("NUMBER")      .HasPrecision(precision, scale);    return property;  }  /// <summary>  /// Configures property to map the type Number(19,4).  /// This is equivalent of Money type from MS SQL.  /// https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm  /// </summary>  /// <param name="property">Property to be configured.</param>  /// <returns>Property configuration</returns>  public static DecimalPropertyConfiguration IsOracleMoney(this DecimalPropertyConfiguration property)  {    if (property == null) throw new ArgumentNullException(nameof(property));    property.IsNumber(19, 4);    return property;  }}

public class FoobarContext : DbContext, IFoobarContext{     ////////// DbSets //////////    protected override void OnModelCreating(DbModelBuilder modelBuilder)    {        foreach (var configuration in GetConfigurations())        {            base.OnModelCreating(configuration.ConfigureModel(modelBuilder));        }    }    protected virtual IEnumerable<IModelCreateConfiguration> ConfigurationsForMssql    {        get        {            yield return new MssqlModelCreateConfiguration();            // Add more ‘yield return‘ for more CreateConfigurations        }    }    protected virtual IEnumerable<IModelCreateConfiguration> ConfigurationsForOracle    {        get        {            yield return new OracleModelCreateConfiguration();            // Add more ‘yield return‘ for more CreateConfigurations        }    }    private IEnumerable<IModelCreateConfiguration> GetConfigurations()    {        return this.GetDatabaseType()            .ReturnWhen(                mssql: () => ConfigurationsForMssql,                oracle: () => ConfigurationsForOracle);    }}public interface IModelCreateConfiguration{    DbModelBuilder ConfigureModel(DbModelBuilder modelBuilder);}public class OracleFoobarModelCreateConfiguration : FoobarCreateModelConfiguration{    public override DbModelBuilder ConfigureModel(DbModelBuilder modelBuilder)    {        base.ConfigureModel(modelBuilder);        modelBuilder.HasDefaultSchemaForOracle("Foobar", true);        modelBuilder.Configurations.Add(new FooyConfigurationForOracle());        modelBuilder.Configurations.Add(new BarConfigurationForOracle());        modelBuilder.Configurations.Add(new BuzzConfigurationForOracle());      	// more configurations ...        return modelBuilder;    }}public class OracleMigrationConfiguration : FoobarDbMigrationsConfiguration{    public OracleMigrationConfiguration()        : base(new Arguments        {            MigrationDirectoryPath = @"Contexts\FoobarContext\Oracle\Migrations",            MigrationNamespace = @"Foobar.FoobarContext.Oracle.Migrations"        })    {    }}public abstract class MigrationConfigurationBase : DbMigrationsConfigurationBase<FoobarContext>{    protected MigrationConfiguration(Arguments arguments)        : base(arguments.Configure(args =>                         {                             args.ContextKey = CONTEXT_KEY;                         }))    {    }    public const string CONTEXT_KEY = "FoobarContext";}public abstract class DbMigrationsConfigurationBase<TContext> : DbMigrationsConfiguration<TContext> where TContext : DbContext, new(){    protected FoobarDbMigrationsConfiguration(Arguments arguments)    {        DatabaseHelper.ConfigureAutomaticDatabaseMigration(this); // true        DatabaseHelper.SetMigrationDirectory(this, arguments.MigrationDirectoryPath);        DatabaseHelper.SetContextKey(this, arguments.ContextKey);        DatabaseHelper.SetMigrationNamespace(this, arguments.MigrationNamespace);    }    /// <summary>    /// Arguments for DbMigrationsConfiguration    /// </summary>    public class Arguments    {        /// <summary>        /// Migration directory is the place where all migration classes files will be stored.        /// </summary>        public string MigrationDirectoryPath { get; set; }        /// <summary>        /// Context Key must remain the same so migration remain continous.        /// </summary>        public string ContextKey { get; set; }        /// <summary>        /// Generated migration classes namespaces.        /// </summary>        public string MigrationNamespace { get; set; }    }}public static class DatabaseHelper{    public static void ConfigureAutomaticDatabaseMigration<TContext>(DbMigrationsConfiguration<TContext> migration) where TContext : DbContext    {        migration.AutomaticMigrationsEnabled = Convert.ToBoolean(WebConfigurationManager.AppSettings[SettingConstants.AutomaticMigrationsEnabled]);        migration.AutomaticMigrationDataLossAllowed = Convert.ToBoolean(WebConfigurationManager.AppSettings[SettingConstants.AutomaticMigrationDataLossAllowed]);    }    public static void SetMigrationDirectory<TContext>(DbMigrationsConfiguration<TContext> migration,                                                       string migrationsPath)      where TContext : DbContext    {        if (string.IsNullOrEmpty(migrationsPath))        {            throw new ArgumentException($"{nameof(migrationsPath)} cannot be null or empty.");        }        if (migrationsPath.Contains("/"))            throw new ArgumentException($"Invalid {nameof(migrationsPath)}. Path should be valid Windows path. Use backslashes instead of slashes.");        migration.MigrationsDirectory = migrationsPath;    }    public static void SetContextKey<TContext>(DbMigrationsConfiguration<TContext> migration,                                               string contextKey)      where TContext : DbContext    {        if (contextKey != null)        {            migration.ContextKey = contextKey;        }    }    public static void SetMigrationNamespace<TContext>(DbMigrationsConfiguration<TContext> migration,                                                       string migrationNamespace)      where TContext : DbContext    {        if (string.IsNullOrEmpty(migrationNamespace) == false)        {            migration.MigrationsNamespace = migrationNamespace;        }    } }public enum DatabaseType{    Mssql, Oracle}public static class DatabaseTypeProviderExtensions{    public static void PerformActionOn(this DatabaseType type,                                       Action mssql,                                       Action oracle)    {        switch (type)        {            case DatabaseType.Mssql:                mssql();                break;            case DatabaseType.Oracle:                oracle();                break;            default:                throw new ArgumentOutOfRangeException();        }    }    public static TResult ReturnOn<TResult>(this DatabaseType type,                                            Func<TResult> mssql,                                            Func<TResult> oracle)    {        switch (type)        {            case DatabaseType.Mssql:                return mssql();            case DatabaseType.Oracle:                return oracle();            default:                throw new ArgumentOutOfRangeException();        }    }}public static class DbModelBuilderExtensions{        /// <summary>    /// Set default schema name for context. Schema name must be valid with Oracle schemas standard.    /// </summary>    /// <param name="builder">Context model builder.</param>    /// <param name="schemaName">Schema name to set.</param>    /// <param name="capitalize">Capilize provided schema name.</param>    /// <returns>Context model builder.</returns>    public static DbModelBuilder HasDefaultSchemaForOracle(this DbModelBuilder builder,                                                           string schemaName,                                                           bool capitalize = false)    {        if (builder == null) throw new ArgumentNullException(nameof(builder));        // Schema name validation        if (string.IsNullOrWhiteSpace(schemaName))            throw new ArgumentNullException(nameof(schemaName));        if (schemaName.Length > 30)            throw new ArgumentException("Schema name max length is 30.");        if (capitalize)        {            schemaName = schemaName.ToUpperInvariant();        }        if (schemaName.All(char.IsUpper) == false) // This will also check for whitespaces ;)            throw new ArgumentException("Schema name should contain no whitespaces and be uppercase.");        builder.HasDefaultSchema(schemaName);        return builder;    }}/// <summary>/// Enables fluent configuration./// </summary>public static class ConfigureExtensions{    /// <summary>    ///     /// </summary>    /// <typeparam name="T"></typeparam>    /// <param name="system"></param>    /// <param name="configure"></param>    /// <returns></returns>    public static T Configure<T>(this T system, Action<T> configure)    {        if (system == null)            throw new ArgumentNullException(nameof(system));        configure(system);        return system;    }}