Convert SQL Query to LINQ RSS

• • Reply
  

  kishorejetty

  0 Points

  5 Posts

  Convert SQL Query to LINQ

  May 25, 2012 09:15 AM|LINK

  <div sizset="7" sizcache="2">

  select * from CTDFields where CategoryTypeDetailId

  in (select CategoryTypeDetailID from CategoryTypeDetail

  where DetailID=4)

  </div>
• • Reply
  

  urenjoy

  Star

  12377 Points

  1862 Posts

  Re: Convert SQL Query to LINQ

  May 25, 2012 09:42 AM|LINK

  Try following:

  var t = from item in Context.CTDFields.ToList()

             Where (from cat in Context.CategoryTypeDetail.ToList()

                         Where cat.DetailID = 4

                          Select  cat.CategoryTypeDetailID ).Contains(item.CategoryTypeDetailId)

              Select item;

  http://techbrij.com
  • Marked as answer by decker dong - msft on May 31, 2012 01:34 AM
• • Reply
  

  Bhavik Solu...

  Member

  746 Points

  159 Posts

  Re: Convert SQL Query to LINQ

  May 25, 2012 09:42 AM|LINK

  I think inner join solved your issue

  var Data1=( from CTD in db.CTDFields
              join CategoryType in db.CategoryTypeDetailID
              on  CTD.CategoryTypeDetailId equals CategoryType.CategoryTypeDetailID
               where CategoryType.DetailID==4).ToList();

  
  
  

  Bhavik Solucky | My Blog
  • Edited by Bhavik Solucky on May 25, 2012 09:43 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Convert SQL Query to LINQ

  May 27, 2012 12:15 AM|LINK

  kishorejetty

  kishorejetty

  A duplicated issue was found at：http://forums.asp.net/t/1807402.aspx