Proper Way to Format SQL Query Within C# Application

Question

I have a C# console application that makes a bunch of queries to a database server.

I frequently need to modify the SQL and would like to simply copy/paste the SQL from my SQL Editor into my C# source without having to reformat the SQL every time.

Currently, the SQL is all on one line... like below:

  OleDbDataAdapter da_ssm_servers = new OleDbDataAdapter(@"SELECT * FROM mytable ORDER BY Server;", connSSM);

The SQL is much longer than above with a lot of table JOINS, etc.

I would like to keep the formatting, but don't really want to have to go back and add quotes around each line, etc.

If anyone has any recommendations and examples, it would be appreciated.

Answer 1

I do it like this:

string sql = @"
    SELECT * 
    FROM mytable 
    ORDER BY Server";
OleDbDataAdapter da_ssm_servers = new OleDbDataAdapter(sql, connSSM);