Entity Framework - Use 2 DBContext for the same Database

c# entity-framework entity-framework-6

Question

I have a solution where I want to add another project with it's own DBcontext, using its own tables, in the same database as the rest of the solution (the 2 DBcontexts are not sharing any tables). But when running the project I am getting the error below:

Additional information: The default DbConfiguration instance was used by the Entity Framework before the 'Configuration' type was discovered. An instance of 'Configuration' must be set at application start before using any Entity Framework features or must be registered in the application's config file.

I already have a big database built in the existing solution, so I don't want to change anything there, if I can avoid that. I have tried to change the ContextKey in the configuration and also tried to use another DB schema for the new project, but I'm still getting the error.

1
2
12/11/2015 10:47:26 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The link provided in the first comment to the question by steve-green solves the issue.

From https://msdn.microsoft.com/en-us/data/jj680699#Moving:

... use the config file to specify the DbConfiguration instance to use. To do this, set the codeConfigurationType attribute of the entityFramework section. For example:
<entityFramework codeConfigurationType="MyNamespace.MyDbConfiguration, MyAssembly"> ...Your EF config... </entityFramework>

1
5/23/2017 12:10:32 PM

Related Questions

Create a database relationship between 2 entities in different Entity Framework DbContexts

I have two Objects (UserProfile and Login) that resides in different assemblies and I have to create a relationship between them in SQL Server (I don't care about the DbContext relationship, but I'd like to assure the database referential integrity between the their respective tables)....The easiest way is to update the database (I am using code fi...
c# entity-framework entity-framework-6
asked by Douglas Gandini

Share connection between DbContext objects in Entity Framework 6 Database first approach

I am trying to share a connection in between 2 different DB context objects using EF 6 . I have got the code mentioned here ...https://msdn.microsoft.com/en-us/data/dn456843.aspx... to work for a single DB Context but as soon as I try to share the connection with another DB Context object I am running into trouble. Below is what I have done so f...
c# entity-framework entity-framework-6
asked by Pratik

How can I use database Views in a scaffolded DbContext with Entity Framework Core 1.0 (EF7)

Unfortunately ...Entity Framework Core 1.0... (formerly Entity Framework 7) does not yet support Views, and I'm trying to 'fake' it using a table....However the scaffolding ...dotnet dbcontext ef scaffold... command doesn't currently recognize or generate views, and I want a single DbContext which allows querying a view and updating of tables. Is t...
entity-framework-core view
asked by Simon_Weaver

How to get Column name and corresponding Database Type from DbContext in Entity Framework Core

For those who arrived here, but are not using .NET CORE, like me. try this:...public partial class MyDbContext : System.Data.Entity.DbContext { public string GetTableName(Type entityType) { var sql = Set(entityType).ToString(); var regex = new Regex(@"FROM \[dbo\]\.\[(?<table>.*)\] AS"); var match = regex.Match(sql);...
.net-core c# entity-framework entity-framework-core
asked by antonio

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In Entity framework Core, I have solved the problem easily using EF-Core ...Transaction...try { _unitOfWork.Repository<Product>().InsertEntity(product); await _unitOfWork.SaveChangesAsync();//This throws exception due the model validation failure } catch (Exception exception) { ExceptionModel exceptionModel = new ExceptionModel(); ...
asp.net-core c# entity-framework entity-framework-core
asked by TanvirArjel

Using a single Entity Framework Core DbContext to manage multiple database schemas with homonymous tables

In a ....NET Core 2.1 library... I need to access to a ...MySQL... database organized in multiple schemas with ...tables that can have the same name across those schemas.... I can't make any changes to the DB since it comes from another company. For most of the tables I need a read-only access and I'd like to use a ...single EF Core...DbContext....
.net-core c# database-schema dbcontext entity-framework-core
asked by Cheshire Cat

How to get Column name and corresponding Database Type from DbContext in Entity Framework Core

For those who arrived here, but are not using .NET CORE, like me. try this:...public partial class MyDbContext : System.Data.Entity.DbContext { public string GetTableName(Type entityType) { var sql = Set(entityType).ToString(); var regex = new Regex(@"FROM \[dbo\]\.\[(?<table>.*)\] AS"); var match = regex.Match(sql);...
.net-core c# entity-framework entity-framework-core
asked by antonio

Add child entities to database and assign them to parent object in database Entity Framework Core

I have a datamodel named "Document" which looks like this:...public class Document { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //[ForeignKey("Id")] public List<DocumentLine> Lines { get; set; } public DateTime PurchaseDate { get; set; } public double TotalValue { get; set; } } ...It...
c# entity-framework-core xamarin.forms
asked by N.iw

Different between DbContext.Find() and DbContext.SingleOrDefault() Entity Framework Core

What is the different when query data from context using ...Find()... and ...Single().... Both return the entity being requested....Some example I found on Microsoft are using ...Single..., ...SingleOrDefault... variation to query for entity. Some uses ...Find... method....Are there any "performance" advantanges when using one over the other?
c# entity-framework entity-framework-core
asked by Natthapol Vanasrivilai

Database first with Entity Framework Core ,oracle 11g (v11.2 ) and Scaffold-DbContext

I am trying to create Entity classes from already created oracle database by using Scaffold-DbContext. I used the following command to generate the same but I am getting just DbContext with no entity classes....Scaffold-DbContext "Data Source=data-source;User ID=user-id;Password=****" Oracle.EntityFrameworkCore -OutputDir Models ...I am unable to f...
asp.net-core c# entity-framework-core oracle
asked by Vignesh Pandi

How to implement Entity Framework Core 3.1.2 with Firebird database using 'database first approach'

I am currently developing a .NET Core 3.1 Web API which should communicate with a Firebird database (storing/retrieving data). I would like to handle that communication using ...Microsoft.EntityFrameworkCore... 3.1.2. Entity Framework is completely new for me so excuse me if this question is too simple. But I couldn't find the answer online....Beca...
.net .net-core c# entity-framework-core firebird
asked by DayDreaming

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