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