ConvertType
Gets error message from a native exception.
For example:
SqlException -> SqlException.Message,
OleDbException -> OleDbException.Errors[0].Message
Gets error number from a native exception.
For example:
SqlException -> SqlException.Number,
OleDbException -> OleDbException.Errors[0].NativeError
Provided name should be converted to command parameter name.
For example:
firstName -> @firstName
for the following query:
db.Parameter("@firstName") = "John";
^ here
NameToDatabase = 6
Provided name should be converted to query database.
For example:
MyDatabase -> [MyDatabase]
for the following query:
SELECT * FROM [MyDatabase]..[Person]
^ add ^
NameToPackage = 8
Provided name should be converted to package/module/library name.
NameToProcedure = 9
Provided name should be converted to function/procedure name.
NameToQueryField = 3
Provided name should be converted to query field name.
For example:
FirstName -> [FirstName]
for the following query:
SELECT [FirstName] FROM Person WHERE ID = 1
^ add ^
Provided name should be converted to query field alias.
For example:
ID -> "ID"
for the following query:
SELECT "ID" as "ID" FROM Person WHERE "ID" = 1
^ ^ here
Provided name should be converted to query parameter name.
For example:
firstName -> @firstName
for the following query:
SELECT * FROM Person WHERE FirstName = @firstName
^ here
NameToQueryTable = 10
Provided name should be converted to query table name.
For example:
Person -> [Person]
for the following query:
SELECT * FROM [Person]
^ add ^
Provided name should be converted to query table alias.
For example:
table1 -> [table1]
for the following query:
SELECT * FROM [Person] [table1]
^ add ^
NameToSchema = 7
Provided name should be converted to query schema/owner.
For example:
dbo -> [dbo]
for the following query:
SELECT * FROM [ dbo ].[Person]
^ add ^
NameToServer = 5
Provided name should be converted to linked server name.
For example:
host name\named instance -> [host name\named instance]
for the following query:
SELECT * FROM [host name\named instance]..[Person]
^ add ^
Provided name should be converted to stored procedure parameter name.
For example:
firstName -> @firstName
for the following query:
db.Parameter("@firstName") = "John";
^ here
SequenceName = 15
Provided name should be converted to sequence name.
SprocParameterToName = 12
Provided stored procedure parameter name should be converted to name.
For example:
@firstName -> firstName
for the following query:
db.Parameter("@firstName") = "John";
^ '@' has to be removed
TriggerName = 16
Provided name should be converted to trigger name.