Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Help needed in SQL query conversion into LINQ
Zeeshan Azim
Feb 26 2016 2:59 AM
393
Reply
Convert this SQL query into LINQ query
where U.IsAdmin, U.IsApprover, U.IsActive, R.IsActive are of bit data type
SELECT U.ID, U.FirstName, U.LastName, U.RoleID, U.UserID, U.IsAdmin, U.IsApprover, r.RoleName RoleName FROM USERS U
INNER JOIN [ROLE] R ON U.ROLEID = R.ID AND R.IsActive = 1
WHERE UPPER(U.UserID)= @UserID AND U.Password = @Password AND U.IsActive = 1
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
how to use data bind in dropdown using linq code
How to PIVOT all rows into columns using LINQ