Export (0) Print
Expand All

DbExpressionBuilder.SelectMany<TSelector> Method (DbExpression, Func<DbExpression, DbExpression>, Func<DbExpression, DbExpression, TSelector>)

.NET Framework 4.5

Creates a new DbApplyExpression that evaluates the given apply expression once for each element of a given input set, producing a collection of rows with corresponding input and apply columns. Rows for which apply evaluates to an empty set are not included. A DbProjectExpression is then created that selects the specified selector over each row, producing the overall collection of results.

Namespace:  System.Data.Common.CommandTrees.ExpressionBuilder
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

public static DbProjectExpression SelectMany<TSelector>(
	this DbExpression source,
	Func<DbExpression, DbExpression> apply,
	Func<DbExpression, DbExpression, TSelector> selector

Type Parameters


The method result type of selector.


Type: System.Data.Common.CommandTrees.DbExpression

A DbExpression that specifies the input set.

Type: System.Func<DbExpression, DbExpression>

A method that represents the logic to evaluate once for each member of the input set.

Type: System.Func<DbExpression, DbExpression, TSelector>

A method that specifies how an element of the result set should be derived given an element of the input and apply sets. This method must produce an instance of a type that is compatible with SelectMany and can be resolved into a DbExpression. Compatibility requirements for TSelector are described in remarks.

Return Value

Type: System.Data.Common.CommandTrees.DbProjectExpression
An new DbProjectExpression that selects the result of the given selector from a new DbApplyExpression with the specified input and apply bindings and an DbExpressionKind of CrossApply.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DbExpression. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).


source, apply or selector is null.


The expression produced by apply is null.


The result of selector is null on conversion to DbExpression.


source does not have a collection result type.


The expression produced by apply does not have a collection type. does not have a collection type.

To be compatible with SelectMany, TSelector must be derived from DbExpression, or must be an anonymous type with DbExpression-derived properties. The following are examples of supported types for TSelector:

source.SelectMany(x => x.Property("RelatedCollection"), (source, apply) => apply.Property("Name"))

(TSelector is DbPropertyExpression).

source.SelectMany(x => x.Property("RelatedCollection"), (source, apply) => new { SourceName = source.Property("Name"), RelatedName = apply.Property("Name") })

(TSelector is an anonymous type with DbExpression-derived properties).

.NET Framework

Supported in: 4.6, 4.5

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

© 2014 Microsoft