Entity Framework join 3 tables query error

Question

Error:

Cannot convert method group 'ToList' to non-delegate type 'System.Collections.Generic.List'. Did you intend to invoke the method? D:\PROJECTS\CECB2013-03-26\CECB\cecb.Functions\ActivationCodeEmail.cs 102 20 cecb.Functions*

My code is

 List<Members> teamMembers = new List<Members>();

 var query = from c in cecbContext.Projects
             join b in cecbContext.TeamMembers on c.proj_team equals b.team_reference
             join d in cecbContext.Members on b.mem_reference equals d.mem_reference
             select new
                    {
                        d.mem_reference
                    };

    return query.ToList<Members>;
}

marc_s · Accepted Answer · 2015-12-05 21:55:08Z

1

You've forgotten the brackets after ToList - it's an ( extension ) method:

return query.ToList<Members>();

You have another problem, though - you trying to turn an IQueryable<AnonymousType> into a List<Members>.

If you create instances of Members in your Select clause, it will work and you will be able to omit the generic type parameter on ToList()

select new Members
{
  ...
};

return query.ToList(); // this will create a List<Members>

edited Dec 5, 2015 at 21:55

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 30, 2013 at 16:35

Nick Butler

24.5k4 gold badges51 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Gayashan Over a year ago

no buddy then it say's Error 6 'System.Linq.IQueryable<AnonymousType#1>' does not contain a definition for 'ToList' and the best extension method overload 'System.Linq.Enumerable.ToList<TSource>(System.Collections.Generic.IEnumerable<TSource>)' has some invalid arguments

Nick Butler Over a year ago

@Gayashan oh - you have to add using System.Linq; too as IQueryable<T>.ToList() is an extension method.

Gayashan Over a year ago

Error 5 Cannot implicitly convert type 'System.Collections.Generic.List<AnonymousType#1>' to 'System.Collections.Generic.List<cecbData.Members>' again im getting this error

Nick Butler Over a year ago

@Gayashan That's because you're selecting an anonymous type with select new { ... }. See the second part of my answer. You could start a new question as this is a different problem.

Collectives™ on Stack Overflow

Entity Framework join 3 tables query error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related