Table of Contents

Class MySqlDatabaseBuilder

Namespace
LfrlAnvil.MySql.Objects.Builders
Assembly
LfrlAnvil.MySql.dll

Represents an SQL database builder.

public sealed class MySqlDatabaseBuilder : SqlDatabaseBuilder, ISqlDatabaseBuilder
Inheritance
MySqlDatabaseBuilder
Implements
Inherited Members
Extension Methods

Remarks

MySqlDialect implementation.

Properties

Changes

Tracker of changes applied to this database.

public MySqlDatabaseChangeTracker Changes { get; }

Property Value

MySqlDatabaseChangeTracker

CharacterSetName

Specifies default DB character set.

public string? CharacterSetName { get; }

Property Value

string

CollationName

Specifies default DB collation.

public string? CollationName { get; }

Property Value

string

CommonSchemaName

Name of the common schema.

public string CommonSchemaName { get; }

Property Value

string

Remarks

This schema will contain common functions and procedures and it will not be possible to remove a schema with this name.

DataTypes

Provider of SQL data types.

public MySqlDataTypeProvider DataTypes { get; }

Property Value

MySqlDataTypeProvider

IndexFilterResolution

Specifies how partial indexes should be resolved.

public SqlOptionalFunctionalityResolution IndexFilterResolution { get; }

Property Value

SqlOptionalFunctionalityResolution

IsEncryptionEnabled

Specifies whether or not DB encryption should be enabled.

public bool? IsEncryptionEnabled { get; }

Property Value

bool?

NodeInterpreters

Factory of node interpreters.

public MySqlNodeInterpreterFactory NodeInterpreters { get; }

Property Value

MySqlNodeInterpreterFactory

ParameterBinders

Factory of parameter binders.

public MySqlParameterBinderFactory ParameterBinders { get; }

Property Value

MySqlParameterBinderFactory

QueryReaders

Factory of query readers.

public MySqlQueryReaderFactory QueryReaders { get; }

Property Value

MySqlQueryReaderFactory

Schemas

Collection of schemas defined in this database.

public MySqlSchemaBuilderCollection Schemas { get; }

Property Value

MySqlSchemaBuilderCollection

TypeDefinitions

Provider of column type definitions.

public MySqlColumnTypeDefinitionProvider TypeDefinitions { get; }

Property Value

MySqlColumnTypeDefinitionProvider

Methods

AddConnectionChangeCallback(Action<SqlDatabaseConnectionChangeEvent>)

public MySqlDatabaseBuilder AddConnectionChangeCallback(Action<SqlDatabaseConnectionChangeEvent> callback)

Parameters

callback Action<SqlDatabaseConnectionChangeEvent>

Callback to add.

Returns

MySqlDatabaseBuilder

this.

IsValidName(SqlObjectType, string)

Checks whether or not the provided name is valid for a given objectType.

[Pure]
public override bool IsValidName(SqlObjectType objectType, string name)

Parameters

objectType SqlObjectType

Object's type.

name string

Object's name to validate.

Returns

bool

true when name is valid, otherwise false.