TypeName
ProviderDbType
ColumnSize
CreateFormat
CreateParameters
DataType
IsAutoIncrementable
IsBestMatch
IsCaseSensitive
IsFixedLength
IsFixedPrecisionScale
IsLong
IsNullable
IsSearchable
IsSearchableWithLike
IsUnsigned
MaximumScale
MinimumScale
IsConcurrencyType
IsLiteralSupported
LiteralPrefix
LiteralSuffix
NativeDataType
Short
2
5
System.Int16
2
Long
3
10
System.Int32
3
Single
4
7
System.Single
4
Double
5
15
System.Double
5
Currency
6
19
System.Decimal
6
DateTime
7
8
System.DateTime
#
#
7
Bit
11
2
System.Boolean
11
Byte
17
3
System.Byte
17
GUID
72
16
System.Guid
72
BigBinary
204
4000
System.Byte[]
0x
128
LongBinary
205
1073741823
System.Byte[]
0x
128
VarBinary
204
510
max length
System.Byte[]
0x
128
LongText
203
536870910
System.String
'
'
130
VarChar
202
255
max length
System.String
'
'
130
Decimal
131
28
precision,scale
System.Decimal
28
0
131