Object Query & Entity SQL Query RRS feed

  • Question

  • Can anybody temme the ObjectQuery  & ESQL Query for the Below Query :

    SELECT S.*,M.*
    FROM EF.dbo.tbl_Student as S, EF.dbo.tbl_Mentor as M
    WHERE S.StudentId = M.StudentId
    AND S.StudentId = 007

    I will be very grateful !!!

    Please Help...

    Friday, October 7, 2011 9:17 AM


  • Hi Link,


    Var test=from s in EF.Students from m in EF.Mentor where s.StudentId==m.StudentId&& s.StudentId==007 select new {v,p};

    Have a nice day.

    Alan Chen[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, October 10, 2011 7:29 AM

All replies