Class SqlProviderSqlite

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

SqlProvider for SQLite3 databases.

public class SqlProviderSqlite : SqlProvider

Inheritance

object

SqlProvider

SqlProviderSqlite

Inherited Members

SqlProvider.GlobalPrefix

SqlProvider.ReplaceDecimalPlaceholders(string)

SqlProvider.CreateParamMap(SqlParams)

SqlProvider.FindParam(Dictionary<string, SqlParam>, string, string)

SqlProvider.GetNativeParameterName(string)

SqlProvider.GetSqlParameterToken(string)

SqlProvider.CreateDbParameter(DbCommand, SqlParam)

SqlProvider.PrepareCommand(DbCommand, string, SqlParams)

SqlProvider.DecimalWithArgsSql(string)

SqlProvider.Log(Exception, string, object[], MemTable)

SqlProvider.FormatSqlLogValue(object)

SqlProvider.FormatSqlParameters(DbParameterCollection)

SqlProvider.CanLogSql(string)

SqlProvider.LogSql(DbCommand)

SqlProvider.CreateSqlParams(string, params object[])

SqlProvider.WaitUntilDatabaseReady(string, int, int)

SqlProvider.ReplaceDataTypePlaceholders(string)

SqlProvider.CreateConnectionStringBuilder(string)

SqlProvider.GetDatabaseName(string)

SqlProvider.CreateConnection(string)

SqlProvider.CreateCommand(DbConnection, string, params object[])

SqlProvider.CreateCommand(DbConnection, string, SqlParams)

SqlProvider.CanConnect(string, bool)

SqlProvider.EnsureConnection(string)

SqlProvider.OpenConnection(DbConnectionInfo)

SqlProvider.OpenConnection(string)

SqlProvider.BeginTransactionContext(DbConnectionInfo)

SqlProvider.BeginTransactionContext(string)

SqlProvider.Select(DbConnectionInfo, string)

SqlProvider.Select(DbConnectionInfo, string, params object[])

SqlProvider.Select(string, string)

SqlProvider.Select(string, string, params object[])

SqlProvider.Select(string, string, int, params object[])

SqlProvider.Select(DbTransaction, string, int, params object[])

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string)

SqlProvider.SelectTo(DbConnectionInfo, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, params object[])

SqlProvider.SelectTo(string, MemTable, string, int, params object[])

SqlProvider.SelectTo(DbTransaction, MemTable, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, string)

SqlProvider.ExecSql(DbConnectionInfo, string, params object[])

SqlProvider.ExecSql(string, string)

SqlProvider.ExecSql(string, string, params object[])

SqlProvider.ExecSql(string, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, IEnumerable<string>)

SqlProvider.ExecSql(string, IEnumerable<string>)

SqlProvider.ExecSql(DbTransaction, string)

SqlProvider.ExecSql(DbTransaction, string, params object[])

SqlProvider.ExecSql(DbTransaction, string, int, params object[])

SqlProvider.ExecSql(DbConnectionInfo, Action<DbTransaction>)

SqlProvider.ExecSql(string, Action<DbTransaction>)

SqlProvider.SelectResults(string, string)

SqlProvider.SelectResults(string, string, params object[])

SqlProvider.SelectResults(DbTransaction, string, int, params object[])

SqlProvider.SelectResult(string, string)

SqlProvider.SelectResult(string, string, object)

SqlProvider.SelectResult(string, string, object, params object[])

SqlProvider.SelectResult(DbTransaction, string, int, object, params object[])

SqlProvider.IntegerResult(string, string, int)

SqlProvider.IntegerResult(string, string, int, params object[])

SqlProvider.IntegerResult(DbTransaction, string, int, int, params object[])

SqlProvider.SelectForUpdate(DbTransaction, string, string, object)

SqlProvider.SelectForUpdate(DbTransaction, string, string, int, object)

SqlProvider.SelectIncrementLocked(DbConnectionInfo, string, string, object, string)

SqlProvider.SelectIncrementLocked(string, string, string, object, string, int)

SqlProvider.SelectIncrementLocked(DbTransaction, string, string, object, string, int)

SqlProvider.NormalizeRowLimit(int)

