Select all columns on an object with Linq
If you want to avoid anonymous types and get everything, why not just return an IEnumerable
of the original transaction item?
var transactions = from t in db.Transactions
where t.SellingPrice != 0
select t;
In addition, If there is a join condition between objects, we might get the result using..
var result = (from t in db.Transactions
join te in db.TransactionsEntries
on t.WorkorderID equals te.WorkorderID
select new { t, te }).ToList();
I believe this would work.
var transactions = from t in db.Transactions
where t.SellingPrice != 0
select t;
I think you want
var transactions = db.Transactions.Where(t => t.SellingPrice != 0).ToList();
or
var transactions = db.Transactions.Where(t => t.SellingPrice != 0).AsEnumerable();
if you truly just want an IEnumerable