The Weird and The Wonderful

mark merrens wrote:

But why would anyone write it like that in the first place???

mark merrens wrote:

And let's not even begin to talk about why it should be a stored procedure...

private const string SQL = 
@"
SELECT ID
, NAME
, BIRTHDAY
FROM TABLE
WHERE NAME LIKE @PARAM
" ;

PIEBALDconsult wrote:

And I write it as

namespace mystuff.otherStuff
{
//---------------------------------------------------------------------------------------
/// <summary>
/// This is where I do database stuff
/// </summary>
//---------------------------------------------------------------------------------------
public static class MyDbConstants
{
private const string SQL1 = 
@"
SELECT ID
, NAME
, BIRTHDAY
FROM TABLE
WHERE NAME LIKE @PARAM
" ;

private const string SQL2 = 
@"
SELECT ID
, NAME
, BIRTHDAY
FROM TABLE_OTHER
WHERE NAME LIKE @PARAM
" ;

private const string SQL3 = 
@"
SELECT ID
, NAME
, BIRTHDAY
FROM TABLE_OTHER2
WHERE NAME LIKE @PARAM
" ;

// 100 other like the above with increasing complexity.

PIEBALDconsult wrote:

No, I don't use consts for
SQL.

PIEBALDconsult wrote:

I meant "that".

Brady Kelly wrote:

Looks pretty damned neat to me.

PIEBALDconsult wrote:

so it prints out nice in error messages.