DevForce Community Forum : Select case in LINQ http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Select case in LINQ Fri, 10 Apr 2026 23:53:31 -700 Wed, 05 Feb 2014 00:18:24 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4644 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Select case in LINQ : from i in Invoicesselect i.Description... http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17350#17350 Author: Engo
Subject: 4644
Posted: 05-Feb-2014 at 12:18am

from i in Invoices
select i.Description ?? "NullValue"

Translates to

SELECT 
CASE WHEN Extent1.Description IS NULL THEN 'NullValue' ELSE Extent1.Description END AS C1
FROM Invoice AS Extent1
]]> Wed, 05 Feb 2014 00:18:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17350#17350 Select case in LINQ : I would personally just bring... http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17349#17349 Author: smi-mark
Subject: 4644
Posted: 04-Feb-2014 at 10:13am

I would personally just bring them back as is from the table and not worry about trying to do that in SQL. Mapped something like decimal? or rate? (assuming C#) and then do a null check in the code. You could do something like


public int Rate { get { return _rate ?? 0; } }



Edited by smi-mark - 04-Feb-2014 at 10:13am]]> Tue, 04 Feb 2014 10:13:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17349#17349 Select case in LINQ : How would the be done in LINQ... http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17348#17348 Author: BillG
Subject: 4644
Posted: 04-Feb-2014 at 6:53am

How would the be done in LINQ objects

  tSQL = "SELECT CASE                                                     " & _
                 "       WHEN PerCapRate is null                                  " & _
                 "       THEN 0                                                   " & _
                 "       ELSE PerCapRate                                          " & _
                 "       END                         AS PerCapRate                " & _
                 "     , CASE                                                     " & _
                 "       WHEN WageMultiplier is null                              " & _
                 "         OR WageMultiplier = 0                                  " & _
                 "       THEN 1                                                   " & _
                 "       ELSE WageMultiplier                                      " & _
                 "       END                         AS WageMultiplier            " & _
                 "  FROM TradeRates                                      
]]> Tue, 04 Feb 2014 06:53:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4644&PID=17348#17348