deployment issue with vs 2008 c# and dotconnect

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
kerrywales
Posts: 52
Joined: Tue 05 Jan 2010 12:26

deployment issue with vs 2008 c# and dotconnect

Post by kerrywales » Tue 05 Jan 2010 12:40

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 05 Jan 2010 13:43

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.

kerrywales
Posts: 52
Joined: Tue 05 Jan 2010 12:26

Post by kerrywales » Tue 05 Jan 2010 15:36

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

kerrywales
Posts: 52
Joined: Tue 05 Jan 2010 12:26

Post by kerrywales » Thu 19 Aug 2010 21:58

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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 20 Aug 2010 10:22

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.

kerrywales
Posts: 52
Joined: Tue 05 Jan 2010 12:26

Post by kerrywales » Sat 21 Aug 2010 08:11

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.

Post Reply