ADO.NET and ADO.NET CF Options

To set the database connection parameters and other ADO.NET or ADO.NET CF options, double-click the model name in the browser to open its property sheet, and click the ADO.NET or ADO.NET CF tab.

Option

Description

Target Device

[ADO.NET CF only] Specifies the operating system on which the application will be deployed.

Output file folder

[ADO.NET CF only] Specifies the location on the device to which the application will be deployed. Click the ellipsis button to the right of this field to edit the root location and add any appropriate sub-directories.

Data Provider

Specifies which data provider you want to use. For ADO.NET, you can choose between:

  • OleDB

  • SqlClient

  • ODBC

  • Oracle

For ADO.NET CF, you can choose between:

  • Microsoft SQL Server 2005 Mobile Edition

  • Sybase ASA Mobile Edition

Connection String

Specifies the connection string. You can enter this by hand or click the ellipsis tool to the right of the field to use a custom dialog. For information about the provider-specific parameters used to build the connection string, see Configuring Connection Strings.

Default access

Specifies the default class attribute access type. This and the other package options, are valid for the whole model You can fine-tune these options for an individual package through its property sheet.

Default cascade

Specifies the default cascade type.

Default command type

Specifies the default command type, which can be overridden by concrete class.

DALContainer

Specifies the collection type returned from database. You can choose between Generic List Collection and System.Collections.ArrayList.

Logging Type

[ADO.NET only] The common logging component is Log4Net, but you can reuse it as well if you have your own logging framework. By default, the value of logging type is Console type, but PowerDesigner also supports "None" or Log4Net