Devart Forums

MartinJJ

Hi,

My trial has runout. I had attempted to uninstall and experienced a crash in some .tmp exe. dbConnect looks like great product support for LINQ and Oracle coming along.

I now have a corrupted UI for VS and options that crash it. Hints on how would i go about getting back to clean system.

Regards

Martin

MartinJJ

Hi,

Ok thanks. I have prepared a sample that shows the issue I'm seeing.

i will send to the support address LINQ: Empty Type again.

Regards

Martin

MartinJJ

Thanks for the reply.

Unicode=true? Where do i refs to these so i dont bother you. Anyway I tried it. No it didn't work. I'm hoping you mean the connection string in the config the model generation creates.

So the linq query extract from above

Code: Select all

select Util.MakePair(grp.GRD_GROUP, new GroupDefData(label == null ? String.Empty : label.LBL_TEXT))

emits as

Code: Select all

WHEN (t2.LBL_LABEL IS NULL) AND (t2.LBL_LANG IS NULL) THEN :p1
        ELSE t2.LBL_TEXT

:p1 being String.Empty I'd say.

:p0 (the other parameter in the call) is the language string passed into the function used here

Code: Select all

new { LABEL = grp.GRD_NAME_LBL, LANGUAGE = language }

and emits here

Code: Select all

(:p0 = t2.LBL_LANG)

when you look at the ORA-12704 error within dbMonitor and look at the Parameters tab you see 'varchar' not 'nvarchar' inputs used to pass in what should be nvarchar types and then hence the error reported by oracle.

MartinJJ

Thanks very much for the reply. I await your (cant happen fast enough) reply and fix.

MartinJJ

Hi

Cmon, there must be some experiance of it Devart land. How do i support multi char from LINQ. Either I'm doing something stupid or incorrect but i have poured over the docs as best I can. I cant see anything thats going to give me abiltiy to control what is emitted to get passed this.

MartinJJ

I found Devart...TypedNulls in the end. Its a little buried as to its usage in the docs

But still no good either way true or false for me. Varchar only inputs in sql to oracle. Seems enough people have had the issue but generally worked out. Though I'm using LINQ query and trying to maintain the portability here. Which i'm hoping is a goal for the product. So as far as I know things like

TOraSql.Params.AsWideString and Net Mode ?? are not practical solutions for me. I can't see in CRM sample app example of consideration of 2 byte and nvarchar2 and linq and translation of parameter type conversion.

MartinJJ

dbMontior shows the inputs as varchar ???? so thats the problem. The data type is not being detected

MartinJJ

Hi,

With regard to the NVARCHAR2 cols and the SQL statement. To get this to work N'' ie: N'en' to cast to 2 byte. Is dbConnect Oracle going to do that for me or is there a setting to support? Or is it a bug?

Regards

Martin

MartinJJ

Hi

When I run query :

Code: Select all

groups_query = Devart.Data.Linq.CompiledQuery.Compile(
                (GAORCL2.GAORCL2 ga, string language) =>
                    from grp in ga.GroupDefs
                    join label in ga.Labels on
                        new { LABEL = grp.GRD_NAME_LBL, LANGUAGE = language } equals
                        new { LABEL = label.LBL_LABEL, LANGUAGE = label.LBL_LANG } into labels
                    from label in labels.DefaultIfEmpty()
                    select Util.MakePair(grp.GRD_GROUP, new GroupDefData(label == null ? String.Empty : label.LBL_TEXT))
            );

sql looks like this :

Code: Select all

SELECT t1.GRD_GROUP, 
    (CASE 
        WHEN (t2.LBL_LABEL IS NULL) AND (t2.LBL_LANG IS NULL) THEN :p1
        ELSE t2.LBL_TEXT
     END) AS C1
FROM GRADS3_USER.GROUP_DEFS t1
LEFT OUTER JOIN GRADS3_USER.LABELS t2 ON ((t1.GRD_NAME_LBL = t2.LBL_LABEL) OR ((t1.GRD_NAME_LBL IS NULL) AND (t2.LBL_LABEL IS NULL))) AND (:p0 = t2.LBL_LANG)

