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
Marjorie Fiallos
NA
10
2.4k
How to convert sql to linq using C#
Jan 16 2017 3:21 PM
Hi , please Can someone help me ?
I have a sql query which I need to convert in LINQ
SELECT '1' REG FROM a WHERE tipo LIKE 'DEPOSITO%' AND id IN (SELECT secuencia FROM b WHERE formulario = 'D1526' AND num = ' 123456789 ')
UNION ALL
SELECT '1' REG FROM a WHERE tipo LIKE 'DEPOSITO%' AND id IN(SELECT secuencia FROM b WHERE formulario_padre = 'D1526')
UNION ALL
SELECT '1' REG FROM c WHERE uti<>0 AND formulario='D1526';
Reply
Answers (
2
)
How to use parameter array navigation properties EF linq ?
Why the result is returning only 1 column instead 2 column?