Devart Forums

I'm attempting to use 'LINQ to SQL' via CoreLab.Oracle;

Corelab lets me connect OK and define a LINQ DataContext.

When it gets to "GetTable" I get a CoreLab error:

"CoreLab.Oracle.OracleException: ORA-00923: FROM keyword not found where expected".....

Since I do not code the SQL (its generated by LINQ) I'm wondering if
CoreLab.Oracle actually supports "LINQ to SQL"?

Can you advise?

Thank you

John H

OraDirect .NET supports Entity Framework with LINQ to Entities,
although id does not currently integrate with LINQ to SQL due to technology limitations.

Thankyou for getting back to me so fast.
I'm now accessing the database via the method you suggested:

IEnumerable r = dataContext.ExecuteQuery(@"select id,desc_ from xxxx.my_ora_table where id = 2");

This bit works OK.
I then update the array:

foreach (MY_CLASS i in r)
i.desc_ = "xxxx";

And finally I try to update the database with the change:

dataContext.SubmitChanges();

This final update does not work.
I'm guessing I either need to use an overload on SubmitChanges
or some other method....

Can you help?

John

Please send me (alexeyman*crlab*com) a small test project to reproduce the problem.
Please include the definition of your own database objects.
Do not use third party components.

I sent the project - of course you will have to use your own table and database name in order for it to work.

I've received your project.
The investigation will take a couple of days.
I'll reply you by email.