TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
2
)
LINQ value.contains function error
Linq Query was Not Allowing singleQuotes