I want to use report designer to create a report, and then import it into a WinForms application and deply as a ClickOnce application.
I need to package up the ODP.NET driver as part of ClickOnce, but I dont see it as a dependency to flag as "Include" in my assembly.
I only see the Oracle.ManagedDataAccess.dll in the list of Application Files to include, if I manually add a redundant DataSource to my project.
So my question is, am I taking the correct approach to ensure my users will have the Oracle driver installed, by introducing a blank ODP.NET data source just to get the .dll in my assembly?
As an alternative, I could actually "use" a data source I add to my WinForms project and swap out the details in the <DataSources><SqlDataSource> of my report XML definition to use a project level defined data source, but am not sure how to do that.
Any advice appreciated.