Linq to sql select new string

Question

So i got this code:

ClassA { List<ClassB> classBList;}
ClassB { List<ClassC> classCList;}
ClassC { String ID;}

Dictionary<string,int> dict;
ClassA MyObject;

The keys on the dictionary should match the the ID field on ClassC And i wanna do the following query on linq

List<String> matches = (from b in MyObject
                      from c in b.classCList
                      join d in dict
                      on c.ID equals dict.Key
                      select new
                      {
                          c.Value == 0 ? "YES" : "NO"
                      }).ToList();

But I'm getting the error: "Invalid anonymous type member ..."

The bottomline is ... how can i have a condition within the select new?

EDIT

How can i do this query with extended methods?

Any help? Ty

You haven't given the member a name.

CodeCaster
– CodeCaster

2013-10-04 17:17:19 +00:00
Commented Oct 4, 2013 at 17:17 — CodeCaster
– CodeCaster, Commented Oct 4, 2013 at 17:17

Habib · Accepted Answer · 2013-10-04 17:19:04Z

11

You are trying to select an anonymous type and then you are trying to assign the result back to List<string>. Your query should be:

List<String> matches = (from b in MyObject.classBList
                        from c in b.classCList
                        join d in dict
                        on c.ID equals d.Key
                        select d.Value == 0 ? "YES" : "NO").ToList();

answered Oct 4, 2013 at 17:19

Habib

224k30 gold badges420 silver badges446 bronze badges

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

4 Comments

Hélder Gonçalves Over a year ago

Ok... I'm feeling really dumb xD Ty :D

Habib Over a year ago

@HélderGonçalves, no worries, happens to all of us :)

alc Over a year ago

@HélderGonçalves: In addition, CodeCaster's comment holds as well, there is no valid type for matches as you didn't provide a name for the member of the anonymous class you were creating.

Hélder Gonçalves Over a year ago

Can you show me how to do that with extended methods from linq? like .Join() :D Ty

Collectives™ on Stack Overflow

Linq to sql select new string

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