title: How do you embed sql queries in c#
body: <p>I'm writing a new project in C# with a number of SQL queries in it. Some are relatively large and complex. I want to know what the best way to store them is. Ideally I would create stored procedures on the database, but the database is used by many other applications so it's better if I can keep the procedures which are specific to my application in my application.</p>
  
  <p>Options seem to be:</p>
  
  <ol>
  <li>a string literal (<code>const string query ="Select * From MyTable"</code>)
  <ul>
  <li>Pros: simple, short</li>
  <li>Cons: no Syntax highlighting, messy for long queries</li>
  </ul></li>
  <li>Create a file for each query as <code>QueryName.sql</code>
  <ul>
  <li>Pros: syntax highlighting, neater for large, complex queries</li>
  <li>Cons: lots of files for lots of queries (one query per file), maybe slower to read query from content file?</li>
  </ul></li>
  <li>Any other ideas?</li>
  </ol>
  
  <p>As an additional thought, is there a way to easily generate strongly typed class definitions from the SQL queries?</p>