如何:将 LINQ to Entities 查询的结果转换为数组
使用 ToArray 方法可从 LINQ to Entities 查询的结果创建数组。调用 ToArray 还会强制立即执行查询。有关将 LINQ to Entities 查询的结果转换为 Dictionary 或 List 的示例,请参见基于方法的查询语法示例:转换 (LINQ to Entities)。
示例
下面的示例使用 ToArray 方法立即计算查询并将序列转换为数组。
Using AWEntities As New AdventureWorksEntities
Dim products As ObjectQuery(Of Product) = AWEntities.Product
Dim prodArray As Product() = ( _
From product In products _
Order By product.ListPrice Descending _
Select product).ToArray()
Console.WriteLine("The list price from highest to lowest:")
For Each prod As Product In prodArray
Console.WriteLine(prod.ListPrice)
Next
End Using
using (AdventureWorksEntities AWEntities = new AdventureWorksEntities())
{
ObjectQuery<Product> products = AWEntities.Product;
Product[] prodArray = (
from product in products
orderby product.ListPrice descending
select product).ToArray();
Console.WriteLine("Every price from highest to lowest:");
foreach (Product product in prodArray)
{
Console.WriteLine(product.ListPrice);
}
}
编译代码
本主题中的示例包含对在如何:在 Visual Studio 中创建 LINQ to Entities 项目的示例项目中定义的对象和命名空间的引用。若要编译和运行此示例,请将其粘贴到 Main 方法中。
另请参见
概念
基于方法的查询语法示例:转换 (LINQ to Entities)