本文整理匯總了VB.NET中System.Data.Objects.ObjectQuery<T>.UnionAll方法的典型用法代碼示例。如果您正苦於以下問題:VB.NET ObjectQuery<T>.UnionAll方法的具體用法?VB.NET ObjectQuery<T>.UnionAll怎麽用?VB.NET ObjectQuery<T>.UnionAll使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類System.Data.Objects.ObjectQuery<T>
的用法示例。
在下文中一共展示了ObjectQuery<T>.UnionAll方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的VB.NET代碼示例。
示例1: AdventureWorksEntities
Dim productID = 100
Using context As New AdventureWorksEntities()
Dim queryString As String = "SELECT VALUE product FROM AdventureWorksEntities.Products " & _
" AS product WHERE product.ProductID < @productID"
Dim productQuery As New ObjectQuery(Of Product)(queryString, context, MergeOption.NoTracking)
Dim productQuery2 As New ObjectQuery(Of Product)(queryString, context, MergeOption.NoTracking)
Dim productQuery3 As ObjectQuery(Of Product) = productQuery.UnionAll(productQuery2)
productQuery3.Parameters.Add(New ObjectParameter("productID", productID))
Console.WriteLine("Result of UnionAll")
Console.WriteLine("------------------")
' Iterate through the collection of Product items,
' after the UnionAll method was called on two queries.
For Each result As Product In productQuery3
Console.WriteLine("Product Name: {0}", result.ProductID)
Next
Dim productQuery4 As ObjectQuery(Of Product) = productQuery3.Distinct()
Console.WriteLine(vbLf & "Result of Distinct")
Console.WriteLine("------------------")
' Iterate through the collection of Product items.
' after the Distinct method was called on a query.
For Each result As Product In productQuery4
Console.WriteLine("Product Name: {0}", result.ProductID)
Next
End Using