SqlProvider.QuoteName(string)

SqlProvider.GetServerDateTime(DbConnectionInfo)

SqlProvider.GetServerDateTime(string)

SqlProvider.QSDate(DateTime)

SqlProvider.QSDateTime(DateTime)

SqlProvider.SupportsAlterTableType(AlterTableType)

SqlProvider.AddColumnSql(string, string)

SqlProvider.DropColumnSql(string, string)

SqlProvider.SetColumnLengthSql(string, string, string, string, string)

SqlProvider.SetDefaultBeforeNotNullUpdateSql(string, string, string, bool)

SqlProvider.SetNotNullSql(string, string, string)

SqlProvider.DropNotNullSql(string, string, string)

SqlProvider.SetColumnDefaultSql(string, string, string)

SqlProvider.DropColumnDefaultSql(string, string)

SqlProvider.GeneratorExists(string, string)

SqlProvider.CreateGenerator(string, string)

SqlProvider.SetGeneratorTo(string, string, int)

SqlProvider.NextIdByGenerator(DbTransaction, string)

SqlProvider.Name

SqlProvider.Factory

SqlProvider.ServerType

SqlProvider.ConnectionStringAdapter

SqlProvider.PositionalParameters

SqlProvider.ConnectionStringTemplate

SqlProvider.SupportsTransactions

SqlProvider.SuperUser

SqlProvider.SuperUserPassword

SqlProvider.DefaultCommandTimeoutSeconds

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

TypeExtensions.InheritsFrom(object, Type)

Properties

AutoIncSql

Keyword, used in replacing a placeholder

public override string AutoIncSql { get; }

Property Value

string

BlobSql

Keyword, used in replacing a placeholder

public override string BlobSql { get; }

Property Value

string

BlobTextSql

Keyword, used in replacing a placeholder

public override string BlobTextSql { get; }

Property Value

string

BoolSql

Keyword, used in replacing a placeholder

public override string BoolSql { get; }

Property Value

string

CanCreateDatabases

True if the provider can create databases.

public override bool CanCreateDatabases { get; }

Property Value

bool

DatabaseKeys

A list of strings used as database name key in connection strings.

public override string[] DatabaseKeys { get; }

Property Value

string[]

DateSql

Keyword, used in replacing a placeholder

public override string DateSql { get; }

Property Value

string

DateTimeSql

Keyword, used in replacing a placeholder

public override string DateTimeSql { get; }

Property Value

string

DecimalSql

Keyword, used in replacing a placeholder

public override string DecimalSql { get; }

Property Value

string

Description

The description of this sql provider

public override string Description { get; }

Property Value

string

FloatSql

Keyword, used in replacing a placeholder

public override string FloatSql { get; }

Property Value

string

LastIdSql

The keyword that can be used to return the last inserted id in an SQL statement.

public override string LastIdSql { get; }

Property Value

string

NBlobTextSql

Keyword, used in replacing a placeholder

public override string NBlobTextSql { get; }

Property Value

string

NVarcharSql

Keyword, used in replacing a placeholder

public override string NVarcharSql { get; }

Property Value

string

NativePrefix

The prefix used in parameter names.

public override string NativePrefix { get; }

Property Value

string

NotNullSql

Keyword, used in replacing a placeholder

public override string NotNullSql { get; }

Property Value

string

NullSql

Keyword, used in replacing a placeholder

public override string NullSql { get; }

Property Value

string

ObjectEndDelimiter

The delimiter used to quote object names.

public override string ObjectEndDelimiter { get; }

Property Value

string

ObjectStartDelimiter

The delimiter used to quote object names.

public override string ObjectStartDelimiter { get; }

Property Value

string

OidMode

The OID mode this provider supports.

public override OidMode OidMode { get; }

Property Value

OidMode

PasswordKeys

A list of strings used as password key in connection strings.

public override string[] PasswordKeys { get; }

Property Value

string[]

PrimaryKeySql

Keyword, used in replacing a placeholder

public override string PrimaryKeySql { get; }

Property Value

string

ServerDateTimeSql

The keyword that can be used to return the current datetime in an SQL statement.

public override string ServerDateTimeSql { get; }

