Hello

 

var query = from res in ResultSet

select new {res.RES_PERIODE,Debet=(res.RES_AMOUNT <= 0.00 ? res.RES_AMOUNT : 0.00 ),Credit=(res.RES_AMOUNT > 0.00 ? res.RES_AMOUNT : 0.00 )};

 

query.Dump();

 

Linqpad accept the syntax

 

But when it runs it throws me error that looks to be originating from the firebird driver

 

Is it possible to make case like statements with the Linq to Entity provider for Firebird

Am using firebird 2.1