DBConfigSection
database parameter
Description
Specifies the section in a .NET configuration file to be used to
specify custom configuration settings.
When to specify DBConfigSection
You must specify a value for DBConfigSection before connecting
to the database.
Applies to
ADO.NET
Syntax
|
1 |
DBConfigSection='value' |
|
Parameter |
Description |
|---|---|
|
value |
A string that specifies the section in a .NET |
Default value
None.
Usage
You can use the standard select @@identity syntax to obtain the
value of an identity column. You can also use an alternative syntax,
such as select scope_identity(), by adding sections to a .NET
configuration file for your application.
The configuration file resides in the same directory as the
application and has the same name as the application with the extension
.config. It can contain multiple custom configuration sections. Each has
two attributes: dbParm and getIdentity. You can set either or both of
these attributes. For Web applications, add the settings to the
web.config file.
The dbParm value sets the value of the DBParm parameter of the
transaction object. It has a maximum length of 1000 characters. If you
set a value for a parameter in the configuration file, any value that
you set in code or in the Database Profile Setup dialog box is
overridden.
The getIdentity value specifies the syntax used to retrieve the
value of an identity column. It has a maximum length of 100 characters.
If you do not specify a value for getIdentity, the select @@identity
syntax is used.
For more information about creating the configuration file, see
the section called “Getting identity column values” in Connecting to Your Database.
Examples
To specify that your PowerBuilder application uses the custom
configuration file called myconfig1:
-
Database profile
Specify myconfig1 in the ConfigSection Name in Configuration
File box on the System tabpage in the Database Profile Setup dialog
box. -
Application
Type the following in code:
1SQLCA.DBParm="DBConfigSection='myconfig1'"
This sample configuration file for PowerBuilder is called
pb190.exe.config. It contains three custom configurations. The
<myconfig> element sets both the dbParm and getIdentity
attributes. <myconfig1> sets getIdentity only, and
<myconfig2> sets dbParm only. The <runtime> section is in
the configuration file that ships with PowerBuilder but would not be
included in the configuration file that you ship with your application,
which would have the same name as your application with the extension
exe.config. For .NET Web Service targets, you add the custom
configurations to the web.config file. The <configSections>
section should be added before any other application settings.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
<configuration> <configSections> <sectionGroup name="dbConfiguration"> <section name="myconfig" type="Sybase.PowerBuilderDataWindow.Db.DbConfiguration, Sybase.PowerBuilderDataWindow.Db" /> <section name="myconfig1" type="Sybase.PowerBuilderDataWindow.Db.DbConfiguration, Sybase.PowerBuilderDataWindow.Db" /> <section name="myconfig2" type="Sybase.PowerBuilderDataWindow.Db.DbConfiguration, Sybase.PowerBuilderDataWindow.Db" /> </sectionGroup> </configSections> <runtime> <assemblyBinding xmlns= "urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name= "Sybase.PowerBuilder.Db"/> <codeBase href="file:///C:/Program Files/ Appeon/PowerBuilder 19.0/DotNET/bin/ Sybase.PowerBuilder.Db.dll"/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name= "Sybase.PowerBuilder.WebService.WSDL"/> <codeBase href="file:///C:/Program Files/ Appeon/PowerBuilder 19.0/DotNET/bin/ Sybase.PowerBuilder.WebService.WSDL.dll"/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name= "Sybase.PowerBuilder.WebService.Runtime"/> <codeBase href="file:///C:/Program Files/ Appeon/PowerBuilder 19.0/DotNET/bin/ Sybase.PowerBuilder.WebService. Runtime.dll"/> </dependentAssembly> <probing privatePath="DotNET/bin" /> </assemblyBinding> </runtime> <dbConfiguration> <myconfig dbParm="disablebind=0" getIdentity="select scope_identity()" /> <myconfig1 getIdentity="select scope_identity()" /> <myconfig2 = "Namespace='Oracle.DataAccess.Client', DataSource='ora10gen',DisableBind=1, NCharBind=1,ADORelease='10.1.0.301'" /> </dbConfiguration> </configuration> |