2
Reply

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

lakshmi sowmya

lakshmi sowmya

Nov 13 2013 2:00 AM
957
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)