Telerik OpenAccess ORM

Telerik OpenAccess ORM Send comments on this topic.
How to: Convert the Results of a LINQ Query to an Array
See Also
Programmer's Guide > Feature Reference > API > LINQ Guide > How to: Convert the Results of a LINQ Query to an Array

Glossary Item Box

Use the ToArray method to create an array from results of a LINQ query. Calling ToArray also forces immediate execution of the query. The following example uses the ToArray method to immediately evaluate the query and convert the sequence into an array.

To run the code in this example, you need to create a new Telerik OpenAccess Domain Model based on the Northwind database.

The following code is the LINQ example.

C# Copy Code
using ( EntitiesModel dbContext = new EntitiesModel() )
{
   IQueryable<Product> products = from p
in dbContext.Products
                                  orderby p.ProductName descending
                                  select p;
   Product[] productsArray = products.ToArray();
   
foreach ( Product product in productsArray )
   {
       Console.WriteLine( product.ProductName );
   }
}
VB.NET Copy Code
Using dbContext As New EntitiesModel()
 Dim products As IQueryable(Of Product) = From p In dbContext.Products
                                          Order By p.ProductName Descending
                                          Select p
 Dim productsArray() As Product = products.ToArray()
 For Each _product As Product In productsArray
  Console.WriteLine(_product.ProductName)
 Next _product
End Using

See Also