Linq. Select

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

Hello,

I have the following method to get all tags in a table:

// GetTags
public IQueryable<Tag> GetTags(IList<String> names) {
IQueryable<Tag> tags = (from t in
context.aspnet_Tags
orderby t.Name descending
select new Tag {
Id = t.TagId,
Name = t.Name
}).AsQueryable();
return tags;
} // GetTags

How can I get only the tags which name is contained in names input?
I would like to not care about the case ...

Thanks,
Miguel
 
[...]
How can I get only the tags which name is contained in names input?
I would like to not care about the case ...
Click to expand...

See "where".
Click to expand...

I was thinking the wrong way ... I was thinking on some kind of join.

But I think the follows solves it well:

IQueryable<Tag> tags = (from t in context.aspnet_Tags
where names.Contains(t.Name)
orderby t.Name descending
select new Tag {
Id = t.TagId,
Name = t.Name
}).AsQueryable();
return tags;

Thanks,
Miguel
 
Back
Top