static void Main(string[] args) { OracleCommandBuilder builder = new OracleCommandBuilder(); string quoteIdentifier = builder.QuoteIdentifier("US\"ER"); //quoteIdentifier for "US\"ER" is (\"US\"\"ER\") Console.WriteLine("quoteIdentifier is {0}", quoteIdentifier); }
static void Main(string[] args) { //create an OracleCommandBuilder object. OracleCommandBuilder builder = new OracleCommandBuilder(); string identifier = "US\"ER"; Console.WriteLine("Identifier is {0}", identifier); // quote the identifier string quoteIdentifier = builder.QuoteIdentifier(identifier); //quoteIdentifier of "US\"ER" is (\"US\"\"ER\") Console.WriteLine("QuotedIdentifier is {0}", quoteIdentifier); string unquoteIdentifier = builder.UnquoteIdentifier(quoteIdentifier); //And its unquoteIdentifier is US\"ER Console.WriteLine("UnquotedIdentifier is {0}", unquoteIdentifier); }
/// <summary> /// Returns Oracle quoted column identifier /// </summary> /// <param name="identifier">Column identifier</param> /// <returns>Oracle quoted column identifier</returns> protected override string GetQuotedIdentifier(string identifier) => builder.QuoteIdentifier(identifier);
public static string QuoteSchemaAndTable(this string sqlQuery, string schemaName, string tableName) { var cb = new OracleCommandBuilder(); return(string.Format(sqlQuery, cb.QuoteIdentifier(schemaName), cb.QuoteIdentifier(tableName))); }
public static string QuoteSchemaAndTable(this string sqlQuery, string schemaName, string tableName) { var cb = new OracleCommandBuilder(); return string.Format(sqlQuery, cb.QuoteIdentifier(schemaName), cb.QuoteIdentifier(tableName)); }