I have a linq query.
var query = (from s in dc.ClassInfos
where s.ClassName == tbSubject.Text
select new{
location = s.ClassLocation,
Date = s.ClassDate
});
Now I like to assign the location value to a local variable. Can you help me how to do this?
you query returns an IEnumerable of an anonymous class - not just a single value. If you wanted to assign the first location value (provided there is one) you could do:
var location = query.First().location;
If you want all locations in a list on the other hand this should work:
var locations = query.Select( x=> x.location).ToList();
var location = query.First().location;
But I would write
var location = (from s in dc.ClassInfos
where s.ClassName == tbSubject.Text
select s.ClassLocation).FirstOrDefault();
because you don't need to select Date if you only use location.
var localVar = new List<string>();
foreach (var item in query)
{
localvars.add(item.location);
}
