Has anything ever come of this?

http://llblgen.com/TinyForum/Messages.aspx?ThreadID=2715

Sorry, this should have been posted in the Architecture forum, not Bugs/Issues.

ScottCate wrote:

Sorry, this should have been posted in the Architecture forum, not Bugs/Issues.

done

And to answer your question: CASE Isn't implemented as it's data-consumer oriented. If you want to have a CASE statement which selects a or b based on a NULL value, you could use DbFunctionCall and COALESCE, but IMHO, you should solve case statements in the data consuming side.

Really would like to have this support though. Would like to sort on a case statement, cannot solve that on data consuming side.

Maybe you can roll support for this in along with the CAST and other such functions that are not supported yet....

The problem with implementing support for case is that it will be an awkward construct I'm afraid, as in: verbose lines of code. The functions you talk about are something else, that's a different feature.

If you can pull it off, would love to have the ability - I know it is on your list and you know people want it - so I will leave you alone...

WayneBrantley wrote:

If you can pull it off, would love to have the ability - I know it is on your list and you know people want it - so I will leave you alone...