/// <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; }