Wednesday, March 17, 2010

SQL Style Extensions for C#

Are you addicted to SQL? Are you uncomfortable whenever you have to use pesky imperative languages like C#? Now you can use your favourite SQL functions inside C#, with the amazing new "SQL Style Extensions" class! Need to know if a value is in a short list of constants? In SQL you'd simply write "where State in ('QLD','NSW','VIC')" – but, until recently C# forced you to write:

   if (State == "QLD" || State == "NSW" || State == "VIC")

But now -- thanks to the aMAZzing new 'SQL Style Extensions' -- you can simply write:

   If (State.In("QLD","NSW","VIC"))

... then close down the IDE and get back to your Entity Diagrams in no time!

Do you miss the power of LIKE matching?

Read more: SecretGeek

Posted via email from jasper22's posterous