Class SqlProviderMySql

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

SqlProvider for MySql databases.

public class SqlProviderMySql : SqlProvider

Inheritance

object

SqlProvider

SqlProviderMySql

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.DatabaseExists(string)

SqlProvider.EnsureConnection(string)

SqlProvider.OpenConnection(DbConnectionInfo)

SqlProvider.OpenConnection(string)

SqlProvider.BeginTransactionContext(DbConnectionInfo)

SqlProvider.BeginTransactionContext(string)

SqlProvider.NormalizeConnectionString(string)

SqlProvider.CreateConnectionString(string, string, string, 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.SelectForUpdateSql(string, string)

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.SetDefaultBeforeNotNullUpdateSql(string, string, string, bool)

SqlProvider.AddUniqueConstraintSql(string, string, string)

SqlProvider.AddForeignKeySql(string, string, string, string, string)

SqlProvider.GeneratorExists(string, string)

SqlProvider.CreateGenerator(string, string)

SqlProvider.SetGeneratorTo(string, string, int)

SqlProvider.SetTableGeneratorTo(string, string, int)

SqlProvider.NextIdByGenerator(DbTransaction, string)

SqlProvider.Name

SqlProvider.Factory

SqlProvider.ServerType

SqlProvider.ConnectionStringAdapter

SqlProvider.PositionalParameters

SqlProvider.Description

SqlProvider.ConnectionStringTemplate

SqlProvider.SupportsTransactions

SqlProvider.SupportedAlterTableTypes

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 this 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

FloatSql

Keyword, used in replacing a placeholder

public override string FloatSql { get; }

Property Value

string

LastIdSql

The SQL statement that returns the last inserted id.

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 for native parameters.

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 OidMode.

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 SQL statement that returns the current server date and time.

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[]

SuperUser

The super user name.

public override string SuperUser { get; }

Property Value

string

SuperUserPassword

The super user password.

public override string SuperUserPassword { get; }

Property Value

string

SupportsAutoIncFields

True if this provider supports auto-increment fields.

public override bool SupportsAutoIncFields { get; }

Property Value

bool

SupportsGenerators

True if this 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

ApplyRowLimit(string, int)

Applies a row limit to the SqlText.

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

CreateDatabase(string)

Creates a database.

public override bool CreateDatabase(string ConnectionString)

Parameters

ConnectionString string

Returns

bool

DropColumnDefaultSql(string, string)

Returns an "alter column" SQL statement.

public override string DropColumnDefaultSql(string TableName, string ColumnName)

Parameters

TableName string

ColumnName string

Returns

string

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

DropNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string DropNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType 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

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

SetColumnDefaultSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnDefaultSql(string TableName, string ColumnName, string DefaultExpression)

Parameters

TableName string

ColumnName string

DefaultExpression string

Returns

string

SetColumnLengthSql(string, string, string, string, string)

Returns an "alter column" SQL statement.

public override string SetColumnLengthSql(string TableName, string ColumnName, string DataType, string Required, string DefaultExpression)

Parameters

TableName string

ColumnName string

DataType string

Required string

DefaultExpression string

Returns

string

SetNotNullSql(string, string, string)

Returns an "alter column" SQL statement.

public override string SetNotNullSql(string TableName, string ColumnName, string DataType)

Parameters

TableName string

ColumnName string

DataType string

Returns

string