Current Article

SubSonic SQLite Data Mappings

By admin on Aug 28, 2010 in .NET, Programming

int maps to Int32
integer maps to Int64
bit maps to boolean
guid maps to Guid
long maps to Int64

For the complete listing, please see below code snippet from SubSonic

switch(sqlType)
{
   case "varchar":
       return DbType.AnsiString;
   
   case "nvarchar":
       return DbType.String;
   
   case "int":
       return DbType.Int32;
   
   case "integer":
     return DbType.Int64;
   
   case "long":
     return DbType.Int64;
   
   case "guid":
       return DbType.Guid;
   
   case "datetime":
       return DbType.DateTime;
   
   case "bigint":
       return DbType.Int64;
   
   case "binary":
   case "blob":
   case "image":
   case "timestamp":
   case "varbinary":
       return DbType.Binary;
 
   case "bit":
       return DbType.Boolean;
   case "char":
       return DbType.AnsiStringFixedLength;
   case "decimal":
       return DbType.Decimal;
   case "float":
       return DbType.Double;
   case "money":
       return DbType.Currency;
   case "nchar":
       return DbType.String;
   case "ntext":
       return DbType.String;
   case "numeric":
       return DbType.Decimal;
   case "real":
       return DbType.Single;
   case "smalldatetime":
       return DbType.DateTime;
   case "smallint":
       return DbType.Int16;
   case "smallmoney":
       return DbType.Currency;
   case "sql_variant":
       return DbType.String;
   case "sysname":
       return DbType.String;
   case "text":
       return DbType.AnsiString;
   case "tinyint":
       return DbType.Byte;
  
   default:
       return DbType.AnsiString;
}

Sorry, comments for this entry are closed at this time.