What is the correct syntax in c# to create a line break in the middle of a mysql string?

Question

Possible Duplicate:
Multiline String Literal in C#

I'm probably not asking the right questions of Google to find my answer. I just want to keep my code neat without having a really long string on one line. I want to move to the next line without breaking the string.

cmd.CommandText = "UPDATE players SET firstname = CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

For example, I would like to break this into two lines without affecting the string. All help would be appreciated.

@ColeJohnson \n won't work on source file. – Lews Therin Sep 28 '12 at 17:49 — Lews Therin, Sep 28 '12 at 17:49

Joachim Isaksson · Accepted Answer · 2012-09-28T17:58:07.740

6

I suspect what you want is to use the @ for verbatim string literals; the advantage of verbatim strings is that escape sequences are not processed, and that they can span multiple lines.

cmd.CommandText = @"UPDATE players 
                    SET firstname = 
                      CASE id 
                        WHEN 1 THEN 'Jamie' 
                        WHEN 2 THEN 'Steve' 
                        WHEN 3 THEN 'Paula' 
                      END 
                    WHERE id IN (1,2,3)";

edited Sep 28 '12 at 17:58

answered Sep 28 '12 at 17:50

Joachim Isaksson

170,943
22
265
283

This was perfect. I'm sure the others work equally as well. Thanks to all who helped. – webby68 Sep 28 '12 at 18:04

score 4 · Answer 2 · answered Sep 28 '12 at 17:51

Use @ symbol before string. It will say to compiler that string is multiline.

cmd.CommandText = @"UPDATE players 
                    SET firstname = CASE id 
                        WHEN 1 THEN 'Jamie' 
                        WHEN 2 THEN 'Steve' 
                        WHEN 3 THEN 'Paula' 
                        END WHERE id IN (1,2,3)";

score 3 · Answer 3 · answered Sep 28 '12 at 17:50

You could use @ in fronf of your string. This is called Verbatim String Literal

cmd.CommandText = @"
 UPDATE players 
 SET firstname = CASE id 
                 WHEN 1 THEN 'Jamie' 
                 WHEN 2 THEN 'Steve' 
                 WHEN 3 THEN 'Paula' 
                 END 
 WHERE id IN (1,2,3)";

score 1 · Answer 4 · answered Sep 28 '12 at 17:50

1

like this

cmd.CommandText = "UPDATE players SET firstname =" +
   " CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3" + 
   " THEN 'Paula' END WHERE id IN (1,2,3)";

answered Sep 28 '12 at 17:50

Scott Selby

9,280
12
52
93

@ works as well, keep in mind with the way I showed , you have to remember to space at the beginning of the next line as prevent concatinating 2 words that aren't supposed to be – Scott Selby Sep 28 '12 at 17:53
@webby68 - its good to remember this as an option , even though it doesn't work quite as cleanly as the @ approach - if you ever have to write the same thing in VB.Net , the @ before a string is not allowed – Scott Selby Sep 28 '12 at 18:11

score 0 · Answer 5 · edited Sep 28 '12 at 17:50

0

Simpley concatenate your strings as follows:

cmd.CommandText = "UPDATE players SET firstname = CASE id WHEN 1 " 
cmd.CommandText +="THEN 'Jamie' WHEN 2 THEN 'Steve' WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

edited Sep 28 '12 at 17:50

Joel Etherton

36,697
10
85
101

answered Sep 28 '12 at 17:50

JSK NS

3,226
2
23
40

score 0 · Answer 6 · answered Sep 28 '12 at 17:50

0

It's called concatenation:

cmd.CommandText = "UPDATE players SET firstname" +
    " = CASE id WHEN 1 THEN 'Jamie' WHEN 2 THEN 'Steve'" +
    " WHEN 3 THEN 'Paula' END WHERE id IN (1,2,3)";

answered Sep 28 '12 at 17:50

Joel Etherton

36,697
10
85
101

score 0 · Answer 7 · answered Sep 28 '12 at 17:50

0

Like this?

cmd.CommandText = "text text" +
  "text text";

answered Sep 28 '12 at 17:50

Tim Destan

2,009
12
16

What is the correct syntax in c# to create a line break in the middle of a mysql string?

7 Answers7