LLBLGEN 3.0 January 3rd, 2011 .NET Frame work 2.0

I have been using MSORACLE in LLBLGEN Designer. I want to change the driver to ODP.NET. How can i do this ?

Also any idea where to download opp.net for .net 2.0

You can Add a new Relation Model, in the Catalog Explorer, to use the ODP.NET driver. And then you can start changing the mapping of each entity to the newly added relation model. (This can be done by editing each entity and using the Field Maping tab to create a new mapping instead of the old one). This can be tricky since you may find some fields .NET Types mimatching with the new relation model database types, since ODP.NET & MSOracle sometimes interpret numeric fields differently.

Personally I'd have created a new project from scratch. And keeping the old one as a reference.

Walaa wrote:

You can Add a new Relation Model, in the Catalog Explorer, to use the ODP.NET driver. And then you can start changing the mapping of each entity to the newly added relation model. (This can be done by editing each entity and using the Field Maping tab to create a new mapping instead of the old one). This can be tricky since you may find some fields .NET Types mimatching with the new relation model database types, since ODP.NET & MSOracle sometimes interpret numeric fields differently.

Personally I'd have created a new project from scratch. And keeping the old one as a reference.

Never mind. I can recreate the model from scratch. But where do I download ODP.NET? Because When i add ODP.NET in LLBLGEN designer, it says data provider not installed

ODP.NET Oracle site: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Walaa wrote:

ODP.NET Oracle site: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Thanks. Though not related to LLBLGEN, I have one quick question. Since MS ORACLE has some bugs on .NET 2.0,

What is best method that you would suggest to use with LLBLGEN to access ORACLE? It is pain to install Oracle clients on windows clients in order to access ORACLE

[quotenick="shekar"]

Walaa wrote:

ODP.NET Oracle site: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Thanks one last question. If I use oracle instant client, how do I use LLBLGEN ?

[quotenick="shekar"]

shekar wrote:

Walaa wrote:

ODP.NET Oracle site: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Thanks one last question. If I use oracle instant client, how do I use LLBLGEN ?

I don't understand your last question. Personally I prefer ODP.Net but I think this could be a debate, and there is a lot of comparison (pros/cons) out there.

[quotenick="daelmo"]

shekar wrote:

shekar wrote:

Walaa wrote:

ODP.NET Oracle site: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

Thanks one last question. If I use oracle instant client, how do I use LLBLGEN ?

I don't understand your last question. Personally I prefer ODP.Net but I think this could be a debate, and there is a lot of comparison (pros/cons) out there.

If I use http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html how do I connect LLBLGEN with Oracle ?

It only gives me following DLL's oci.dll ocijdbc10.dll ociw32.dll orannzsbb10.dll oraocci10.dll oraociei10.dll

Oracle Instant Client, is another slim version of the well known Oracle client. Using either of which doesn't make a difference AFAIK.

Either way you will need to use MSOracle provider or ODP.NET provider to connect using .NET code.

Walaa wrote:

Oracle Instant Client, is another slim version of the well known Oracle client. Using either of which doesn't make a difference AFAIK.

Either way you will need to use MSOracle provider or ODP.NET provider to connect using .NET code.

I have developed the app with MS ORACLE provider. Now when I install the app on client, do i need to install any oracle client OR will it just work without oracle client

You have to install either the full Oracle Client or the slim version or so called Oracle Instat Clinet.

Walaa wrote:

You have to install either the full Oracle Client or the slim version or so called Oracle Instat Clinet.

Yes thatz the catch. Instant client is only DLL's and no installation ! so you mean just add these DLL's to project and install?

Please follow the installation/deployment instructions of the Instant Client on the Oracle site.

Walaa wrote:

Please follow the installation/deployment instructions of the Instant Client on the Oracle site.

Thanks all questions answered