deployment issue with vs 2008 c# and dotconnect

deployment issue with vs 2008 c# and dotconnect

Postby 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



type="Devart.Data.PostgreSql.PgSqlDirectFactory, Devart.Data.PostgreSql, Version=5.0.14.0, Culture=neutral, PublicKeyToken=09af7300eec23701"/>



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
kerrywales
 
Posts: 52
Joined: Tue 05 Jan 2010 12:26

Postby 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

 
   
        description="Devart dotConnect for PostgreSQL" type="Devart.Data.PostgreSql.PgSqlProviderFactory, Devart.Data.PostgreSql, Version=4.65.62.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
 

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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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

Postby 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.
kerrywales
 
Posts: 52
Joined: Tue 05 Jan 2010 12:26

Postby 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/postgresql/docs/?Deployment.html.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby 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.
kerrywales
 
Posts: 52
Joined: Tue 05 Jan 2010 12:26


Return to dotConnect for PostgreSQL