Is there any class similar to ProvidersHelper but not for web?

Question

Is there any class similar to ProvidersHelper but not for web? I want to instantiate a collection of providers. Actually I'm using CodeSmith & Nettiers, and the db provider is Oracle. It generated a provider section to be added at app.config, and i dont know why it uses System.Web.Configuration classes or why at this section it says SQLClient instead of OracleClient.

The error that I'm getting is: "An unhandled exception of type 'System.Configuration.ConfigurationErrorsException' occurred in System.Web.dll

Additional information: Could not load file or assembly 'LLPA.Data.OracleClient' or one of its dependencies. The system cannot find the file specified."

Any idea or solution is appreciated.

Answer 1

Check the DLL LLPA.Data.OracleClient is in the bin folder or the GAC. If that doesn't work look into using Fuslogvw.exe.

Answer 2

I haven't had added the reference of 'LLPA.Data.OracleClient' to my application, that's why it couldn't find it. Thnx Richard.