Property Value

string

ServerKeys

A list of strings used as server name key in connection strings.

public override string[] ServerKeys { get; }

Property Value

string[]

SupportedAlterTableTypes

Returns a set (bit-field) of the supported alter table operations.

public override AlterTableType SupportedAlterTableTypes { get; }

Property Value

AlterTableType

SupportsAutoIncFields

True if the provider supports auto-increment fields.

public override bool SupportsAutoIncFields { get; }

Property Value

bool

SupportsGenerators

True if the provider supports generators.

public override bool SupportsGenerators { get; }

Property Value

bool

UserNameKeys

A list of strings used as user name key in connection strings.

public override string[] UserNameKeys { get; }

Property Value

string[]

VarcharSql

Keyword, used in replacing a placeholder

public override string VarcharSql { get; }

Property Value

string

Methods

AddForeignKeySql(string, string, string, string, string)

Returns an "alter table" SQL statement for adding a foreign key constraint

public override string AddForeignKeySql(string TableName, string ColumnName, string ForeignTableName, string ForeignColumnName, string ConstraintName)

Parameters

TableName string

ColumnName string

ForeignTableName string

ForeignColumnName string

ConstraintName string

Returns

string

AddUniqueConstraintSql(string, string, string)

Returns an "alter table" SQL statement for adding a unique constraint

public override string AddUniqueConstraintSql(string TableName, string ColumnName, string ConstraintName)

Parameters

TableName string

ColumnName string

ConstraintName string

Returns

string

ApplyRowLimit(string, int)

Applies a row limit to the specified SQL text.

public override string ApplyRowLimit(string SqlText, int RowLimit)

Parameters

SqlText string

RowLimit int

Returns

string

Concat(params string[])

Returns a concatenation of the specified parts.

public override string Concat(params string[] Parts)

Parameters

Parts string[]

Returns

string

CreateConnectionString(string, string, string, string)

Creates a connection string based on the specified server, database, user name and password.

public override string CreateConnectionString(string Server, string Database, string UserName, string Password)

Parameters

Server string

Database string

UserName string

Password string

Returns

string

CreateDatabase(string)

Creates the database represented by the specified connection string.

public override bool CreateDatabase(string ConnectionString)

Parameters

ConnectionString string

Returns

bool

DatabaseExists(string)

Returns true if the database represented by the specified database exists, by checking the connection.

public override bool DatabaseExists(string ConnectionString)

Parameters

ConnectionString string

Returns

bool

DropForeignKeySql(string, string)

Returns an "alter table" SQL statement for dropping a foreign key constraint

public override string DropForeignKeySql(string TableName, string ConstraintName)

Parameters

TableName string

ConstraintName string

Returns

string

DropUniqueConstraintSql(string, string)

Returns an "alter table" SQL statement for dropping a unique constraint

public override string DropUniqueConstraintSql(string TableName, string ConstraintName)

Parameters

TableName string

ConstraintName string

Returns

string

LastId(DbTransaction, string)

Returns the last id produced by an INSERT Sqlt statement.

It should be used only with databases that support identity (auto-increment) columns

public override int LastId(DbTransaction Transaction, string TableName)

Parameters

Transaction DbTransaction

TableName string

Returns

int

NormalizeConnectionString(string)

Normalizes the specified connection string.

public override string NormalizeConnectionString(string ConnectionString)

Parameters

ConnectionString string

Returns

string

RenameColumnSql(string, string, string)

Returns an "alter column" SQL statement.

public override string RenameColumnSql(string TableName, string ColumnName, string NewColumnName)

Parameters

TableName string

ColumnName string

NewColumnName string

Returns

string

SelectForUpdateSql(string, string)

Returns a SELECT statement used inside a transaction to select a row for update.

public override string SelectForUpdateSql(string TableName, string FieldName)

Parameters

TableName string

FieldName string

Returns

string

SetTableGeneratorTo(string, string, int)

Attempts to set a generator/sequencer or identity column to Value.

VERY DANGEROOUS.

public override void SetTableGeneratorTo(string ConnectionString, string TableName, int Value)

Parameters

ConnectionString string

TableName string

Value int