Database type |
SQL Server |
ADO.NET DbProviderFactory |
System.Data.SqlClient.SqlClientFactory |
System sequences
SCOPE_IDENTITY()
@@IDENTITY
Type mapping tables
DB Type to .NET Type
DB Type |
.NET Type |
BigInt |
System.Int64 |
Binary |
System.Byte[] |
Bit |
System.Boolean |
Char |
System.String |
DateTime |
System.DateTime |
Decimal |
System.Decimal |
Float |
System.Double |
Image |
System.Byte[] |
Int |
System.Int32 |
Money |
System.Decimal |
NChar |
System.String |
NText |
System.String |
NVarChar |
System.String |
Numeric |
System.Decimal |
Real |
System.Single |
SmallDateTime |
System.DateTime |
SmallInt |
System.Int16 |
SmallMoney |
System.Decimal |
Sql_Variant |
System.Object |
SysName |
System.String |
Text |
System.String |
TimeStamp |
System.Byte[] |
TinyInt |
System.Byte |
VarBinary |
System.Byte[] |
VarChar |
System.String |
UniqueIdentifier |
System.Guid |
Xml |
System.String |
UserDefinedType |
System.Object |
Date |
System.DateTime |
DateTime2 |
System.DateTime |
DateTimeOffset |
System.DateTimeOffset |
Time |
System.TimeSpan |
Geometry |
SD.LLBLGen.Pro.DBDriverCore.SpatialGeometry |
Geography |
SD.LLBLGen.Pro.DBDriverCore.SpatialGeography |
DB Type to ADO.NET Provider Type
DB Type |
ADO.NET Provider Type |
BigInt |
BigInt |
Binary |
Binary |
Bit |
Bit |
Char |
Char |
DateTime |
DateTime |
Decimal |
Decimal |
Float |
Float |
Image |
Image |
Int |
Int |
Money |
Money |
NChar |
NChar |
NText |
NText |
NVarChar |
NVarChar |
Numeric |
Decimal |
Real |
Real |
SmallDateTime |
SmallDateTime |
SmallInt |
SmallInt |
SmallMoney |
SmallMoney |
Sql_Variant |
Variant |
SysName |
VarChar |
Text |
Text |
TimeStamp |
Timestamp |
TinyInt |
TinyInt |
VarBinary |
VarBinary |
VarChar |
VarChar |
UniqueIdentifier |
UniqueIdentifier |
Xml |
Xml |
UserDefinedType |
Udt |
Date |
Date |
DateTime2 |
DateTime2 |
DateTimeOffset |
DateTimeOffset |
Time |
Time |
Geometry |
Udt |
Geography |
Udt |
RDBMS aspects
- Auto generate identity fields
- Uses sequences for identity field values
- Central unit is catalog
- Supports multiple central units per project
- Supports foreign key constraints
- Supports multiple schemas per central unit
- Supports schema only resultset retrieval
- Supports natural character specific types
- Supports delete rules
- Supports update rules