How to deal with quotes within quotes in C#?

Question

Main Question:
Is there a way to insert ONE double quotation in a string in C#

Information:
I am trying to perform something like the following SQL Select statement in C#

SELECT Name FROM Production.Product
WHERE CONTAINS(Name, '"chain*"');  

I interpreted it this as follows:

string selectCommand= @"select Name from Production.Products  
WHERE contains (Name,'\"" + chain+ "*\"')");

But I'm getting the string back as:

" WHERE contains (Name,'"chain"')"

I've also tried the way in this SOF question but it didn't work either!:

string selectCommand= @"select Name from Production.Products  
where contains (doc.document_name,'"""""" + full + """"""')");

Answer 1

If you look at the documentation for string literals you will find that there are two formats. The regular format where you have to escape all teh following characters:

', ", \, 0, a, b, f, n, r, t, u, U, x, v.

So your string should be written as follows:

string query = "WHERE CONTAINS(Name, \'\"chain*\"\');";

or verbatim literals, which are preceded with an 'at' symbol, where you only escape double quotes by 'doubling up':

string query = @"WHERE CONTAINS(Name, '""chain*""');";

So just drop the '@' from your string and it will work.

Answer 2

Its because you have a @ at the start of your string

string selectCommand= "select Name from Production.Products where contains (doc.document_name,\'\"" + full + "*\"\');";

You basically need to escape the ' and "