Devart Forums

Fixed. Crap in my machine.config file.

I should also add the I have installed VS2010 final release on my machine. The services are still in VS2008 though.

I've just upgraded my machine to dotConnect for Oracle version 5.60.124. I have some services developed in VS2008 using an older version.

If I try and open my EF model I get the following error:

Unable to find the requested .Net Framework Data Provider. It may not be installed.

I also get this error if I try and run it.

Can anybody help?

It's not in my download area either and our licence is only 5 months old. We need this urgently. Can someone from Devart please respond.

Hi

Apologies for having to use the forum; my colleague sent an email to the support address some days ago but has not received a reply. Unfortunately, we are stuck and so have to post here.

I have version 5.60.102.0 installed on my machine which I used to develop some services with. Since then I have installed the final release of VS2010.

My old services written in VS2008 no longer work due to errors with dotConnect. I cannot uninstall and re-install dotConnect because it insists that it needs an older version of .NET Framework 4 installed. If I try and install this older version I cannot because I now have a newer version installed.

So, I need to download and install the latest dotConnect. We purchased a licence on the 18 Dec 2009, only 5 months ago. When we log in we are unable to download anything other than 5.35.79 (an even older version than we already have). Even this has a renew now link next to it! We have paid for a years support and yet are unable to download newer versions which we now need urgently. I cannot do any work on my services without the newer version.

Our licence no. is CRON-02365.

Please contact me as soon as possible please at [email protected].

Apologies again for using the forum but I was left with no choice.

Regards
Tony

If anybody wants to read my posts properly, then I suggest you
cut and paste them into notepad where they won't get cut off.
Cheers.

Firstly, apologies for this post being posted four times - the site kept freezing.

Secondly, unfortunately you can't read my problem properly because the site isn't displaying it properly and it will not let me edit it. Great!

Just to re-iterate. I have two services using the same model. Both services are in the same project with the model in a class library in the
same solution. When I call just one service it works fine. If I call ServiceA
followed by ServiceB or the other way around then the second service always fails with:

The 'Devart.Data.Oracle.OracleProviderFactory' provider from the specified SSDL artifact(s) does not match the expected 'Devart.Data.Oracle' provider from the connection string

They are both using exactly the same connection string. This seems
like a bug to me. Any ideas?

Hi all

Pulling my hair out with a very strange problem and have now got to the point where I don't know what else to try.

I have two WCF services. They are both contained in the same project in the same solution. They both use the same EF model which is in a separate class library in the same solution.

When call Service A multiple times it works perfectly. When I call Service B multiple times it works fine. If I call Service A and then call Service B then the call to Service B fails with the error shown below. If I call Service B and then call Service A then same error. In other words, the first call always works (and subsequent calls to the same service), but as soon as I call another service I get the error. Weird!

The error:

System.InvalidOperationException: The 'Devart.Data.Oracle.OracleProviderFactory' provider from the specified SSDL artifact(s) does not match the expected 'Devart.Data.Oracle' provider from the connection string.
at System.Data.EntityClient.EntityConnection.ValidateThatConnectionAndMetadataProvidersAreEqual(DbProviderFactory connectionFactory, String connectionProviderName, DbProviderFactory metadataFactory)
at System.Data.EntityClient.EntityConnection.LoadStoreItemCollections(MetadataWorkspace workspace, DbConnection storeConnection, DbProviderFactory factory, DbConnectionOptions connectionOptions, EdmItemCollection edmItemCollection, MetadataArtifactLoader artifactLoader)
at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)
at System.Data.EntityClient.EntityConnection.InitializeMetadata(DbConnection newConnection, DbConnection originalConnection, Boolean closeOriginalConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at BSkyB.com.BSS.Model.Traffic.Conn.Get(String serviceID, Boolean open, ConnOverride connOverride, ILog log) in C:\Dev\BSkyB.com.BSS\BSkyB.com.BSS.Model\BSkyB.com.BSS.Model.Traffic\Conn.cs:line 59
at BSkyB.com.BSS.WCF.Traffic.Material.GetEx(List`1 materialID, List`1 versionID, List`1 mediaID, Boolean includeInactive, ConnOverride connOverride) in C:\Dev\BSkyB.com.BSS\BSkyB.com.BSS.WCF\BSkyB.com.BSS.WCF.Traffic\Material.svc.cs:line 192

The connection strings:




Note that each service has its own connection string. I have made them both identical to see if that was causing problems but it wasn't. I have also tried the default res://*/ but it made no difference. Have also tried loading the metadata manually which works but I still get the same error.

Anybody got any ideas? Both services use exactly the same model and work flawlessly unless you call them after calling the other. Both services dispose the connection as well.

willfer wrote:Does dotConnect for oracle supports Sequences in the Entity Framework? How can a SEQ.NEXT_VAL o SEQ.CURRENT_VAL be inserted into a new record?

I've just had this exact same issue. I spent two days trying to find out if it can be done - and the conclusion I came to was basically, not really. Apparently you can do it if you edit your model in Devart's Entity Developer. However, their Entity Developer fell over just trying to open my model so I didn't bother with it.

In the end, the simplest solution for me was to simply create a new connection and call a stored proc that returned the next val. Both connections (the stored proc one and the EF one) were both under the same TransactionScope so it's very easy to enlist them in the same transaction.

I wasted a lot of time following useless examples that don't work on the web. Not worth the bother, the next release of EF will fix this anyway.

Managed to sort it out by bypassing EF. Just not worth the bother of trying to get EF to do such simple things, I'll wait until the next release and then try again.

I'm opening a seperate connection to get my sequence number and wrapping this connection and my EF connection in a transactionscope so they both participate in the same transaction.

Have to say, EF is pretty sucky and MS need to get their act together fast or people will drop it.

Hi AndreyR

Thanks for your reply, much appreciated. Unfortunately, I'm still not much clearer. I can change the view for a stored proc or a function but I'm still not clear how to actually map it. The stored proc would take one input parameter, the name of the sequence and return the next value (int64).

I'm not clear what you mean when you refer to inserted primary key etc. I don't have a primary key, I just want to get a sequence which has nothing to do with any table. Is this possible?

Thanks for your help.

CREATE OR REPLACE VIEW get_next_tapetp_seq
AS
SELECT
CAST(get_sequence_nextval('tapetp_seq') AS NUMBER(9)) AS nextval
FROM
dual

Hi All

Pulling my hair out today. I need to retrieve a sequence from Oracle via Entity Framework. Giving up with stored procs/functions as it seems almost impossible to do this remarkably simple thing.

I'm now trying to do this with a view. I have a view which calls a function which returns the nextval from a sequence.

The view shows up when I do 'Update from database' under Views. I select the view and click finish - and absolutely nothing happens. No errors, nothing, the view simply isn't there in the model.

Can anybody help please? This is getting pretty urgent as I've spent an entire day simply trying to get a sequence nextval. Crazy or what man!

Cheers dudes.