lakshmi sowmya

lakshmi sowmya

  • NA
  • 76
  • 100.7k

How to modify the Inner Join sql query to Linq to entities.

Nov 13 2013 1:21 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 (1)