How to format SQL query without using string +

Question

I am currently formatting my SQL queries like this in C#:

  string query = "SELECT * "+
                   "FROM product p"+
                   "JOIN order o ON p.productID = o.productID";

Is there any alternative ways to achieve the above format without using the + sign?

Put it in a resource file ... use stored procedures ... use an ORM ... — ta.speot.is, Oct 24 '13 at 09:08
@ta.speot.is why would you intentionally make it harder to maintain? — Marc Gravell, Oct 24 '13 at 09:24

score 8 · Accepted Answer · answered Oct 24 '13 at 09:06

8

Use the @ symbol:

string query= @"SELECT *  
                  FROM product p 
                  JOIN order   o ON p.productID = o.productID";

answered Oct 24 '13 at 09:06

Harminder

1 Answers1