public string QuoteIdentifier(string unquotedIdentifier, OleDbConnection connection) { ADP.CheckArgumentNull(unquotedIdentifier, "unquotedIdentifier"); // if the user has specificed a prefix use the user specified prefix and suffix // otherwise get them from the provider string quotePrefix = QuotePrefix; string quoteSuffix = QuoteSuffix; if (ADP.IsEmpty(quotePrefix) == true) { if (connection == null) { // Use the adapter's connection if QuoteIdentifier was called from // DbCommandBuilder instance (which does not have an overload that gets connection object) connection = DataAdapter?.SelectCommand?.Connection; if (connection == null) { throw ADP.QuotePrefixNotSet(ADP.QuoteIdentifier); } } connection.GetLiteralQuotes(ADP.QuoteIdentifier, out quotePrefix, out quoteSuffix); // if the quote suffix is null assume that it is the same as the prefix (See OLEDB spec // IDBInfo::GetLiteralInfo DBLITERAL_QUOTE_SUFFIX.) if (quoteSuffix == null) { quoteSuffix = quotePrefix; } } return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); }
public string QuoteIdentifier(string unquotedIdentifier, OdbcConnection connection) { ADP.CheckArgumentNull(unquotedIdentifier, "unquotedIdentifier"); string quotePrefix = this.QuotePrefix; string quoteSuffix = this.QuoteSuffix; if (ADP.IsEmpty(quotePrefix)) { if (connection == null) { connection = base.GetConnection() as OdbcConnection; if (connection == null) { throw ADP.QuotePrefixNotSet("QuoteIdentifier"); } } quotePrefix = connection.QuoteChar("QuoteIdentifier"); quoteSuffix = quotePrefix; } if (!ADP.IsEmpty(quotePrefix) && (quotePrefix != " ")) { return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); } return(unquotedIdentifier); }
public override string QuoteIdentifier(string unquotedIdentifier) { ADP.CheckArgumentNull(unquotedIdentifier, "unquotedIdentifier"); string quoteSuffix = this.QuoteSuffix; string quotePrefix = this.QuotePrefix; this.ConsistentQuoteDelimiters(quotePrefix, quoteSuffix); return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); }
public override string QuoteIdentifier(string unquotedIdentifier) { ADP.CheckArgumentNull(unquotedIdentifier, nameof(unquotedIdentifier)); string quoteSuffixLocal = QuoteSuffix; string quotePrefixLocal = QuotePrefix; ConsistentQuoteDelimiters(quotePrefixLocal, quoteSuffixLocal); return(ADP.BuildQuotedString(quotePrefixLocal, quoteSuffixLocal, unquotedIdentifier)); }
public string QuoteIdentifier(string unquotedIdentifier, OdbcConnection connection) { ADP.CheckArgumentNull(unquotedIdentifier, "unquotedIdentifier"); // if the user has specificed a prefix use the user specified prefix and suffix // otherwise get them from the provider string quotePrefix = QuotePrefix; string quoteSuffix = QuoteSuffix; if (ADP.IsEmpty(quotePrefix) == true) { if (connection == null) { // VSTFDEVDIV 479567: use the adapter's connection if QuoteIdentifier was called from // DbCommandBuilder instance (which does not have an overload that gets connection object) connection = base.GetConnection() as OdbcConnection; if (connection == null) { throw ADP.QuotePrefixNotSet(ADP.QuoteIdentifier); } } quotePrefix = connection.QuoteChar(ADP.QuoteIdentifier); quoteSuffix = quotePrefix; } // by the ODBC spec "If the data source does not support quoted identifiers, a blank is returned." // So if a blank is returned the string is returned unchanged. Otherwise the returned string is used // to quote the string if ((ADP.IsEmpty(quotePrefix) == false) && (quotePrefix != " ")) { return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); } else { return(unquotedIdentifier); } }
public string QuoteIdentifier(string unquotedIdentifier, OdbcConnection?connection) { ADP.CheckArgumentNull(unquotedIdentifier, nameof(unquotedIdentifier)); // if the user has specificed a prefix use the user specified prefix and suffix // otherwise get them from the provider string quotePrefix = QuotePrefix; string quoteSuffix = QuoteSuffix; if (string.IsNullOrEmpty(quotePrefix)) { if (connection == null) { // Use the adapter's connection if QuoteIdentifier was called from // DbCommandBuilder instance (which does not have an overload that gets connection object) connection = DataAdapter?.SelectCommand?.Connection; if (connection == null) { throw ADP.QuotePrefixNotSet(ADP.QuoteIdentifier); } } quotePrefix = connection.QuoteChar(ADP.QuoteIdentifier); quoteSuffix = quotePrefix; } // by the ODBC spec "If the data source does not support quoted identifiers, a blank is returned." // So if a blank is returned the string is returned unchanged. Otherwise the returned string is used // to quote the string if (!string.IsNullOrEmpty(quotePrefix) && quotePrefix != " ") { return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); } else { return(unquotedIdentifier); } }
public string QuoteIdentifier(string unquotedIdentifier, OleDbConnection connection) { ADP.CheckArgumentNull(unquotedIdentifier, "unquotedIdentifier"); string quotePrefix = this.QuotePrefix; string quoteSuffix = this.QuoteSuffix; if (ADP.IsEmpty(quotePrefix)) { if (connection == null) { connection = base.GetConnection() as OleDbConnection; if (connection == null) { throw ADP.QuotePrefixNotSet("QuoteIdentifier"); } } connection.GetLiteralQuotes("QuoteIdentifier", out quotePrefix, out quoteSuffix); if (quoteSuffix == null) { quoteSuffix = quotePrefix; } } return(ADP.BuildQuotedString(quotePrefix, quoteSuffix, unquotedIdentifier)); }