CODEWITHSUNDEEP
c#linq
user76071
user76071

Reputation:

Need help turning this LINQ expression into LINQ statement

I need help in turning this linq expression into a linq statment. SampleData.Publishers and SampleData.Books are simple collections that I have from the Linq in Action book.

Here is the expression

var pubBooks =
            from pub in SampleData.Publishers
            join book in SampleData.Books on pub.Name equals book.Publisher.Name into pubbks
            select new {
                Publisher = pub.Name,
                Books =
                    from b in pubbks
                    select b.Title
            };

Here is what I have so far, but I can't seem to get the books collection defined in the anonymous type. Thanks for your time.

var pubBooks = SampleData.Publishers.Join(SampleData.Books, pub => pub.Name, book => book.Publisher.Name, (pub, book) => new {
            Publisher=pub.Name,
            Books=??????
        });

Upvotes: 2

Views: 133

Answers (4)

rohancragg
rohancragg

Reputation: 5156

Resharper gave me this:

var pubBooks =
            SampleData.Publishers.GroupJoin(
                SampleData.Books,
                pub => pub.Name,
                book => book.Publisher.Name,
                (pub, pubbks) => new
                                     {
                                         Publisher = pub.Name,
                                         Books =
                                     from b in pubbks
                                     select b.Title
                                     });

Upvotes: 0

bruno conde
bruno conde

Reputation: 48255

You can use GroupJoin.

I didn't test this but it could look like this:

var pubBooks = SampleData.Publishers.GroupJoin(SampleData.Books, pub => pub.Name, book => book.Publisher.Name, (pub, bookColl) => new {
            Publisher = pub.Name,
            Books = bookColl.Select(b => b.Title)
        });

Upvotes: 2

Carles Company
Carles Company

Reputation: 7216

Another good way to transform this is to use LinqPad.

Upvotes: 3

empi
empi

Reputation: 15901

Really easy way to do that is to use Reflector. When you analyze your code you will see statement, not an expression.

Upvotes: 3

Related Questions