DefaultIfEmpty() Causing “System.NotSupportedException: LINQ to Entities does not recognize the method 'System.Collections.Generic.IEnumerable'”?

The SQL Provider for Entity Framework in version 3.5 of the . NET framework does not support DefaultIfEmpty(). Sorry, but could not find a better reference than this article: smehrozalam.wordpress.com/2009/06/10/c-l... You might want to try straight LINQ-to-SQL rather than ADO.NET Entity Framework.

I believe that it works in LINQ-to-SQL. I've verified in the past that left joins work in 3.5 via LinqPad.

The SQL Provider for Entity Framework in version 3.5 of the . NET framework does not support DefaultIfEmpty(). Sorry, but could not find a better reference than this article: smehrozalam.wordpress.com/2009/06/10/c-l... You might want to try straight LINQ-to-SQL rather than ADO.NET Entity Framework.

I believe that it works in LINQ-to-SQL. I've verified in the past that left joins work in 3.5 via LinqPad.

From your suggestion I was able to make this work using LINQ to SQL instead, thanks. – John Chapman Sep 21 at 15:55.

DefaultIfEmpty is supported only in EFv4+. First version of EF doesn't support DefaultInEmpty.

It looks like you need to create a default value to pass into DefaultIfEmpty(), since DefaultIsEmpty() takes a parameter. DefaultIfEmpty() on MSDN.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.