Hi, I am developing a billing software for an MNC. The application is developed in VB.NET with the back end database being Oracle 10g (Enterprise or Express Edition). My question is, which Data Adapter can be used to develop the application. Can I use OLE DB or ODP.NET (Oracle Data Access Provider for .NET)? Which shall be preferred?

Note that this application will be installed in many sites and connected to a central database via internet.

Please Help me. Also if possible try explaining me the difference.

Thank You

terenkleo wrote:

Hi, I am developing a billing software for an MNC. The application is developed in VB.NET with the back end database being Oracle 10g (Enterprise or Express Edition). My question is, which Data Adapter can be used to develop the application. Can I use OLE DB or ODP.NET (Oracle Data Access Provider for .NET)? Which shall be preferred?

LLBLGen supports both ODP and MSOracle (See the docs..).

Which is preferred? That's up to you. Personally I prefer ODP.Net for some reasons, but there ar a lot of people using MSOracle, so it's up to you, maybe you can find some post out there about ODP vs. OracleClient.

The good news is: if you start using provider X, and then you decide to change to provider Y, you just have to add the provider in your project and map your entities. Your code should work transparently.

As you are doing this for a web application, we recommend you use the Adapter templateset.