ASP.NET : select multiple values in query using Linq

Question

I need to return an IEnumerable. Here is the working code:

public IEnumerable<String> ReturnStudentsAsString(int vak, int klasgroep)
    {
        return (from s in Students
                orderby s.Naam, s.Voornaam
                select s.Naam);
    }

That works perfect! Now, I want to return the street and the postal code as well... So I created an anonymous type:

public IEnumerable<String> ReturnStudentsAsString(int vak, int klasgroep)
    {
        var test = (from s in Studenten
                orderby s.Naam, s.Voornaam
                select new 
                {
                    StudentNumber = s.StudentNumber,
                    Name = s.Name,
                    Street = s.Street,
                    PostalCode = s.PostalCode,
                    City = s.City
                });
        return test;

But it gives me an error... How could I fix it?

Thanks in advance!

Answer 1

Your method is returning an IEnumerable<string>. You've changed your return value to a new anonymous type, rather than a collection of strings.

To fix, you could:

• create a class, and instantiate & return IEnumerable<MyClass> (preferred!)
• return IEnumerable<dynamic> if you're using .NET 4. and you don't care for static typing up the call stack.