and if I place this sql in sqlplus with 'sometext' replacing :p1 and :p0 I get the same error. ORA-12704. The charset mismatch. There is much talk about resolving this with TypedNulls set to True. Though this attribute seems to be not available to me with the trial version. Is it old way? Is there another to resolve it now? Or do i have bad setup with db?

SQL> desc labels;
Name Null? Type
----------------------------------------- -------- -----------------

LBL_LABEL NOT NULL NVARCHAR2(32)
LBL_LANG NOT NULL NVARCHAR2(2)
LBL_TEXT NOT NULL NVARCHAR2(2000)

SQL> desc group_defs;
Name Null? Type
----------------------------------------- -------- --------------

GRD_GROUP NOT NULL NUMBER(38)
GRD_NAME_LBL NOT NULL NVARCHAR2(32)

SQL> select * from nls_database_parameters;

PARAMETER VALUE
------------------------------ -------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
------------------------------ -------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0

20 rows selected.

MartinJJ

Hi,

Syntax wise there is nothing wrong.

What I really need to know is if this product will handle this if there is not a practical workaround.

The query as it stands work fine with sqlserver though this error is raised. Is there anyone from devart able to comment please. As i mentioned a guranteed sale if we get this working.

Martin

MartinJJ

Hi,

I am attempting to port an existing app that makes use of Linq and Sqlserver. I need to port this to Oracle. I have made a few attempts at getting this to work.

The following error comes from a compiledquery. I would really appreciate any thoughts you might have on what is not working here and whether there is any prospect of it doing so.

Is there any sytax not supported here or something?

Regards

Martin

{"Cannot use \"\" type value in \"Decimal\" type argument"}

The LambdaExression:

Code: Select all

{ga => ga.Groups.Join(ga.Groups.GroupBy(g => new f__AnonymousType0`2(GRP_GROUP = g.GRP_GROUP, GRP_SPEC = g.GRP_SPEC), g => g.GRP_INH_DEPTH).Select(t => new f__AnonymousType1`3(GRP_GROUP = t.Key.GRP_GROUP, GRP_SPEC = t.Key.GRP_SPEC, MAX_DEPTH = t.Max())), grp => new f__AnonymousType0`2(GRP_GROUP = grp.GRP_GROUP, GRP_SPEC = grp.GRP_SPEC), g => new f__AnonymousType0`2(GRP_GROUP = g.GRP_GROUP, GRP_SPEC = g.GRP_SPEC), (grp, g) => new f__AnonymousType2`2(grp = grp, g = g)).Where(h__TransparentIdentifier0 => ((h__TransparentIdentifier0.grp.GRP_INH_DEPTH = 0) || (h__TransparentIdentifier0.grp.GRP_INH_DEPTH = 1))).GroupBy(h__TransparentIdentifier0 => new f__AnonymousType1`3(GRP_GROUP = h__TransparentIdentifier0.grp.GRP_GROUP, GRP_SPEC = h__TransparentIdentifier0.grp.GRP_SPEC, MAX_DEPTH = h__TransparentIdentifier0.g.MAX_DEPTH), h__TransparentIdentifier0 => (h__TransparentIdentifier0.grp.GRP_INH_DEPTH * h__TransparentIdentifier0.grp.GRP_ANCESTOR)).OrderBy(t => t.Key.GRP_GROUP).ThenBy(t => t.Key.MAX_DEPTH).Select(t => new InheritanceTriplet(t.Key.GRP_GROUP, t.Key.GRP_SPEC, t.Max()))}

The Query:

Code: Select all

