Combine 2 linq queries. RSS

• • Reply
  

  charly.p

  Member

  348 Points

  305 Posts

  Combine 2 linq queries.

  Jul 27, 2010 02:45 PM|LINK

  Dear all,

  Is it possible to combine these 2 linq queries ?

  select l;

  
  
  

• • Reply
  

  dotnetruler

  Contributor

  4230 Points

  753 Posts

  Re: Combine 2 linq queries.

  Jul 27, 2010 07:15 PM|LINK

  <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">var qry =  from l in context.TB_LANGUAGEs</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">           join sl in context.TB_SCRIPT_LANGUAGEs</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">           on l.ID equals sl.SCRIPT_LANG_ID</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">           where sl.SCRIPT_ID == (from c in context.TB_CAMPAIGNs</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">                                    where c.ID == campaignId</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">                                    select c.scriptID).First()</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">           select l;</div>

  var qry =  from l in context.TB_LANGUAGEs

             join sl in context.TB_SCRIPT_LANGUAGEs

             on l.ID equals sl.SCRIPT_LANG_ID

             where sl.SCRIPT_ID == (from c in context.TB_CAMPAIGNs

                                      where c.ID == campaignId

                                      select c.scriptID).First()

             select l;

  Better Post your code before asking a question. So that person helping u will understand u r problem Clearly
  
  Yahoo IM : dotnetruler
  
  I am trying to keep Frequently Asked Questions in my blog
  • Marked as answer by charly.p on Jul 28, 2010 07:02 AM
• • Reply
  

  charly.p

  Member

  348 Points

  305 Posts

  Re: Combine 2 linq queries.

  Jul 28, 2010 07:02 AM|LINK

  Seems that this worked very well.

  
  

  Thank you,