checking NULL value in where clause fails with new version of ORM

[FISCAL]

Hi,

With the latest version of Open Access [2011.1.411.2], following LINQ query fails which was working fine with the older version

LINQ query:

 int transactionCount = (from process in m_dataContext.DPFInvoiceData
                                    //where process.Processed == null || process.Processed == false //NULL condition is failing in this new version
                                    select process.DPFInvoiceDataID).ToList().Count();

Stack Trace:

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: An expression of non-boolean type specified in a context where a condition is expected, near 'THEN'. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() SQL: SELECT a.[DPFInvoiceDataID] AS COL1 FROM [DPFInvoiceData] a WHERE (CASE WHEN a.[Processed] <> 0 THEN 1 ELSE 0 END) = (CASE WHEN NULL THEN 1 ELSE 0 END) OR (CASE WHEN a.[Processed] <> 0 THEN 1 ELSE 0 END) = 0 Telerik.OpenAccess.RT.sql.SQLException: An expression of non-boolean type specified in a context where a condition is expected, near 'THEN'. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()


Could you please let me know how to resolve it?

Many thanks.

MG

[Thomas]

Hello Milan,

sorry for the inconvenience, we already fixed the issue. The upcoming 2011Q2 release will have the needed bits for that. 

All the best,
Thomas
the Telerik team