Devart Forums

Thank you for the timely response. I was able to download the 6.x version and it seems to work OK with VS2010 SP1.

I emailed the requested info back to your sales guys. Please expedite if possible.

Thanks, is there anything I can do to expedite things? I really need to get this going because of a very tight deadline.

Thanks, Shalex.

when I login with the user provided by you (dcoracle560pro) I can only download v. 5.70.190.0. Note the my license is not up for renewal quite yet (July). Is there a place I can download v. 6.x?

My VS version is 10.0.40219.1 SP1Rel

Hello -

I am using dotConnect for Oracle v. 5.70.190.0 over EF. Recently I tried to add another table to my model (by running the "Update from database" wizard in VS) and got the following exception:

-------
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Can't found Project
'.

-----------------

Could you please let me know how to address this issue?

G.

Thanks Andrey!

I have sent a sample solution to [email protected] that clearly illustrates the issue. Please review and advise.

G.

Thanks Andrey!

I am not sure when you did send the email but I have not received anything yet. Could you please resend?

Here is my scenario:

I have built a WCF Data (oData) service that is using dotConnect for Ora provider, version 5.70.190.0. When I execute a query to a single entity, selecting up to 8 properties, all is well. However, if I add just one more property/column to the list of selects I get the following exception (the type of the newly added property does not seem to make any difference) :

ArgumentNullException: Value cannot be null.Parameter name: value

and here is the stack trace:

at System.Data.Services.WebUtil.CheckArgumentNull[T](T value, String parameterName)
at System.Data.Services.Internal.ProjectedWrapper.set_PropertyNameList(String value)
at lambda_method(Closure , Shaper )
at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Data.Services.Internal.ProjectedWrapper.EnumeratorWrapper.MoveNext()
at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService)
at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)
at System.Data.Services.DataService`1.HandleRequest()

I saw forums that mention similar problems, but it was recommended that the users upgrade and I am already using the latest version of the dotConnect for Ora.

Does anyone have any idea where I need to look at?
Is this a known issue?

It appears that the length of the URL is in play here - if I have it under around 180 characters it works, if it is higher than that, not so much.

Many thanks in advance, G.

Hi - could you please post the actual solution? I am having a very similar problem:

if I use up to a particular number of properties when new-ing up the object, it is all well. However, if I add one more to the list, I get the mentioned exception. Was this resolved ?

Any help is greatly appreciated. G.

Thanks Stan!

Hi guys - I need to move my dev license to a new machine. My questions is : what are the steps to accomplish this? Do I simply install it on the new machine and un-install it from the old one?

Many thanks in advance. G.

Hi all -
I have a very simple case: two entities with 1-to-many relationship (e.g. one company-to-many-employees).
Case1 (works ok): I use Linq2Entities over the compiled DLL containing the model and using the ".Include" syntax I eagerly load the related entities (Employee) just fine.
Case2 (does not work): I expose the model via WCF data service. When I try to eagerly load the related entity on the client (via the ".Expand" method) I get the "OUTER APPLY is not supported by Oracle" exception.

Note - this problem does not occur when the relationship b/w entities is 1-to-1.

Can anyone please shed some light on this for me? Is there a known work-around?

G.

Here is my situation:

I am using EF4.0 with dotConnect to Oracle and have a simple star schema model. The model is exposed via Wcf Data Service (oData).

I can successfully browse my entities via the web browser. I can find a single entity that I am interested in and using the generated link traverse all related entities.

However, If I create a separate project (say WPF) and attempt to use Linq syntax, I get a NotSupported exception if using the Entity.Expand("RelatedEntity") notation. If I opt for the LoadProperty Method things seem to work.

Can anyone address this issue please?