inheritance_query = Devart.Data.Linq.CompiledQuery.Compile(
                (GAORCL2.GAORCL2 ga) =>
                    from grp in ga.Groups
                    join g in
                        (
                            from g in ga.Groups
                            group g.GRP_INH_DEPTH by new { g.GRP_GROUP, g.GRP_SPEC } into t
                            select new { t.Key.GRP_GROUP, t.Key.GRP_SPEC, MAX_DEPTH = t.Max() }
                            ) on new { grp.GRP_GROUP, grp.GRP_SPEC } equals
                         new { g.GRP_GROUP, g.GRP_SPEC }
                    where grp.GRP_INH_DEPTH == 0 || grp.GRP_INH_DEPTH == 1
                    group grp.GRP_INH_DEPTH * grp.GRP_ANCESTOR by
                        new { grp.GRP_GROUP, grp.GRP_SPEC, g.MAX_DEPTH }
                        into t
                        orderby t.Key.GRP_GROUP, t.Key.MAX_DEPTH
                        select new InheritanceTriplet(t.Key.GRP_GROUP, t.Key.GRP_SPEC, t.Max())
            );

The Stack Trace:

at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.CheckConversionToParameterType(SqlExpression argumentValue, Type parameterType)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ac A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.g(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.d(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ad A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ad A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(bb A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(bb A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(am A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.DataProvider.a(e A_0, Type A_1, SqlNode A_2, IList`1 A_3)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
at Devart.Data.Linq.CompiledQuery.a(b A_0)
at Devart.Data.Linq.CompiledQuery.a(DataContext A_0, Object[] A_1)
at Devart.Data.Linq.CompiledQuery.Invoke[a,b](a A_0)
at Grads.Groups_ORCL.list(GAORCL2 ga) in D:\Martin\devart\devartTest\devartTest\Groups_ORCL.cs:line 65
at devartTest.Program.Main(String[] args) in D:\Martin\devart\devartTest\devartTest\Program.cs:line 31
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

MartinJJ

Hi,

Another issue. What is type \"\" !!!!

at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.CheckConversionToParameterType(SqlExpression argumentValue, Type parameterType)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ac A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.g(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.d(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ad A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ad A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(bb A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(bb A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(am A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.DataProvider.a(e A_0, Type A_1, SqlNode A_2, IList`1 A_3)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
at Devart.Data.Linq.CompiledQuery.a(b A_0)
at Devart.Data.Linq.CompiledQuery.a(DataContext A_0, Object[] A_1)
at Devart.Data.Linq.CompiledQuery.Invoke[a,b](a A_0)
at Grads.Groups_ORCL.list(GA_ORCL ga) in D:\GA-Project\GA\Grads\Handlers\Groups_ORCL.cs:line 62
at Grads.RestHandler_ORCL.InvokeGet(String method) in D:\GA-Project\GA\Grads\RestHandler_ORCL.cs:line 141
at Grads.GA.getAll(String what) in D:\GA-Project\GA\Grads\GA.svc.cs:line 32
at SyncInvokegetAll(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

comes from

Code: Select all

inheritance_query = Devart.Data.Linq.CompiledQuery.Compile(
                (Grads3.GA_ORCL ga) =>
                    from grp in ga.Groups
                    join g in
                        (
                            from g in ga.Groups
                            group g.GRP_INH_DEPTH by new { g.GRP_GROUP, g.GRP_SPEC } into t
                            select new { t.Key.GRP_GROUP, t.Key.GRP_SPEC, MAX_DEPTH = t.Max() }
                            ) on new { grp.GRP_GROUP, grp.GRP_SPEC } equals
                         new { g.GRP_GROUP, g.GRP_SPEC }
                    where grp.GRP_INH_DEPTH == 0 || grp.GRP_INH_DEPTH == 1
                    group grp.GRP_INH_DEPTH * grp.GRP_ANCESTOR by
                        new { grp.GRP_GROUP, grp.GRP_SPEC, g.MAX_DEPTH }
                        into t
                        orderby t.Key.GRP_GROUP, t.Key.MAX_DEPTH
                        select new InheritanceTriplet((uint)t.Key.GRP_GROUP, (uint)t.Key.GRP_SPEC, (uint)t.Max())
            );

MartinJJ

Hi

Also I

"Cannot use \"\" type value in \"UInt32\" type argument"

get from

Code: Select all

inheritance_query = Devart.Data.Linq.CompiledQuery.Compile(
                (Grads3.GA_ORCL ga) =>
                    from grp in ga.Groups
                    join g in
                        (
                            from g in ga.Groups
                            group g.GRP_INH_DEPTH by new { g.GRP_GROUP, g.GRP_SPEC } into t
                            select new { t.Key.GRP_GROUP, t.Key.GRP_SPEC, MAX_DEPTH = t.Max() }
                            ) on new { grp.GRP_GROUP, grp.GRP_SPEC } equals
                         new { g.GRP_GROUP, g.GRP_SPEC }
                    where grp.GRP_INH_DEPTH == 0 || grp.GRP_INH_DEPTH == 1
                    group grp.GRP_INH_DEPTH * grp.GRP_ANCESTOR by
                        new { grp.GRP_GROUP, grp.GRP_SPEC, g.MAX_DEPTH }
                        into t
                        orderby t.Key.GRP_GROUP, t.Key.MAX_DEPTH
                        select new InheritanceTriplet((uint)t.Key.GRP_GROUP, (uint)t.Key.GRP_SPEC, (uint)t.Max())
            );

gives this. I welcome any thoughts at all.

at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.CheckConversionToParameterType(SqlExpression argumentValue, Type parameterType)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ac A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ac A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.g(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.d(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ak A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(ad A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(ad A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(bb A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(bb A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(am A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.e(x A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.DataProvider.a(e A_0, Type A_1, SqlNode A_2, IList`1 A_3)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
at Devart.Data.Linq.CompiledQuery.a(b A_0)
at Devart.Data.Linq.CompiledQuery.a(DataContext A_0, Object[] A_1)
at Devart.Data.Linq.CompiledQuery.Invoke[a,b](a A_0)
at Grads.Groups_ORCL.list(GA_ORCL ga) in D:\GA-Project\GA\Grads\Handlers\Groups_ORCL.cs:line 62
at Grads.RestHandler_ORCL.InvokeGet(String method) in D:\GA-Project\GA\Grads\RestHandler_ORCL.cs:line 130
at Grads.GA.getAll(String what) in D:\GA-Project\GA\Grads\GA.svc.cs:line 32
at SyncInvokegetAll(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

MartinJJ

Hi

I'm just evaluating dbConnect for Oracle with '11g client' 10.2.0.1 server for port of project from sqlserver to oracle. A sale for sure if it all works

Is there an equivilant/alternative approach for this type of thing. I have other

CompiledQuery

.

But I'm stuck with a

InvalidOperationException "Could not format node 'Nop' for execution as SQL."

Code: Select all

private static Func
            version_query = Devart.Data.Linq.CompiledQuery.Compile(
                (Grads3.GA_ORCL ga) =>
                    (UInt32)(
                        from spec in ga.Specifications.DefaultIfEmpty()
                        select spec == null ? 0 : (Int32)spec.SPC_VERSION
                     ).Sum()
            );

at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(am A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(k A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(x A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(al A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(al A_0)
at Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.SqlFormatter.a(SqlNode A_0, CommandType& A_1)
at Devart.Data.Linq.Provider.DataProvider.a(e A_0, Type A_1, SqlNode A_2, IList`1 A_3)
at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
at Devart.Data.Linq.CompiledQuery.a(b A_0)
at Devart.Data.Linq.CompiledQuery.a(DataContext A_0, Object[] A_1)
at Devart.Data.Linq.CompiledQuery.Invoke[a,b](a A_0)
at Grads.Specs_ORCL.list(GA_ORCL ga) in D:\Martin\devart\devartTest\devartTest\Specs_ORCL.cs:line 43
at devartTest.Program.Main(String[] args) in D:\Martin\devart\devartTest\devartTest\Program.cs:line 30
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Code: Select all
```
[/list]
```
So DefaultIfEmpty() was the issue here.

Devart Forums

Search found 14 matches

Trial uninstaller crashed and leaves corrupted VS.

Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls

InvalidOperationException / NotSupportedException

"Cannot use \"\" type value in \"UInt32\" type argument"

InvalidOperationException