public string GetAllDbType(ColumnSchema column) { string re="";
switch (column.NativeType.ToString().ToLower()) { case "bigint":re="BigInt";break; case "binary":re="Binary";break; case "varbinary":re="VarBinary";break; case "char":re="Char";break; case "carchar":re="VarChar";break; case "nchar":re="NChar";break; case "nvarchar":re="NVarChar";break; case "varchar":re="VarChar";break; case "datetime":re="DateTime";break; case "smalldatetime":re="SmallDateTime";break; case "decimal":re="Decimal";break; case "numeric":re="Numeric";break; case "float":re="Float";break; case "real":re="Real";break; case "int":re="Int";break; case "smallint":re="SmallInt";break; case "tinyint":re="TinyInt";break; case "money":re="Money";break; case "smallmoney":re="SmallMoney";break; case "bit":re="Bit";break; case "timestamp":re="Timestamp";break; case "uniqueidentifier":re="UniqueIdentifier";break; case "text":re="Text";break; case "image":re="Image";break; case "ntext":re="NText";break; }