SqliteDbFunctionsExtensions.Substr Method

Definition

Namespace:

Microsoft.EntityFrameworkCore

Assembly:

Microsoft.EntityFrameworkCore.Sqlite.dll

Package:

Microsoft.EntityFrameworkCore.Sqlite.Core v8.0.0

Overloads

Substr(DbFunctions, Byte[], Int32)	Maps to the SQLite substr function which returns a subarray of the specified value. The subarray starts at startIndex and continues to the end of the value.
Substr(DbFunctions, Byte[], Int32, Int32)	Maps to the SQLite substr function which returns a subarray of the specified value. The subarray starts at startIndex and has the specified length.

Substr(DbFunctions, Byte[], Int32)

Maps to the SQLite substr function which returns a subarray of the specified value. The subarray starts at startIndex and continues to the end of the value.

public static byte[] Substr (this Microsoft.EntityFrameworkCore.DbFunctions _, byte[] bytes, int startIndex);

static member Substr : Microsoft.EntityFrameworkCore.DbFunctions * byte[] * int -> byte[]

<Extension()>
Public Function Substr (_ As DbFunctions, bytes As Byte(), startIndex As Integer) As Byte()

Parameters

_

DbFunctions

The DbFunctions instance.

bytes

Byte[]

The binary value.

startIndex

Int32

The 1-based starting index. If negative, the index is relative to the end of the value.

Returns

Byte[]

The subarray.

Remarks

See Database functions, and Accessing SQLite databases with EF Core for more information and examples.

Substr(DbFunctions, Byte[], Int32, Int32)

Maps to the SQLite substr function which returns a subarray of the specified value. The subarray starts at startIndex and has the specified length.

public static byte[] Substr (this Microsoft.EntityFrameworkCore.DbFunctions _, byte[] bytes, int startIndex, int length);

static member Substr : Microsoft.EntityFrameworkCore.DbFunctions * byte[] * int * int -> byte[]

<Extension()>
Public Function Substr (_ As DbFunctions, bytes As Byte(), startIndex As Integer, length As Integer) As Byte()

Parameters

_

DbFunctions

The DbFunctions instance.

bytes

Byte[]

The binary value.

startIndex

Int32

The 1-based starting index. If negative, the index is relative to the end of the value.

length

Int32

The length of the subarray. If negative, bytes preceding startIndex are returned.

Returns

Byte[]

The subarray.

Remarks

See Database functions, and Accessing SQLite databases with EF Core for more information and examples.