StrataFrame Forum » .NET Forums » General .NET Discussion » Long-term Oracle Support?

Long-term Oracle Support?

Kirk M Sherhart — Mon, 12 Jul 2010 12:43:46 GMT

Since Microsoft has said that System.Data.OracleClient will be deprecated in .NET 4.0, what are MicroFour's plans for continued support of Oracle db's?

RE: Long-term Oracle Support?

Greg McGuffey — Mon, 12 Jul 2010 12:43:46 GMT

Well, we have to work out what a solution might be, because Microsoft isn't supporting Oracle anymore. I.e. while they do have a .NET 4.0 Oracle driver, it is depreciated so we are investigating what might be a good approach going forward. This fall we'll be looking at this in more detail.

RE: Long-term Oracle Support?

lastcanary — Mon, 12 Jul 2010 09:00:56 GMT

Thank you for your support.

This doesnt look to be a permanent solution. Are you developing a new solution for .NET 4.0?

RE: Long-term Oracle Support?

Greg McGuffey — Tue, 06 Jul 2010 15:45:32 GMT

I realized that the problem might be that you are referencing the .NET 4.0 version of System.Data.OracleClient, but you need to reference the .NET 2.0 version for SF to work. It won't show up on the .NET tab of the Add References dialog if your project is a .NET 4.0 project (it only shows the .NET 4.0 assemblies). You'll have to user the Browse tab to reference the .NET 2.0 version, then the SF stuff should work. The System.Data.OracleClient.Dll is typically located:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Let us know if this gets your problem solved.

RE: Long-term Oracle Support?

Greg McGuffey — Tue, 06 Jul 2010 13:38:24 GMT

Did you add a reference to the System.Data.OracleClient.dll?

RE: Long-term Oracle Support?

lastcanary — Mon, 05 Jul 2010 02:51:30 GMT

Hello,

We are using Visual Studio 2010 and Oracle 11g.

After creating a table I used Business Object Mapper and built the BO. It was built with no errors.

When I tried to build the project I received the following error:

Error 1 The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) E:\DENEME\OracleTest05072010\OracleTest05072010\deneme1.Designer.cs 360 65 OracleTest05072010

I dont know how to solve this error.

Does Strataframe supports VS2010 with Oracle 11g?

Could you please help us?

RE: Long-term Oracle Support?

Trent L. Taylor — Tue, 04 May 2010 14:09:39 GMT

We will take the same approach as we did with other 3rd party databases such as DB2. We will provide a factory entry to allow SF users to choose which managed .NET Oracle client that they want to use. We have not 100% decided yet, but we will most likely provide a "standard" or "preferred" Oracle client. At present we are leaning towards using Oracle's client since they are most likely not going to go away or deprecate their client. :)