LinqToXpo - Translate nested CASE statements into several WHEN statements when the maximum limit (10) is exceeded

Hello,

I have a L INQ to Sql statement that is run against several joined tables, with one "MajorTable", which has links to all other. Problem is that if in select statement I have nested conditions, they are translated to nested case statements. Since CASE statements are nested I hit a limit of maximum of 10  nested CASE statements. Solution would be to translate it to one CASE statement with several WHEN statements.

Explanation:
Statement looks like:

C#
var myDataJoined = MajorTable  
    .Join(new XPQuery<Table1>(session),  
         link => link.ToId,  
         Table1Rec => Table1Rec.Oid,  
         (link, Table1Rec) => new { Table1Rec = Table1Rec, link = link })  
    .Join(new XPQuery<Table2>(session),  
         link => link.link.ToId,  
         Table2Rec => Table2Rec.Oid,  
         (link, Table2Rec) => new { Table2Rec = Table2Rec, Table1Rec = link.Table1Rec, link = link.link })  
    .Join(new XPQuery<Table3>(session),  
         link => link.link.ToId,  
         Table3Rec => Table3Rec.Oid,  
         (link, Table3Rec) => new { Table3Rec = Table3Rec, Table2Rec = link.Table2Rec, Table1Rec = link.Table1Rec, link = link.link })  
    .Join(new XPQuery<Table4>(session),  
         link => link.link.ToId,  
         Table4Rec => Table4Rec.Oid,  
         (link, Table4Rec) => new { Table4Rec = Table4Rec, Table3Rec = link.Table3Rec, Table2Rec = link.Table2Rec, Table1Rec = link.Table1Rec, link = link.link });  

var resultingData = linksJoined.Select(entity => new MyRow()  
{  
    Oid = entity.Table1Rec != null ? entity.Table1Rec.Oid : (entity.Table2Rec != null ? entity.Table2Rec.Oid : (entity.Table3Rec != null ? entity.Table3Rec.Oid : (entity.Table4Rec != null ? entity.Table4Rec.Oid : (Guid.Empty)))),  
    SomeData = entity.Table1Rec != null ? entity.Table1Rec.Col1 : (entity.Table2Rec != null ? entity.Table2Rec.LastName : (entity.Table3Rec != null ? entity.Table3Rec.SomeCol : (entity.Table4Rec != null ? "FixedText" : ("NO DATA")))),  
});  

This query is translated to SQL which looks like:

C#
select  
case when not (N1.OID is null) then N1.OID  
else case when not (N2.OID is null) then N2.OID  
else case when not (N3.OID is null) then N3.OID  
else case when not (N4.OID is null) then N4.OID  
else '00000000-0000-0000-0000-000000000000' end end end end,  

case when not (N1.OID is null) then N1.Col1  
else case when not (N2.OID is null) then N2.LastName  
else case when not (N3.OID is null) then N3.SomeCol  
else case when not (N4.OID is null) then N'Fixed text'  
else N'NO DATA' end end end end  
...  

Instead it should be translated to:

C#
select  
case when not (N1.OID is null) then N1.OID  
 when not (N2.OID is null) then N2.OID  
 when not (N3.OID is null) then N3.OID  
 when not (N4.OID is null) then N4.OID  
else '00000000-0000-0000-0000-000000000000' end,  

case when not (N1.OID is null) then N1.Col1  
 when not (N2.OID is null) then N2.LastName  
 when not (N3.OID is null) then N3.SomeCol  
 when not (N4.OID is null) then N'Fixed text'  
else N'NO DATA' end  
...  

As it is clear, this statement can run even if there are more when statements.

Thank you.