Page 1 of 1

deployment issue with vs 2008 c# and dotconnect

Posted: Tue 05 Jan 2010 12:40
by kerrywales
I am looking to see how to create the deployment files for a c# project.
The app works fine on the development m/c's.
When a deployment version is created the app complains that it is unable to find the provider.
I have found to ref's on the forum that I hoped would help. One in MySQL and one in this forum. The posting refers to adding into App.Config code like







I had no system.data section to start with and so it is in the section.

When added to App.config the development PC fails to run the app with the error: InvariantName is constrained to be unique Devart.Data.PostreSql is already present. Creating a different InvariantName doesn't help the deployment creation.

Automatically created in the App.config is a section within the section. It is as follows











I cannot find any relevant documentation to the structure of this file and I don't want to mess around with this too much without knowing the syntax & grammar.

Can anyone point me in the right direction please.

Can I create an App.Config that works for both deployment and development machines or do I need one for each?

Thanks

Posted: Tue 05 Jan 2010 13:43
by Shalex
Please put the following entry inside the configuration section of your App.config. The entry will allow you to use this App.config on your development and deployment machines.

Code: Select all

  
    
    
  
Replace 4.65.62.0 here with your actual version. You can find your current version in the Tools | PostreSQL | About menu fo Visual Studio.

General information is here.

Posted: Tue 05 Jan 2010 15:36
by kerrywales
Thank you for the prompt info. It is all starting to make sense now. This compiles and installs cleanly now. Just a case of debugging to see why it won't connect now. But at least I know how to deply.

Many thanks :D

Posted: Thu 19 Aug 2010 21:58
by kerrywales
I have just returned to my deployment issue.

I have created a deployment project within my application solution using MS documentation.

The Setup project contains
Detected Dependencies folder
Primary Output ... object

Within the Detected Dependencies there are two Devart references
Devart.Data.Dll
Devart.Data.PostgreSql.dll

The installer compilles but when I run the app it tells me
Could not load file or assembly Devart.Data.Postgresql.Entity

Do I have missing dependencies?
Is there a document to tell me what should be there and how to set it up?

This is still my first deployment project. so learning the mechanism from scratch.

Posted: Fri 20 Aug 2010 10:22
by Shalex
It is necessary to add the reference to Devart.Data.PostgreSql.Entity.dll for the Entity Framework projects. For more information about deployment, please refer to http://www.devart.com/dotconnect/postgr ... yment.html.

Posted: Sat 21 Aug 2010 08:11
by kerrywales
Thanks for the pointer and reference. Obvious when not tired.

This works a treat on my development box. Will test on virgin box next week.

Thanks.