/// <summary>
/// Generates a unique name for an identifier, to use as a named parameter.
/// </summary>
/// <param name="columnIdentifier">The identifier definition.</param>
/// <returns>A string containing the generated name.</returns>
public string GetParameterName(SqlIdentifier columnIdentifier, int parameterNameSuffix)
{
if (parameterNameSuffix == 0)
{
return("param_" + columnIdentifier.Definition.Trim().Replace('.', '_').Replace(' ', '_'));
}
else
{
return("param_" + columnIdentifier.Definition.Trim().Replace('.', '_').Replace(' ', '_') + "_" + parameterNameSuffix.ToString());
}
}
public Delete(SqlIdentifier singleTable, Where whereClause)
: this(new SqlIdentifierCollection() { singleTable }, whereClause)
{
}
public Delete(SqlIdentifier singleTable)
: this(new SqlIdentifierCollection() { singleTable })
{
}
public Query(SqlIdentifier singleTable)
: this(new SqlIdentifierCollection() { singleTable })
{
}
public Statement(SqlIdentifier singleTable)
: this(new SqlIdentifierCollection() { singleTable })
{
}
public string SqlText(SqlIdentifier identifier)
{
return(this.QuoteIdentifier(identifier.Prefix, identifier.Name, identifier.Alias));
}
public Insert(SqlIdentifier singleTable)
: this(new SqlIdentifierCollection() { singleTable })
{
}
public Select(SqlIdentifier singleTable, bool forUpdate)
: this(new SqlIdentifierCollection() { singleTable })
{
this.ForUpdate = forUpdate;
}
public Join(SqlIdentifier table, string on)
{
this.Table = table;
this.On = on;
}
