DevForce Community Forum : Inner/Left Join and Coalesce http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Inner/Left Join and Coalesce Wed, 13 May 2026 03:48:38 -700 Mon, 20 Aug 2012 12:30:13 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3585 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Inner/Left Join and Coalesce : I wasn't asking to convert... http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14230#14230 Author: paul
Subject: 3585
Posted: 20-Aug-2012 at 12:30pm

I wasn't asking to convert verbatim. I was curious if one of the DevForce professionals had a better way of writing as linq then the EF kludge I came up with. ]]> Mon, 20 Aug 2012 12:30:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14230#14230 Inner/Left Join and Coalesce : Hi Paul,DevForce does not... http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14229#14229 Author: sbelini
Subject: 3585
Posted: 20-Aug-2012 at 12:21pm

Hi Paul,
 
DevForce does not have any special feature when converting a Linq query from SQL.
There is a third party tool, Linqer, that might help you in the process of converting your queries.
 
Regards,
   Silvio.
]]> Mon, 20 Aug 2012 12:21:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14229#14229 Inner/Left Join and Coalesce : I have a stored procedure I would... http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14222#14222 Author: paul
Subject: 3585
Posted: 19-Aug-2012 at 6:12pm

I have a stored procedure I would like to convert to a linq expression. I've seen many EF examples but they don't seem very clean. I am curious if there is a better way of writing it using some DevForce tricks that would make it more efficient. I'd like to avoid selecting into a new object if I could but not necessary. 

My entities are 1:1 to my SQL tables and I do have an associations between my Regions and RegionLocalizeds entities.

Input param: @LanguageTypeId uniqueidentifier = null

SELECT 
    r.RegionId, 
    r.CountryId, 
    Coalesce(rl.FullDescription, rDefault.FullDescription) as FullDescription, 
    Coalesce(rl.StandardAbbreviation, rDefault.StandardAbbreviation )as StandardAbbreviation 
FROM dbo.Region r 
INNER JOIN RegionLocalized rDefault ON rDefault.RegionId = r.RegionId AND rDefault.LanguageTypeId = '00000000-0000-0000-0000-000000000000'
LEFT JOIN RegionLocalized rl ON r.RegionId = rl.RegionId AND rl.LanguageTypeId = @LanguageTypeId

]]> Sun, 19 Aug 2012 18:12:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3585&PID=14222#14222