Class SQLiteDataProvider

Namespace

LinqToDB.DataProvider.SQLite

Assembly

linq2db.dll

public abstract class SQLiteDataProvider : DynamicDataProviderBase<SQLiteProviderAdapter>, IDataProvider

Inheritance

object

DataProviderBase

DynamicDataProviderBase<SQLiteProviderAdapter>

SQLiteDataProvider

Implements

IDataProvider

Inherited Members

DynamicDataProviderBase<SQLiteProviderAdapter>.GetProviderSpecificValueReaderMethod

DynamicDataProviderBase<SQLiteProviderAdapter>.Adapter

DynamicDataProviderBase<SQLiteProviderAdapter>.ConnectionNamespace

DynamicDataProviderBase<SQLiteProviderAdapter>.DataReaderType

DynamicDataProviderBase<SQLiteProviderAdapter>.TransactionsSupported

DynamicDataProviderBase<SQLiteProviderAdapter>.CreateConnectionInternal(string)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetField(Type, string, string, bool, Type)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetProviderField<TField>(string, Type)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetProviderField(Type, string, Type)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetToTypeField(Type, string, Type)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetProviderField<TTo, TField>(string, bool, Type)

DynamicDataProviderBase<SQLiteProviderAdapter>.SetProviderField(Type, Type, string, bool, Type, string)

DynamicDataProviderBase<SQLiteProviderAdapter>.TryGetProviderParameter(IDataContext, DbParameter)

DynamicDataProviderBase<SQLiteProviderAdapter>.TryGetProviderCommand(IDataContext, DbCommand)

DynamicDataProviderBase<SQLiteProviderAdapter>.TryGetProviderConnection(IDataContext, DbConnection)

DynamicDataProviderBase<SQLiteProviderAdapter>.TryGetProviderTransaction(IDataContext, DbTransaction)

DataProviderBase.Name

DataProviderBase.MappingSchema

DataProviderBase.SqlProviderFlags

DataProviderBase.OnConnectionCreated

DataProviderBase.InitContext(IDataContext)

DataProviderBase.ID

DataProviderBase.CreateConnection(string)

DataProviderBase.InitCommand(DataConnection, DbCommand, CommandType, string, DataParameter[], bool)

DataProviderBase.ClearCommandParameters(DbCommand)

DataProviderBase.DisposeCommand(DbCommand)

DataProviderBase.GetConnectionInfo(DataConnection, string)

DataProviderBase.GetCommandBehavior(CommandBehavior)

DataProviderBase.ReaderExpressions

DataProviderBase.SetCharField(string, Expression<Func<DbDataReader, int, string>>)

DataProviderBase.SetCharFieldToType<T>(string, Expression<Func<DbDataReader, int, string>>)

DataProviderBase.SetField<TP, T>(Expression<Func<TP, int, T>>)

DataProviderBase.SetField<TP, T>(string, Expression<Func<TP, int, T>>)

DataProviderBase.SetField<TP, T>(string, Type, Expression<Func<TP, int, T>>)

DataProviderBase.SetProviderField<TP, T>(Expression<Func<TP, int, T>>)

DataProviderBase.SetProviderField<TP, T, TS>(Expression<Func<TP, int, T>>)

DataProviderBase.SetToType<TP, T, TF>(Expression<Func<TP, int, T>>)

DataProviderBase.SetToType<TP, T, TF>(string, Expression<Func<TP, int, T>>)

DataProviderBase.GetReaderExpression(DbDataReader, int, Expression, Type)

DataProviderBase.FindExpression(ReaderInfo, out Expression)

DataProviderBase.ConvertParameterType(Type, DbDataType)

DataProviderBase.GetQueryParameterNormalizer()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

SQLiteDataProvider(string)

Creates the specified SQLite provider based on the provider name.

protected SQLiteDataProvider(string name)

Parameters

name string

If ProviderName.SQLite is provided, the detection mechanism preferring System.Data.SQLite to Microsoft.Data.Sqlite will be used.

SQLiteDataProvider(string, MappingSchema)

protected SQLiteDataProvider(string name, MappingSchema mappingSchema)

Parameters

name string

mappingSchema MappingSchema

Properties

SupportedTableOptions

public override TableOptions SupportedTableOptions { get; }

Property Value

TableOptions

Methods

BulkCopyAsync<T>(DataOptions, ITable<T>, IEnumerable<T>, CancellationToken)

public override Task<BulkCopyRowsCopied> BulkCopyAsync<T>(DataOptions options, ITable<T> table, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull

Parameters

options DataOptions

table ITable<T>

source IEnumerable<T>

cancellationToken CancellationToken

Returns

Task<BulkCopyRowsCopied>

Type Parameters

T

BulkCopy<T>(DataOptions, ITable<T>, IEnumerable<T>)

public override BulkCopyRowsCopied BulkCopy<T>(DataOptions options, ITable<T> table, IEnumerable<T> source) where T : notnull

Parameters

options DataOptions

table ITable<T>

source IEnumerable<T>

Returns

BulkCopyRowsCopied

Type Parameters

T

CreateSqlBuilder(MappingSchema, DataOptions)

public override ISqlBuilder CreateSqlBuilder(MappingSchema mappingSchema, DataOptions dataOptions)

Parameters

mappingSchema MappingSchema

dataOptions DataOptions

Returns

ISqlBuilder

ExecuteScope(DataConnection)

Creates disposable object, which should be disposed by caller after database query execution completed. Could be used to execute provider's method with scope-specific settings, e.g. with Invariant culture to workaround incorrect culture handling in provider.

public override IExecutionScope? ExecuteScope(DataConnection dataConnection)

Parameters

dataConnection DataConnection

Current data connection object.

Returns

IExecutionScope

Scoped execution disposable object or null if provider doesn't need scoped configuration.

GetSchemaProvider()

public override ISchemaProvider GetSchemaProvider()

Returns

ISchemaProvider

GetSqlOptimizer(DataOptions)

public override ISqlOptimizer GetSqlOptimizer(DataOptions dataOptions)

Parameters

dataOptions DataOptions

Returns

ISqlOptimizer

IsDBNullAllowed(DataOptions, DbDataReader, int)

public override bool? IsDBNullAllowed(DataOptions options, DbDataReader reader, int idx)

Parameters

options DataOptions

reader DbDataReader

idx int

Returns

bool?

NormalizeTypeName(string?)

protected override string? NormalizeTypeName(string? typeName)

Parameters

typeName string

Returns

string

SetParameter(DataConnection, DbParameter, string, DbDataType, object?)

public override void SetParameter(DataConnection dataConnection, DbParameter parameter, string name, DbDataType dataType, object? value)

Parameters

dataConnection DataConnection

parameter DbParameter

name string

dataType DbDataType

value object

SetParameterType(DataConnection, DbParameter, DbDataType)

protected override void SetParameterType(DataConnection dataConnection, DbParameter parameter, DbDataType dataType)

Parameters

dataConnection DataConnection

parameter DbParameter

dataType DbDataType