Entity Framework 6 - Knowledge Base (KB)

LINQ/C# Simulation of Cross Context Joins

Here's the issue:...I have 2 data contexts that I would like to do a join on. Now I know that LINQ doesn't allow joins from one context to another, and I know that 2 possible solutions would be to either create a single datacontext or to have 2 seperate q...

What are the distinctions between.CreateObjectSetT>,.SetT>, and.CreateQueryT>?

I am writing a generic repository for entity framework and am confused as to what the difference between these calls are:...ObjectContext.CreateObjectSet<T> ObjectContext.CreateQuery<T> DbContext.Set<T> ...I want a generic repository that both supports co...

EntityFramework: Retrieve data with a condition on two different context

I'm importing data between two different database(which have not the same context)....So I've two different context. The goal is to import some data of the context A to the context B....Data in the context B are never directly edited, they are only import...

How to asynchronously call a database with subrecords using LINQ?

I'm using EF6 and want to make the following query fully asynchronous:... await MyDataContext.ADbSet. First(a => a.Something == "Something"). ASubCollection. Select(x => new { x.SubCollectionI...

How to detach entity from context when you no longer have a context reference

I am pre-loading product data on my website as I need this to be accessible fast and would rather this be loaded once on application start up rather than just when it's request. This is one way to make sure things load fast. I do this by eager loading my ...

Default physical location of Data base created in Entity Framework codefirst approach

I am learning Entity Framework. I created a demo app using Entity framework code first approach (without specifying any connection string)....static void Main(string[] args) { CreateBlog(); } private static void CreateBlog() { ...