protected string QuoteIdentifier(string prefix, string name, string alias) { string Res = ""; if (string.IsNullOrEmpty(prefix) == false) { Res += Parameters.IdentifierOpenQuote + prefix + Parameters.IdentifierCloseQuote + "."; } if (SqlIdentifier.IsValidIdentifierName(name)) { Res += Parameters.IdentifierOpenQuote + name + Parameters.IdentifierCloseQuote; } else { // Do not quote. Not a real identifier. Res += name; } if (string.IsNullOrEmpty(alias) == false) { Res += " AS " + Parameters.IdentifierOpenQuote + alias + Parameters.IdentifierCloseQuote; } return(Res); }