Data Access has been discontinued. Please refer to this page for more information.

Type Mapping

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

Telerik Data Access supports flexible mappings from .NET types (e.g., System.String) to database specific SQL types (e.g., VARCHAR on SQL Anywhere). The default mappings can be customized for a specific datastore. The mapping for specific fields can also be customized. Mappings are resolved by first using any information specified for the field, then looking up a generic type for the type of the field using the .NET Type Mapping, then converting this generic type into actual SQL type information using the Generic Type Mapping. You can have different mapping information for each database supported by Telerik Data Access.

The following table shows the default mapping from .NET types to SQL Anywhere specific types:

.NET Type SQL Anywhere Type
System.Boolean BIT
System.Char CHAR(1)
System.SByte SMALLINT
System.Byte TINYINT
System.Int16 SMALLINT
System.UInt16 UNSINGNED SMALLINT
System.Int32 INTEGER
System.UInt32 UNSINGNED INT
System.Int64 BIGINT
System.UInt64 UNSINGNED BIGINT
System.Single REAL
System.Double DOUBLE
System.String VARCHAR(255)
System.DateTime TIMESTAMP
System.Decimal NUMERIC(32,6)
System.Guid UNIQUEIDENTIFIER
Byte[] LONG BINARY