Devart Forums

Code: Select all

public REQUEST GetRequest(int id)
        {
            var q = from r in Ctx.REQUEST
                        .Include("HISTORY")
                        .Include("REQUEST_WORKGROUP.WORKGROUP")
                        //.Include("ASSIGNMENTS.STAFF")  // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        //.Include("ASSIGNMENTS.TASKS")  // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        //.Include("COMMENTS")           // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        .Include("PROJECT")
                        .Include("WORKGROUP")
                    where r.ID == id
                    select r;

            // workaroud for Devart bug ORA-01790: expression must have same datatype as corresponding expression 
            // this will show the bad sql in x; 
            var x = ((ObjectQuery)q).ToTraceString();
            var req = q.First();
            req.COMMENTS.Load();
            req.ASSIGNMENTS.Load();
            foreach (var assignment in req.ASSIGNMENTS)
            {
                assignment.STAFFReference.Load();
                assignment.TASKS.Load();
            }
            // end of workaround

            return req;
        }