Join on tables from different DbContext - model first

Solutions with one EF6 model (db first) and one code first

Ok, got to the bottom of this. Basically if you share a connection across both contexts this does not work. However if you use a different connection for both it works....Thanks to Ben Robinson for pointing me in right direction.

Entity Framework left join on multiple tables creates inner join instead

The ...INNER JOINS... represent required n:1 associations. If you had navigation properties, the join would be a reference to another, required, entity, not a collection. EF knows from the data model that an ...OUTER JOIN... would have no effect here, so it generates an ...INNER JOIN....

Entity Framework 6 - Missing table with only primary keys referencing different tables

As mentioned by @Hadi Hassan, EF will not “Expose” or recognize Relational Tables that are composed exclusively of other Entities....Work Around:...If you only need to ‘READ’ the data you can...Define a ...view... in your Schema for ...TableB.......Then do a ...Model (.EDMX)... Update from DB (select the Update Views)...You will now be ab...

Joining multiple tables from different databases

No, you can't do that with EntityFramework (neither 6.x nor Core). A DbContext is per database and you can only do joins within the same DbContext. ...You could create a view and map the view to the models you needs, but iirc. mapping of views is still on the roadmap for EntityFramework Core. May work with EntityFramework 6.x though....Edit:...At l...

Scaffold-DbContext creating model for table without a primary key

Support for complex types (those that don't have an entity key) in EF Core is on the backlog: ...https://github.com/aspnet/EntityFramework/issues/246.... That's why any attempt to reverse engineer a table without a primary key defined won't work at the moment.

How to map Table Valued Functions in EF6 Code First with different column names?

You do not want to modify your object and you cannot modify the database, but you can still modify your query. Try naming the columns in the result of the table valued function:...return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<User>( "SELECT Id, Name AS UserName FROM [GetUser](@ID)", idParameter );

One to One Relationship with Different Primary Key in EF 6.1 Code First

one-to-one... relationship with explicit FK property (like your ...PayGroup.SupervisorId...) is not supported....So remove that property from the model:...public class PayGroup { public int Id { get; set; } public virtual Employee Supervisor { get; set; } } ...and use the following fluent mapping:...modelBuilder.Entity<PayGroup>() .HasR...

Entity Framework Core 2 one to one relationship "on one table"

You can achieve this by using a nullable ...ForeignKey... attribute in your model class. ...public class Link { public long Id { get; set; } public long? OtherLinkId { get; set; } = null; [ForeignKey("OtherLinkId")] public Link OtherLink { get; set; } }

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

Although they look the same they are very different in some fundamental ways...In short, ...Find... starts by searching in the local cache of the context. If no match are found then it sends a query to the db....Documentation is your friend...DbSet.Find Method...Finds an entity with the given primary key values. If an entity with the given primar...

How do process form data and extract properties for two different models/tables using Entity Framework

To store two different databases in ef-core, you need to create two different dbcontexts. ...First, in the appsettings.json file：..."ConnectionStrings": { "DefaultConnection": "Connection string of the database where the quest table is located", "NewConnection": "Connection string of the database where the Heroes table is located" } ...