-
Notifications
You must be signed in to change notification settings - Fork 1
Parameter types support
Zohar Peled edited this page Aug 1, 2017
·
3 revisions
Parameter types supported in ADONETHelper mapped to Syatem.Data enumns | ||||
ADONET | DBType | OleDb | Odbc | SQL |
Boolean | Boolean | Boolean | Bit | Bit |
Byte | Byte | UnsignedTinyInt | TinyInt | TinyInt |
Binary | Binary | Binary | Binary | Binary |
Char | AnsiStringFixedLength | Char | Char | Char |
Date | Date | DBDate | Date | Date |
DateTime | DateTime | DBTimeStamp | DateTime | DateTime |
DateTime2 | DateTime2 | DateTime2 | ||
DateTimeOffset | DateTimeOffset | DateTimeOffset | ||
Decimal | Decimal | Decimal | Decimal | Decimal |
Double | Double | Double | Double | Float |
Single | Single | Single | Real | Real |
Guid | Guid | Guid | UniqueIdentifier | UniqueIdentifier |
SmallInt | Int16 | SmallInt | SmallInt | SmallInt |
Int | Int32 | Integer | Int | Int |
BigInt | Int64 | BigInt | BigInt | BigInt |
Object | Object | Variant | Variant | |
NChar | String | WChar | NChar | NChar |
NVarChar | StringFixedLength | VarWChar | NVarChar | NVarChar |
VarBinary | Binary | VarBinary | VarBinary | VarBinary |
VarChar | AnsiString | VarChar | VarChar | VarChar |
Structured | Structured | |||
Time | Time | DBTime | Time | Time |
UInt16 | UInt16 | UnsignedSmallInt | ||
UInt32 | UInt32 | UnsignedInt | ||
UInt64 | UInt64 | UnsignedBigInt | ||
Xml | Xml | Xml | ||
Currency | Currency | Currency | Money | |
Image | LongVarBinary | Image | Image | |
NText | LongVarWChar | NText | NText | |
Text | LongVarChar | Text | Text | |
SmallDateTime | Date | SmallDateTime | SmallDateTime | |
Timestamp | Timestamp | Timestamp | ||
SmallMoney | SmallMoney | |||
Udt | Udt | |||
SByte | SByte | TinyInt | TinyInt | |
VarNumeric | VarNumeric | VarNumeric | ||
Parameter types in Syatem.Data enumns currently not supported in ADONETHelper | ||||
ADONET | DBType | OleDb | Odbc | SQL |
Numeric | Numeric | |||
IDispatch | ||||
IUnknown | ||||
PropVariant | ||||
Filetime | ||||
BSTR | ||||
Empty | ||||
Error |