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.
Gettting "Missing parenthesis" Error with devart 8.4.389 on 11g Oracle
-
- Posts: 1
- Joined: Mon 03 Dec 2018 14:30
Re: Gettting "Missing parenthesis" Error with devart 8.4.389 on 11g Oracle
This query works in our environment with Oracle v11.2 and dotConnect for Oracle v9.6.646. Please upgrade.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();