Devart Forums

Hi,

We are using devart 8.4.389.0 version with EF 6.1. But using FirstOrDefault()/First() is throwing Missing parenthesis error.


Query 1: (Throws error with 11g but works fine on 12c Oracle)
var temp= (from tbl1 in context.TableOne
join tbl2 in context.TableTwo
on tbl1.ID equals tbl2.ID
where tbl1.ID == 1234

select new
{
name= tbl1.name
age= tbl2.age
}).FirstOrDefault();

Query 2: (Works fine on both but then again with this change we got lots of changes in the existing code)
var temp= (from tbl1 in context.TableOne
join tbl2 in context.TableTwo
on tbl1.ID equals tbl2.ID
where tbl1.ID == 1234

select new
{
name= tbl1.name
age= tbl2.age
}).ToList().FirstOrDefault();


Can you help what is wrong here, because the same code was working earlier for both DB.

FYI : We recently installed the devart latest trial version i.e. 9.6 and then reinstalled devart 8.4.389 licensed.

sumit.bhardwaj wrote: ↑Tue 04 Dec 2018 00:05Query 1: (Throws error with 11g but works fine on 12c Oracle)
var temp= (from tbl1 in context.TableOne
join tbl2 in context.TableTwo
on tbl1.ID equals tbl2.ID
where tbl1.ID == 1234

select new
{
name= tbl1.name
age= tbl2.age
}).FirstOrDefault();

This query works in our environment with Oracle v11.2 and dotConnect for Oracle v9.6.646. Please upgrade.