Chapter 11 Generating .NET 2.0 Persistent Objects and Windows Applications

Configuring Connection Strings

PowerDesigner supports multiple types of database connection with each of the .NET frameworks.

Each connection requires a different set of parameters, which can be entered by hand in the Connection String field of the ADO.NET or NHibernate tab, or through custom dialogs accessible via the ellipsis tool to the right of this field.

To configure a connection string from the ADO.NET or ADO.NET CF tab:

1. Select a data provider.
2. Click the ellipsis button to open a provider-specific connection string dialog.
3. [ADO.NET only] Enter the necessary parameters and click Test Connection to validate them.
4. Click Apply to Connection String and then Close to return to the ADO.NET or ADO.NET CF tab.

To configure a connection string from the NHibernate tab:

1. Select a dialect and driver class.
2. Click the ellipsis button to open a provider-specific connection string dialog.
3. Enter the necessary parameters and click Test Connection to validate them.
4. Once the connection tests correctly, click Close to return to the NHibernate tab.

Copyright (C) 2007. Sybase Inc. All rights reserved.