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.
Escaping single quotes
Re: Escaping single quotes
Here is an example of handling single quotes:
If the SalesforceType.String type is set explicitly, dotConnect for Salesforce quotes single quote in the query which is sent to the server.
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"]);
}