ComponentOne DataObjects for .NET
SqlParameterNameFormat Property

C1.Data.2 Assembly > C1.Data.SchemaObjects Namespace > CustomProviderInfo Class : SqlParameterNameFormat Property
Gets or sets a format string used to generate parameter names in SQL statements from parameter number {0} and name {1}.
Syntax
'Declaration
 
Public Property SqlParameterNameFormat As System.String
public System.string SqlParameterNameFormat {get; set;}
Remarks
Generating SQL statements, C1DataObjects uses this format string to generate parameter names in the SQL statement. For example, for a SQL Server database, the string can be "@{1}", which will generate parameters like this:

SELECT ... FROM ... WHERE ... = @aName

SQL Server accepts named parameters, so we can use the suggested name (parameter name, {1}) in the SQL statement. Suggested name is usually based on a field name, but it is generally at C1DataObjects discretion. Another possible option for SQL Server can be "@Par{0}", which ignores the suggested name and uses the (unique) parameter number to generate parameter names in the SQL statement. For an Oracle database, a correct format string can be ":{1}" or ":Par{0}".

See Also

Reference

CustomProviderInfo Class
CustomProviderInfo Members
ParameterNameFormat Property