More in this section

Forums / General Discussions / how do i write sql query into linq

how do i write sql query into linq

2 posts, 0 answered
  1. kd
    kd avatar
    2 posts
    Registered:
    19 Dec 2011
    08 Feb 2012
    Link to this post
    Hi all,
    i am facing problem doing group on table how can i write this sql query into linq c#

    select
    UserProfile.ID,
    UserProfile.FirstName+' '+UserProfile.LastName UserName,
    IsNull(CurrentBid.[Current],0)CurrentBid,
    IsNull(WinnerBid.Winner,0)WinnerBid,
    IsNull(LoseBid.Lose,0)LoseBid,
    IsNull(CancelledBid.Cancel,0)CancelledBid
    from UserProfile
    left join
    (
    select count(BidTransactions.ID) [Current],UserID
    from BidTransactions where
    IsCloseBid= null or IsCloseBid = 0
    group by UserID)CurrentBid on CurrentBid.UserID = UserProfile.ID
    left Join (
    select count(BidTransactions.ID) [Winner] ,UserID
    from BidTransactions where
    IsCloseBid= 1 AND IsWinnerBid = 1
    group by UserID)WinnerBid on WinnerBid.UserID = CurrentBid.UserID
    left Join(
    select count(BidTransactions.ID) [Lose],UserID
    from BidTransactions where
    IsCloseBid= 1 AND IsWinnerBid = 0
    group by UserID)LoseBid on LoseBid.UserID = CurrentBid.UserID
    left join(
    select count(BidTransactions.ID) [Cancel],UserID
    from BidTransactions where
    IsCancelled = 1
    group by UserID) CancelledBid on CancelledBid.UserID = CurrentBid.UserID
    where UserProfile.RoleName in ('Sellers','Bidders')
  2. Stanislav Velikov
    Stanislav Velikov avatar
    1113 posts
    Registered:
    18 Sep 2017
    10 Feb 2012
    Link to this post
    Hi,

     For an introduction to Linq to SQL refer to http://msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic3 .

    In Sitefinity directly executing queries to the database will not produce the desired results. For the purpose refer to Sitefinity API which is built in the manner of Linq to SQL. Here is a link to Users Api.

    Regards,
    Stanislav Velikov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered