Inetdev Framework

SQLiteDbFormatter

Implements an IDbFormatter for SQLite.

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

Constructors

SQLiteDbFormatter

Default constructor

Signature:
public Void SQLiteDbFormatter()

Properties

CatalogSeparator

Catalog separator.

Signature:
public String CatalogSeparator { get; }
Remarks

SQLite does not require catalog.

QuoteIdentifierPrefix

Prefix for quote identifers.

Signature:
public String QuoteIdentifierPrefix { get; }

QuoteIdentifierSuffix

Suffix for quote identifiers.

Signature:
public String QuoteIdentifierSuffix { get; }

QuoteParamPrefix

Prefix for quote parameters.

Signature:
public String QuoteParamPrefix { get; }

QuoteParamSuffix

Suffix for 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

Get a string representation of the database instruction to retrieve the current database server date time.

Signature:
public String GetDbDateTimeString()
Returns

Database date-time command string.

GetDbType

Get the string for the specified data type.

Signature:
public String GetDbType(type)
Returns

A string representation of the data type.

Parameters
Name Type Summary
type DbType The data type to get the string of

In this document