IBM.EntityFrameworkCore - DbContext.OnConfiguring and DbContext.OnModelCreating aren't called

db2 entity-framework-core

Question

As soon as I've solved one issue with IBM.EntityFrameworkCore, another one has arose. Everything is soooo hard and painful with DB2 and their .NET team...

The problem: I have several EntityFrameworkCore - based projects in the same VS solution, for example MyDb2EfModel, MyMsSqlEfModel, and MyNpgsqlEfModel. (It's kind of a complex data-integration scenario.) On top of that I have a CLI project which references all the three and performs actual data ops. When the CLI project references only MyDb2EfModel project - IBM.EntityFrameworkCore works as expected. But as soon as I add references to the remaining two projects - it simply stops working and throws some misleading exception. The exception happens because overridden DbContext.OnConfiguring and DbContext.OnModelCreating methods aren't called anymore. When there's only one reference (MyDb2EfModel) the methods get called as expected, and everything works. But with all three library projects referenced - they aren't called anymore.

Let's also note that the mentioned methods get called on DbContext instances from MyMsSqlEfModel and MyNpgsqlEfModel libraries. The only one that stops working is MyDb2EfModel (which is based on IBM.EntityFrameworkCore).

Thumbs down for IBM and their .NET team! It's ridiculous how these guys are making things be 100 times more complicated then with any other DB.

The question is obvious: Does anyone has any experience in a similar scenario, and hopefully any suggestion how to resolve the issue?

Thanks!

1
3
8/22/2017 8:49:09 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I've found the reason. It turned out that it's about Microsoft.EntityFrameworkCore version. Currently available version of IBM.EntityFrameworkCore is 1.1.1.101 (.NET Standard 1.6), and it uses Microsoft.EntityFrameworkCore version 1.1.1 or 1.1.2. It cannot be used with Microsoft.EntityFrameworkCore version 2.0.0 (.NET Standard 2.0) - it throws the exception I was getting.

In the other two libraries I've used Npgsql.EntityFrameworkCore.PostgreSQL version 2.0.0 and Microsoft.EntityFrameworkCore.SqlServer version 2.0.0, both depending on Microsoft.EntityFrameworkCore version 2.0.0 (all in .NET Standard 2.0).

So when I referenced only MyDb2EfModel in my CLI project everything was working because only Microsoft.EntityFrameworkCore version 1.1.2 is referenced and used. But as soon as I add reference to another projects CLI ends up with dependencies on both Microsoft.EntityFrameworkCore version 1.1.2 and 2.0.0 versions, and the newer (2.0.0) is loaded and used. And IBM.EntityFrameworkCore was failing because it cannot use it.

How to solve? Either wait for IBM.EntityFrameworkCore for .NET Standard 2.0, or downgrade other references to ensure that Microsoft.EntityFrameworkCore version 2.0.0 isn't used anywhere (which will cause other headaches).

So although it's not about a bug in IBM.EntityFrameworkCore, IBM DB2 .NET team is still to blame for not having .NET Standard 2.0 at least preview published, although .NET Standard 2.0 is available for almost a year now, recently reaching its "release" version. And there are more things to blame IBM DB2 .NET team for (unrelated to this particular issue).

3
8/25/2017 1:54:25 AM

Related Questions

Dependancy Injected DbContext is empty after populating DbContext created with new (EF7, ASP.NET 5, vnext)

I might be wrong, but my assumption is that when you create a new instance of ...DbContext... in code, you are using the parameterless constructor that sets underlying connection string to some default value. However, DI-injected ...DbContext... could be resolved using another constructor with different connection string passed in explicitly....Tha...
asp.net asp.net-core dbcontext entity-framework entity-framework-core
asked by Sergey Kolodiy

DbContext.OnConfiguring not getting called and behaving weird in Asp.net core

Just in case anyone else had this issue, I had to use an empty constructor to get OnConfiguring called:...public ReadingContext() : base() { } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var builder = new ConfigurationBuilder().AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); con...
asp.net-core asp.net-mvc entity-framework-core
asked by dml

What if I call DbContext.Dispose without calling DbContext.SaveChanges?

what happens if I simply dispose of my dbContext instance without calling dbContext.SaveChanges() or manipulating the entity states...Nothing. The instances that were previously attached to the now disposed ...DbContext... instance continue to exist as any normal instances would assuming there is a handle on those instances somewhere by something. ...
.net dbcontext entity-framework entity-framework-6 rollback
asked by Igor

.NET Standard 2.0 / EntityFrameworkCore / DB2 / IBM.EntityFrameworkCore issue

I've solved it. It turned out that this exception happens if actual entity types (i.e. ...MyType...) aren't defined in the same assembly (project) as the context. In my solution I had entity types defined in one project, and ...DbContext...defined in a different project, that references the first one, of course....The reason for me to have such des...
.net-core .net-standard-2.0 db2 entity-framework-core
asked by Aleksandar Pesic

What are expected results when optionsBuilder is defined in both DbContext.OnConfiguring and AspCore Startup.ConfigureServices?

It is explained in the ...Configuring a DbContext... section of the documentation:...The ...DbContextOptions... can be supplied to the ...DbContext... by overriding the ...OnConfiguring... method or externally via a constructor argument....If both are used, ...OnConfiguring... is applied last and can overwrite options supplied to the constructor ar...
asp.net-core c# entity-framework-core
asked by Ivan Stoev

How to extend DbContext with partial class and partial OnModelCreating method in EntityFramework Core

EFCore 3 - They ...FINALLY... fixed this!...You can now implement ...OnModelCreatingPartial... in a partial class like this: ...public partial class RRStoreContext : DbContext { partial void OnModelCreatingPartial(ModelBuilder builder) { builder.Entity<RepeatOrderSummaryView>().HasNoKey(); } } ...If you look at the generated con...
c# entity-framework entity-framework-core partial partial-classes
asked by Simon_Weaver

Why is services.AddDbContext<dbContext>() makes dbContext as a Scoped service?Shoudln't be a Singleton service?

DbContext should not be used as a singleton because it is holding a connection object which cannot be used by multiple threads at the same time. You will run into errors if two requests try to use it at the same time. If your service depends on the context, the service cannot be a singleton....Scoped makes sense since it allows for you to pass arou...
asp.net-core c# entity-framework entity-framework-core
asked by juunas

How to use AddDbContextPool if all configuration in OnConfiguring method of DbContext

Besides the debatable benefits of using it (from the docs: ..."has the advantage of saving some of the cost of initialization of DbContext instance"...), the ...DbContext pooling... is simply not applicable in your scenario, because your context contains ...state... which EF Core is unaware of:...private readonly DatabaseSettings _databaseOptions; ...
c# ef-core-2.2 entity-framework entity-framework-core
asked by Ivan Stoev

Using multiple DbContext getting error Cannot use multiple DbContext instances within a single query execution

I met with same the problem and i solved using async-await structure. I have 2 queries and it gives me the error. ...var result = await _context.YourTable.ToListAsync(); ...Maybe this can help you.
asp.net-core-mvc c# entity-framework-core
asked by malik

How do I set the OnConfiguring method in my DbContext without any hardcoded connection string?

Based on the ...comment..., I think you want to separate the EF Core related classes to a different assembly....In the ...UseMySql... there is an option to configure ...MigrationsAssembly.... You can get more details ...here...Here is pseudo-code for SQL Server....services.AddDbContext<EFCoreDemoContext>(options => { options.UseSqlServer(Config...
asp.net-core c# entity-framework-core
asked by Anuraj

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow