Leer en inglés

Compartir a través de


SqlExpressionFactory.Function Method

Definition

Overloads

Function(String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(SqlExpression, String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(String, String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(SqlExpression, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(String, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

Function(String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.

Function(String, String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.

Function(SqlExpression, String, IEnumerable<SqlExpression>, Boolean, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.

Function(String, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use NiladicFunction method.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

name
String

The name of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(SqlExpression, String, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use NiladicFunction method.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

instance
SqlExpression

An expression on which the function is applied.

name
String

The name of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(String, String, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use NiladicFunction method.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use NiladicFunction method.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

schema
String

The schema in which the function is defined.

name
String

The name of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(SqlExpression, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use overload that explicitly specifies values for 'instancePropagatesNullability' and 'argumentsPropagateNullability' arguments.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies values for 'instancePropagatesNullability' and 'argumentsPropagateNullability' arguments.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies values for 'instancePropagatesNullability' and 'argumentsPropagateNullability' arguments.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

instance
SqlExpression

An expression on which the function is applied.

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(String, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
[System.Obsolete("Use overload that explicitly specifies value for 'argumentsPropagateNullability' argument.")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string? schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

schema
String

The schema in which the function is defined.

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Attributes

Applies to

Entity Framework Core 6.0 y otras versiones
Producto Versiones (Obsoleto)
Entity Framework Core 3.0, 3.1 (5.0, 6.0)

Function(String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Creates a new SqlExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Function (string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

nullable
Boolean

A bool value indicating whether this function can return null.

argumentsPropagateNullability
IEnumerable<Boolean>

A list of bool values indicating whether individual arguments propagate null to result.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Applies to

Entity Framework Core 9.0 y otras versiones
Producto Versiones
Entity Framework Core 5.0, 6.0, 7.0, 8.0, 9.0

Function(String, String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Creates a new SqlExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (string? schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Function (string? schema, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

schema
String

The schema in which the function is defined.

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

nullable
Boolean

A bool value indicating whether this function can return null.

argumentsPropagateNullability
IEnumerable<Boolean>

A list of bool values indicating whether individual arguments propagate null to result.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Applies to

Entity Framework Core 9.0 y otras versiones
Producto Versiones
Entity Framework Core 5.0, 6.0, 7.0, 8.0, 9.0

Function(SqlExpression, String, IEnumerable<SqlExpression>, Boolean, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Creates a new SqlExpression which represents a function call in a SQL tree.

C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, bool instancePropagatesNullability, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, bool instancePropagatesNullability, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Function (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression instance, string name, System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression> arguments, bool nullable, bool instancePropagatesNullability, System.Collections.Generic.IEnumerable<bool> argumentsPropagateNullability, Type returnType, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);

Parameters

instance
SqlExpression

An expression on which the function is applied.

name
String

The name of the function.

arguments
IEnumerable<SqlExpression>

The arguments of the function.

nullable
Boolean

A bool value indicating whether this function can return null.

instancePropagatesNullability
Boolean

A value indicating if instance propagates null to result.

argumentsPropagateNullability
IEnumerable<Boolean>

A list of bool values indicating whether individual arguments propagate null to result.

returnType
Type

The Type of the expression.

typeMapping
RelationalTypeMapping

The RelationalTypeMapping associated with the expression.

Returns

An expression representing a function call in a SQL tree.

Implements

Applies to

Entity Framework Core 9.0 y otras versiones
Producto Versiones
Entity Framework Core 5.0, 6.0, 7.0, 8.0, 9.0