How to format SQL query without using string + [duplicate]

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
– ta.speot.is, Commented Oct 24, 2013 at 9:08
@ta.speot.is why would you intentionally make it harder to maintain? — Marc Gravell
– Marc Gravell, Commented Oct 24, 2013 at 9:24

Harminder · Accepted Answer · 2013-10-24 09:06:20Z

8

Use the @ symbol:

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

answered Oct 24, 2013 at 9:06

Harminder

2,23923 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1