private string GetColumnDataType(SchemaExplorer.ColumnSchema ColumnField)
{
string retType="";
switch (ColumnField.NativeType.ToLower())
{
case "int" : case "tinyint" : case "smallint" : case "bigint" :
retType = "int" ;
break;
case "decimal" : case "float" : case "money" : case "numeric" : case "smallmoney" :
retType = "double" ;
break;
case "char" : case "nchar" : case "ntext" : case "text" : case "varchar" : case "nvarchar" :
retType = "string" ;
break;
case "smalldatetime" : case "timestamp" : case "datetime" :
retType = "DateTime" ;
break;
case "bit" :
retType = "bool" ;
break;
case "binary" : case "image" : case "varbinary" :
retType = "byte[]" ;
break;
}
return retType;
}