SqliteDbFunctionsExtensions Class

Definition

Contains extension methods on DbFunctions for the Microsoft.EntityFrameworkCore.Sqlite provider.

public static class SqliteDbFunctionsExtensions
type SqliteDbFunctionsExtensions = class
Public Module SqliteDbFunctionsExtensions
Inheritance
SqliteDbFunctionsExtensions

Remarks

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

Methods

Glob(DbFunctions, String, String)

Maps to the SQLite glob function which is similar to Like(DbFunctions, String, String) but uses the file system globbing syntax instead.

Hex(DbFunctions, Byte[])

Maps to the SQLite hex function which returns a hexadecimal string representing the specified value.

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.

Unhex(DbFunctions, String)

Maps to the SQLite unhex function which returns a BLOB representing decoding of the hexadecimal string.

Unhex(DbFunctions, String, String)

Maps to the SQLite unhex function which returns a BLOB representing decoding of the hexadecimal string.

Applies to