将IQueryable转换为DataRowView

Question

我有一个bindingsource，它由LINQ to SQL的IQueryable结果绑定。

private void loadProducts(short _engineID)
{    
     dbLinqDataContext db = new dbLinqDataContext();                   
     var  productQuery = from pe in db.productEngines
                         where pe.EngineID == _engineID
                         select new
                         {
                           ProductID = pe.ProductID,
                           ProductNumber = pe.product.ProductNumber,
                           Description = pe.product.ProductName,
                           Cost = String.Format("{0:C}", pe.product.StandardCost),
                           Price = String.Format("{0:C}", pe.product.ListPrice),
                           QOH = String.Format("{0:0.00}",pe.product.QOH),
                           Picture = pe.product.Picture,
                           Category =pe.product.category.Category1,   

                           Engine=pe.engine.ModelSeriesYear,
                           Manufacturer=pe.engine.manufacturer.Manufacturer
                        };

productQueryBindingSource.DataSource = productQuery；}

然后我无法将我的bindingsource当前项转换为DataViewRow。

DataRow currentRow = ((DataRowView)productQueryBindingSource.Current).Row;

如何将匿名类型转换为DataViewRow类型？

Answer 1

若要将匿名转换为DataRow，应使用反射。有关更多信息，请查看以下链接

Converting Custom Collections To and From DataTable