internal StoredProcedureSqlBuilder(SqlCharacters sqlCharacters, string procedureName)
: base(sqlCharacters)
{
this.InnerSql.Append(sqlCharacters.StoredProcedureInvocationCommand)
.Append(' ')
.Append(procedureName)
.Append(' ');
}
/// <summary>
/// Initialises a new instance of the <see cref="SelectSqlBuilder"/> class with an optional list of columns to select.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
/// <param name="column">The column.</param>
internal SelectSqlBuilder(SqlCharacters sqlCharacters, string column)
: base(sqlCharacters)
{
this.InnerSql.Append("SELECT ");
if (column != null)
{
this.InnerSql.Append(this.SqlCharacters.EscapeSql(column));
}
}
/// <summary>
/// Initialises a new instance of the <see cref="SelectSqlBuilder"/> class with an optional list of columns to select.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
/// <param name="columns">The columns.</param>
internal SelectSqlBuilder(SqlCharacters sqlCharacters, params string[] columns)
: base(sqlCharacters)
{
this.InnerSql.Append("SELECT ");
if (columns != null)
{
for (int i = 0; i < columns.Length; i++)
{
if (i > 0)
{
this.InnerSql.Append(',');
}
this.InnerSql.Append(this.SqlCharacters.EscapeSql(columns[i]));
}
}
}
/// <summary>
/// Initialises a new instance of the <see cref="SqlBuilderBase"/> class.
/// </summary>
/// <param name="sqlCharacters">The SQL characters for the builder.</param>
protected SqlBuilderBase(SqlCharacters sqlCharacters)
{
this.sqlCharacters = sqlCharacters;
}
/// <summary>
/// Initialises a new instance of the <see cref="InsertSqlBuilder"/> class with the starting command text 'INSERT INTO '.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
internal InsertSqlBuilder(SqlCharacters sqlCharacters)
: base(sqlCharacters)
{
this.InnerSql.Append("INSERT INTO ");
}
/// <summary>
/// Initialises a new instance of the <see cref="DbDriver" /> class.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
protected DbDriver(SqlCharacters sqlCharacters)
{
this.sqlCharacters = sqlCharacters;
}
/// <summary>
/// Initialises a new instance of the <see cref="DeleteSqlBuilder"/> class with the starting command text 'DELETE FROM '.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
internal DeleteSqlBuilder(SqlCharacters sqlCharacters)
: base(sqlCharacters)
{
this.InnerSql.Append("DELETE");
}
/// <summary>
/// Initialises a new instance of the <see cref="SqlDialect"/> class.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
protected SqlDialect(SqlCharacters sqlCharacters)
{
this.sqlCharacters = sqlCharacters;
}
protected WriteSqlBuilderBase(SqlCharacters sqlCharacters)
: base(sqlCharacters)
{
}
/// <summary>
/// Initialises a new instance of the <see cref="SelectSqlBuilder"/> class with the starting command text 'SELECT *'.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
internal SelectSqlBuilder(SqlCharacters sqlCharacters)
: base(sqlCharacters)
{
this.InnerSql.Append("SELECT *");
}
/// <summary>
/// Initialises a new instance of the <see cref="UpdateSqlBuilder"/> class with the starting command text 'UPDATE '.
/// </summary>
/// <param name="sqlCharacters">The SQL characters.</param>
internal UpdateSqlBuilder(SqlCharacters sqlCharacters)
: base(sqlCharacters)
{
this.InnerSql.Append("UPDATE ");
}