Mike_Mozhaev
asked on
Is it possible to use derived tables in LINQ 2 SQL?
Is it possible to get something like the following in LINQ 2 SQL?
SELECT e.A, d.B
FROM
(
SELECT * FROM Event
WHERE ID BETWEEN 1 AND 21
) e
LEFT OUTER JOIN EventDetail d ON e.ID = d.EventID
SELECT e.A, d.B
FROM
(
SELECT * FROM Event
WHERE ID BETWEEN 1 AND 21
) e
LEFT OUTER JOIN EventDetail d ON e.ID = d.EventID
ASKER
Thanks, that will work.
But I'm looking for way to express it in LINQ without any SQL since this way I have strong typing.
But I'm looking for way to express it in LINQ without any SQL since this way I have strong typing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works, though without derived table. But I haven't found any other way so I'll use this approach.
Thanks
Thanks
CREATE VIEW MY_VIEW AS
SELECT e.A, d.B
FROM
(
SELECT * FROM Event
WHERE ID BETWEEN 1 AND 21
) e
LEFT OUTER JOIN EventDetail d ON e.ID = d.EventID
Then go to linq and simply run SELECT * FROM MY_VIEW.
Cool stuff.