Devart Forums

skarosg3 wrote:It seems that i need to manually install devart on each machine i am going to use my application.

skarosg3 wrote:Also, is there a way to execute multiple insert commands? When the Command String is consist of multiple sql commands seperated by a ; i get an error, saying that i cant have muliple commands

Pinturiccio wrote: You can install dotConnect for PostgreSQL with the "Minimal installation" setting and it solves some issues but it is not necessary.

It's enough to perform the following actions:
1. Create a license resource for your application. dotConnect for PostgreSQL includes License Wizard that helps you configure license information. To invoke the wizard, choose PostgreSQL | License Information from the Visual Studio Tools menu. Then click the Fix button in the dialog box and follow the wizard's instructions. For more information, please refer to http://www.devart.com/dotconnect/postgr ... nsing.html

2. If you use ASP.NET providers, you need to add the information about the provider to the web.config file. For more information, please refer to
http://www.devart.com/dotconnect/postgr ... iders.html
http://www.devart.com/dotconnect/postgr ... orial.html

3. If you use dotConnect for PostgreSQL via a factory-based class then you have to add the DbProviderFactories section of the your application config file or in machine.config file;

4. You need to deploy the Devart assemblies that are used by your application together with it;

5. If you use other dotConnect for PostgreSQL features, for example Entity Framework, LinqConnect, or other, you may need to perform some additional actions. For more information, please refer to http://www.devart.com/dotconnect/postgr ... yment.html

Pinturiccio wrote:

skarosg3 wrote:Also, is there a way to execute multiple insert commands? When the Command String is consist of multiple sql commands seperated by a ; i get an error, saying that i cant have muliple commands

PgSqlCommand class is intended to execute a single statement. You can use PgSqlScript, which allows you to execute several SQL statements one by one. For more information please refer to: http://www.devart.com/dotconnect/postgr ... cript.html

Error	1	Type 'Devart.Data.PostgreSql.PgSqlScript' is not defined.	C:\Documents and Settings\Administrator\Τα έγγραφά μου\ilias\PEAccess\PEAccess\backUp.vb	71	35	PEAccess

 Friend WithEvents pgScript As Devart.Data.PostgreSql.PgSqlScript

skarosg3 wrote:I finally used this:
cmd.UnpreparedExecute = True

and it works just fine!