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 = 5
Provided name should be converted to query database.
For example:
MyDatabase -> [MyDatabase]
for the following query:
SELECT * FROM [MyDatabase]..[Person]
^ and ^
NameToOwner = 6
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
^ and ^
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 = 7
Provided name should be converted to query table name.
For example:
Person -> [Person]
for the following query:
SELECT * FROM [Person]
^ and ^
Provided name should be converted to query table alias.
For example:
table1 -> [table1]
for the following query:
SELECT * FROM [Person] [table1]
^ and ^
NameToSchema = 6
Provided name should be converted to query database.
For example:
dbo -> [dbo]
for the following query:
SELECT * FROM [ dbo ].[Person]
^ and ^
Provided name should be converted to stored procedure parameter name.
For example:
firstName -> @firstName
for the following query:
db.Parameter("@firstName") = "John";
^ here
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