Linq. Select

[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

 

[shapper]

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

See "where".

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