Archivi tag: join

Entity Framework left outer join

Many times I talked about Entity Framework join by linq. Today I show how to do LEFT OUTER JOIN or LEFT JOIN. Notice the end of line “join sve”, you’ll notice “into sveList” Then I call DefaultIfEmpty on this var … Continua a leggere

Pubblicato in c#, Entity Framework, SQL | Contrassegnato , , , | Lascia un commento

Entity Framework Many to Many join

If you use Entity Framework 6 (EF) design first to create the domain classes if you have a relationship many to many without any extra field inside the join table, EF will avoid to create the join table model. On … Continua a leggere

Pubblicato in c#, Entity Framework, SQL | Contrassegnato , , , , | Lascia un commento

Join in Linq, Join in Entity Framework

There are two way to do a join in a query with linq. Using Join Using the relationship property I tried both ways and the SQL generated by Entity Framework (EF6) is the same, so choose what you prefer.

Pubblicato in c#, Entity Framework | Contrassegnato , , | Lascia un commento