Escaping single quotes

[arkajzerek]

How single quotes are escaped in case of parameters?

Trying to run simple query as follows:

select id from account where name = @name

@name is set using Parameters.AddWithValue method to "Arek's company"

Thanks.

[Shalex]

Here is an example of handling single quotes:

Code: Select all

        SalesforceCommand cmd = conn.CreateCommand();
        cmd.CommandText = "select * from account where type = @type";
        cmd.Parameters.AddWithValue("type", "Customers' account");
        cmd.Parameters[0].SalesforceType = SalesforceType.String;
        SalesforceDataReader reader = cmd.ExecuteReader();
        while (reader.Read()) {
            Console.WriteLine(reader["Name"]);
        }

If the SalesforceType.String type is set explicitly, dotConnect for Salesforce quotes single quote in the query which is sent to the server.