<script runat="template">
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; }
if (column.Size >
0&&column.NativeType.ToString().ToLower()!="ntext"&&column.NativeType.ToString().ToLower()!="text")
{ re+=","+column.Size;
} //re=column.NativeType.ToLower(); return
re; }
</script>
|