MySqlDbFormatter

Implements the IDbFormatter interface for MySql database engines.

Namespace:
Inetdev.Data.MySql
Type:
Class
Public:
Yes
Protected:
No
Sealed:
No
Abstract:
No
Inherits from:
Inetdev.Data.AbstractDbFormatter

Constructors

MySqlDbFormatter

Default constructor

Signature:
public Void MySqlDbFormatter()

Properties

CatalogSeparator

Catalog separator.

Signature:
public String CatalogSeparator { get; }

QuoteIdentifierPrefix

Prefix to quote identifiers.

Signature:
public String QuoteIdentifierPrefix { get; }

QuoteIdentifierSuffix

Suffix to quote identifiers.

Signature:
public String QuoteIdentifierSuffix { get; }

QuoteParamPrefix

Prefix to quote parameters.

Signature:
public String QuoteParamPrefix { get; }

QuoteParamSuffix

Suffix to quote parameters.

Signature:
public String QuoteParamSuffix { get; }

SchemaSeparator

Schema separator.

Signature:
public String SchemaSeparator { get; }

Methods

FormatValue

Formats a value to be included within a statement.

Signature:
public String FormatValue(dataType, value)
Returns

A textual representation of value.

Parameters
Name Type Summary
dataType DbType The data type of the value.
value Object Value to be formatted.

GetDbDateTimeString

Returns a string for the database command that returns the server date and time.

Signature:
public String GetDbDateTimeString()
Returns

This returns the string for the MySql function NOW().

GetDbType

Returns the string for the requested data type.

Signature:
public String GetDbType(type)
Returns

A string representation of type.

Parameters
Name Type Summary
type DbType DbType for which to return it's string.