lakshmi sowmya

lakshmi sowmya

  • NA
  • 76
  • 102k

how to modify Inner join sql query to linq to entities.

Nov 13 2013 2:00 AM
Need to modify the below sql query to linq to entities.


SELECT  a.*, c.*
FROM bp_user a 
    INNER JOIN bp_audit_logintime c
        ON a.UserName = c.User_Name
    INNER JOIN
    (
        SELECT User_Name, MAX(Login_Time) maxDate
        FROM bp_audit_logintime
        GROUP BY User_Name
    ) b ON c.User_Name = b.User_Name AND
            c.Login_Time = b.maxDate




we got struck near Inner Join with select sub query......Please help

Answers (2)