任何人都可以帮我找出错误 [英] Can anyone help me to find out the mistake

问题描述

当我创建如下列表时，我得到错误system.linq.Iqueyable< anonymoustype1＃>不包含'ToList'的定义和最佳扩展方法重载'system.linq.parellelIEnumerable.ToList<<< Tsource>有一些无效的争论。任何人都可以帮我找出错误吗？

列表< ren> renewedorderlist = 
（来自 ordernum   salesContext.SL_OrderIdMapper 
  where  ordernum.OrderNumber == placeOrderModel.OrderInfo.OrderID 
  from  orderDetail  in  salesContext.SL_OrderDetails 
  where  ordernum.OrderId == orderDetail.OrderId 
  from  renProducts   salesContext.products 
 其中 renProducts.pid == orderDetail.ProductID 
 来自 licenseDetails   salesContext.SL_LicenseDetails 
  where  licenseDetails.OrderDetailId == orderDetail.OrderDetailId 
 来自 licenses   salesContext.SL_License 
 其中 licenses.LicenseId == licenseDetails.LicenseId 
 来自 oldProducts   salesContext.products 
 其中 oldProducts.pid == licenses.ProductID 
 选择  new  
 {
 OrderId = ordernum.OrderNumber，
 OldProductName = oldProducts.productdesc，
 NewProductName = renProducts.productdesc，
 Quantity = orderDetail.Quantity，
 LicenseID = licenses.LicenseId 
 }。ToList< ren>（）; 

解决方案

您尝试将匿名类型的集合转换为列出，其元素类型为 ren 。更改选择新的{到选择新的ren（）{

列表与LT;任> renewedorderlist = 
（来自 ordernum   salesContext.SL_OrderIdMapper 
  where  ordernum.OrderNumber == placeOrderModel.OrderInfo.OrderID 
  from  orderDetail  in  salesContext.SL_OrderDetails 
  where  ordernum.OrderId == orderDetail.OrderId 
  from  renProducts   salesContext.products 
 其中 renProducts.pid == orderDetail.ProductID 
 来自 licenseDetails   salesContext.SL_LicenseDetails 
  where  licenseDetails.OrderDetailId == orderDetail.OrderDetailId 
 来自 licenses   salesContext.SL_License 
 其中 licenses.LicenseId == licenseDetails.LicenseId 
 来自 oldProducts   salesContext.products 
 其中 oldProducts.pid == licenses.ProductID 
  select   new  ren（） //  <  -  here  
 {
 OrderId = ordernum.OrderNumber，
 OldProductName = oldProducts.productdesc，
 NewProductName = renProducts.productdesc，
 Quantity = orderDetail.Quantity，
 LicenseID = licenses.LicenseId 
}）。ToList< ren>（）; 

When I cretae a list like below am getting error system.linq.Iqueyable<anonymoustype1#>doesnot contains a definition for 'ToList' and the best extension method overload 'system.linq.parellelIEnumerable.ToList<<Tsource> has some invalid arguements.Can anyone help me to findout the mistake?

List<ren> renewedorderlist = 
  (from ordernum in salesContext.SL_OrderIdMapper
     where ordernum.OrderNumber==placeOrderModel.OrderInfo.OrderID
   from orderDetail in salesContext.SL_OrderDetails
     where ordernum.OrderId == orderDetail.OrderId
   from renProducts in salesContext.products
     where renProducts.pid == orderDetail.ProductID
   from licenseDetails in salesContext.SL_LicenseDetails
     where licenseDetails.OrderDetailId == orderDetail.OrderDetailId
   from licenses in salesContext.SL_License
     where licenses.LicenseId == licenseDetails.LicenseId
   from oldProducts in salesContext.products
     where oldProducts.pid == licenses.ProductID
   select new
   {
     OrderId = ordernum.OrderNumber,
     OldProductName = oldProducts.productdesc,
     NewProductName = renProducts.productdesc,
     Quantity = orderDetail.Quantity,
     LicenseID = licenses.LicenseId
   }).ToList<ren>();

解决方案

You try to convert a collection of anonymous types to a List with elements of the type ren. Change select new { into select new ren() {

List<ren> renewedorderlist = 
  (from ordernum in salesContext.SL_OrderIdMapper
     where ordernum.OrderNumber==placeOrderModel.OrderInfo.OrderID
   from orderDetail in salesContext.SL_OrderDetails
     where ordernum.OrderId == orderDetail.OrderId
   from renProducts in salesContext.products
     where renProducts.pid == orderDetail.ProductID
   from licenseDetails in salesContext.SL_LicenseDetails
     where licenseDetails.OrderDetailId == orderDetail.OrderDetailId
   from licenses in salesContext.SL_License
     where licenses.LicenseId == licenseDetails.LicenseId
   from oldProducts in salesContext.products
     where oldProducts.pid == licenses.ProductID
   select new ren() // <-- here
   {
     OrderId = ordernum.OrderNumber,
     OldProductName = oldProducts.productdesc,
     NewProductName = renProducts.productdesc,
     Quantity = orderDetail.Quantity,
     LicenseID = licenses.LicenseId
   }).ToList<ren>();

这篇关于任何人都可以帮我找出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！