Sql server与C#数据类型转换的两个方法

 

//方法1：通过分支查找相对应的数据类型

/// <summary>
/// 数据库类型转C#数据类型
/// </summary>
/// <param name="sqlType">Sql server的数据类型</param>
/// <returns>相对应的C#数据类型</returns>
public static string SqltoCsharpT(string sqlType)
{
string cSharpType = "";
switch (sqlType)
{
case "image":
cSharpType = "byte[]";
break;
case "text":
cSharpType = "string";
break;
case "uniqueidentifier":
cSharpType = "Guid";
break;
case "tinyint":
cSharpType = "byte";
break;
case "smallint":
cSharpType = "Int16";
break;
case "int":
cSharpType = "int";
break;
case "smalldatetime":
cSharpType = "DateTime";
break;
case "real":
cSharpType = "Single";
break;
case "money":
cSharpType = "Decimal";
break;
case "datetime":
cSharpType = "DateTime";
break;
case "float":
cSharpType = "double";
break;
case "ntext":
cSharpType = "string";
break;
case "bit":
cSharpType = "bool";
break;
case "decimal":
cSharpType = "Decimal";
break;
case "smallmoney":
cSharpType = "Decimal";
break;
case "bigint":
cSharpType = "Int64";
break;
case "varbinary":
cSharpType = "byte[]";
break;
case "varchar":
cSharpType = "string";
break;
case "binary":
cSharpType = "byte[]";
break;
case "char":
cSharpType = "string";
break;
case "timestamp":
cSharpType = "byte[]";
break;
case "nvarchar":
cSharpType = "string";
break;
case "nchar":
cSharpType = "string";
break;
default:
cSharpType = string.Empty;
break;
}
return cSharpType;
}

//方法2：通过数组索引找到相对应的数据类型

/// <summary>
/// 将SQLServer数据类型（如：varchar）转换为.Net类型（如：String）
/// </summary>
/// <param name="sqlTypeString">Sql server的数据类型</param>
/// <returns>相对应的C#数据类型</returns>
public static string SqltoCsharpT(string sqlType)
{
string[] SqlTypeNames = new string[] { "int", "varchar","bit" ,"datetime","decimal","float","image","money",
"ntext","nvarchar","smalldatetime","smallint","text","bigint","binary","char","nchar","numeric",
"real","smallmoney", "sql_variant","timestamp","tinyint","uniqueidentifier","varbinary"};

string[] CSharpTypes = new string[] {"int", "string","bool" ,"DateTime","Decimal","Double","Byte[]","Single",
"string","string","DateTime","Int16","string","Int64","Byte[]","string","string","Decimal",
"Single","Single", "Object","Byte[]","Byte","Guid","Byte[]"};

int i = Array.IndexOf(SqlTypeNames, sqlType.ToLower());

return CSharpTypes[i];
}