Share via


SqliteDbFunctionsExtensions.Substr Method

Definition

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.

Applies to

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.

Applies to