C # long string line feed

Sometimes inCodeHas to write a long SQL statement. So how can we make it easy to wrap a line?

The best way is to use the @ symbol.

@ Tells the compiler that the following SQL statement does not need to be escaped:

StringSQL =@ "Select

A. numid, A. vc2title,

Vc2type = case when a. vc2type = '1' then' Supply 'When a. vc2type = '2' then' Please 'End,

A. numuserid, datadd = convert (varchar (10), a. datadd, 111), A. vc2term, B. vc2username

From t_supply a left join u_user B on A. numuserid = B. user_id

Where a. vc2status = '{0 }'";

SQL =String. Format (SQL, type );