Self join in Entity Framework

Linq to Entities / Entity Framework cross edmx "join"

I have two entities, each from a different database and therefore different edmx files. There is, however, an infered relationship between them....Foo... has many ...Bar...s for example....What's the easiest way to do this join in the EntityFramework, with fewest database calls?...Thanks.

Self-referencing many-to-many recursive relationship code first Entity Framework

I can't seem to make this work at all...class Member { public virtual IList<Member> Friends { get; set; } [Key] public int MemberId { get; set; } public string Name{ get; set; } } ...I tried adding Mappings but in vain. Is there a way to do so with CTP5?

Left Outer Join via Linq To Entities via Entity Framework with Where clause

.NET 3.5...private class FooBar { public Foo Foo { get; set; } public Bar? Bar { get; set; } } var innerQuery = from foo in context.Foos from bar in context.Bars where foo.Name == 'fooname' || bar.Description == 'bardesc' where foo.FooId == bar.FooId select new FooBar { Foo ...

Entity Framework Self-Tracking Entities not recommended by Microsoft

While looking at Microsoft's web site, I discovered that they no longer recommend using Self-Tracking Entities....Each link below is a MS resource that mentions not to use STEs:...Shows what templates are available by the Entity Framework team: ...EF Designer Code Generation Templates...Self-Tracking Entities...Recommended technologies for N-Tier a...

LEFT JOIN or RIGHT JOIN using LINQ Entity-Framework

Updated for the error: ...You will need to create a new class with the required properties and return it.... var applicantList = (from app in context.APPLICANTs join a in context.Profiles on app.Profile_id equals a.PROFILE_ID into output from j in output.DefaultIfEmpty() ...

Replacement of Self-tracking entities in Entity Framework 6

There is an open source project called ...Trackable Entities... that provides support for STEs in EF6.0...Here is a ...blog post... comparing Trackable Entities to STEs.

Delete row in table with self-referencing many-to-many relationship in Entity Framework Code First

OK, I finally managed to figure this out....The solution is modifying the Delete() stub in PersonController, like this : ...using (var context = new DataContext()) { Person person= context.Persons.Find(id); foreach (var child in person.Children.ToList()) { person.Child...

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....

primary key constraint updating many-to-many self referential table in entity framework code-first

TL;DR... What is the proper way of rehydrating an entity framework object with a self referential many to many relationship from a DTO and updating it with the new values so that the database updates correctly?...I have the following entity (irrelevant stuff trimmed)... public class Role { [Key] [Required] public String ...

Entity Framework forcing Inner Join when Left Join DefaultIfEmpty() Syntax used

My mistake. I was wrapping this query in a function called GetEmployees() which returned an iQueryable list, and was filtering it:...results = HRFunctions.GetEmployees().Where(x => x.ad != null); ...Because there was a WHERE clause added that assumed AD should not be null, EntityFramework intelligently altered the LEFT JOIN to an INNER JOIN....Afte...