Entity Framework 6 - Knowledge Base (KB)

LINQPad [extension] methods

Does anyone have a complete list of LINQPad extension methods and methods, such as....Dump() SubmitChanges()

How does LINQ expression syntax work with Include() for eager loading

I have a query below, but I want to perform an Include() to eager load properties. Actions has a navigation property, User (Action.User)...1) My basic query:...from a in Actions join u in Users on a.UserId equals u.UserId select a ...2) First attempt:...

LinqPad Linq Include() extension method is not found even after adding references

I am able to do...var result = OAS_Questions.Count (oasq => oasq.Id!=0); result.Dump(); ...and even...var result = OAS_Questions; result.Dump(); ...But when I try to include child objects of "Questions" say "Opitons" through...var result = OAS_Question...

Entity framework Include command - Left or inner join?

As I was investigating the difference between ...Include... and ...Join... I found that : ...If the DB ...does not... include a Foreign Keys -it has no navigation props so it's better to use ...Join...If It ...does... have a navigation props - then use ....

Does LINQpad output generated SQL with Entity Framework 6 RTM?

When using a LINQpad data connection with an Entity Framework 6 DbContext derived object, I'm not getting anything in the SQL pane. I have no problems running queries or performing updates, just not seeing the generated SQL. According to the release notes...

Error multiple properties with the same name in LINQ query

I am working on Linq query and I am getting error on functionNavigation_b.Title column. I am using LinqPad to test my queries initially,...Error...An anonymous type cannot have multiple properties with the same name ...LINQ Query...from functionNavigation...