Skip to content

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
Clone this wiki locally