IQueryable and IEnumerable both work. But you want to use a type specific version, IQueryable<
T>
or IEnumerable <
T>
.
So you’ll want to create a type to keep the data.
var myData = from a in db.MyTable
where a.MyValue == "A"
select new MyType
{
Key = a.Key,
Value = a.MyValue
};