Get a list of provider-specific literals used in text commands.

[acardenaskma]

Can we get a list of provider-specific literals used in text commands, using SqlConnection?

[lcheunglci]

Are you asking for what are the supported keywords used in the connection string? If so, you can use the names of the properties used in the SqlConnectionStringBuilder unless you're referring to the SqlCommand.CommandText, in that case, could you provide an example?

[acardenaskma]

Hello,
Yes, I'm referring to the literals used in the command text.
More here: oledbschemaguid.dbinfoliterals

Here's an example of how to get the literals using an ADODB Connection

        public static void LoadSchemaLiterals()
        {
            var connectionString = "....SQL Server connection string...";
            ADODB.Connection connection = new ADODB.Connection();
            connection.Open(connectionString, null, null);
            ADODB.Recordset recordSet = connection.OpenSchema(ADODB.SchemaEnum.adSchemaDBInfoLiterals, null, null);

            /*
            This will return records listing the schema literals from the database

            "QUOTE";
            "QUOTE_SUFFIX"
            "LIKE_PERCENT"
            "ESCAPE_PERCENT"
            "ESCAPE_PERCENT_SUFFIX"
            "LIKE_UNDERSCORE"
            "ESCAPE_UNDERSCORE"
            "ESCAPE_UNDERSCORE_SUFFIX"

            */
        }