GetParameterNamePrefix Method (DbProvider)

Gets the prefix used by the underlying database type for parameters in a parameterized query

Syntax

Visual Basic
C#

'Declaration
 
Public MustOverride Function GetParameterNamePrefix() As String

public abstract string GetParameterNamePrefix()

Return Value

The prefix used by the underlying database type for parameters in a parameterized query (i.e. "@" for MSSQL) or String.Empty for providers which do not use prefixes or parameter names

Remarks

Some database and/or provider types do not use prefixes for parameters, or do not use parameter names at all. One example of this is the OleDb provider uses "?" for all parameters instead of a prefix + name. In this case, String.Empty will be returned.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Reference

DbProvider Class
DbProvider Members

© 2010 Dovetail Software, Inc. - All rights reserved.
- Clarify, Amdocs, and related products and names are copyright and trademark of Amdocs, Inc.
- .NET, Visual Studio.NET, C#, Visual Basic and related products are trademark of Microsoft corporation.

Send comments on this topic.