@H_404_1@
dynamic traceFile = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\EntityFrameworkTrace.log"; var CurrentStock = (from s in DBViews.StockStatus where s.ProductID != 10 orderby s.ProductName select new { s.ProductID,s.ProductName,CurrentStock = s.TotalStocked - s.TotalSold,s.CurrentSellingRate,CashValue = (s.TotalStocked - s.TotalSold) * s.CurrentSellingRate,s.LastStocked,s.LastCostPrice,s.LastQtyStocked }).ToList(); File.AppendAllText(traceFile,CurrentStock.toTraceString()); return CurrentStock.ToList();
如何从CurrentStock上获取toTraceString()在以下行?它没有得到解决
File.AppendAllText(traceFile,CurrentStock.toTraceString());
解决方法
你不能因为你已经调用了ToList – 它不是Linq-to-Entities查询而只是一个List实例.
试试这个:
var CurrentStock = (from s in DBViews.StockStatus where s.ProductID != 10 orderby s.ProductName select new { s.ProductID,s.LastQtyStocked }); // No ToList here! File.AppendAllText(traceFile,((ObjectQuery)CurrentStock).ToTraceString()); return CurrentStock.ToList();
顺便说一句.为什么你使用动态而不是字符串?动态类型仅适用于有意义的特殊情况 – 事实并非如此.