数据库SQL SServer与C#中数据类型的对应关系

数据库	C#程序
int	int32
text	string
bigint	int64
binary	System.Byte[]
bit	Boolean
char	string
datetime	System.DateTime
decimal	System.Decimal
float	System.Double
image	System.Byte[]
money	System.Decimal
nchar	String
ntext	String
numeric	System.Decimal
nvarchar	String
real	System.Single
smalldatetime	System.DateTime
smallint	Int16
smallmoney	System.Decimal
timestamp	System.DateTime
tinyint	System.Byte
varbinary	System.Byte[]
varchar	String
Variant	Object
unique identifier	System.Guid

 

可以写写成一个方法进行转换 

/// <summary>
/// 数据库中与C#中的数据类型对照
/// </summary> 

/// <param name="type"></param>
/// <returns></returns>
private string ChangeToCSharpType(string type)
{

string reval=string.Empty;
switch(type.ToLower())
{
case "int":
reval= "Int32";
break;
case "text":
reval= "String";
break;
case "bigint":
reval= "Int64";
break;
case "binary":
reval= "System.Byte[]";
break;
case "bit":
reval= "Boolean";
break;
case "char":
reval= "String";
break;
case "datetime":
reval= "System.DateTime";
break;
case "decimal":
reval= "System.Decimal";
break;
case "float":
reval= "System.Double";
break;
case "image":
reval= "System.Byte[]";
break;
case "money":
reval= "System.Decimal";
break;
case "nchar":
reval= "String";
break;
case "ntext":
reval= "String";
break;
case "numeric":
reval= "System.Decimal";
break;
case "nvarchar":
reval= "String";
break;
case "real":
reval= "System.Single";
break;
case "smalldatetime":
reval= "System.DateTime";
break;
case "smallint":
reval= "Int16";
break;
case "smallmoney":
reval= "System.Decimal";
break;
case "timestamp":
reval= "System.DateTime";
break;
case "tinyint":
reval= "System.Byte";
break;
case "uniqueidentifier":
reval= "System.Guid";
break;
case "varbinary":
reval= "System.Byte[]";
break;
case "varchar":
reval= "String";
break;
case "Variant":
reval="Object";
break;
default:
reval= "String";
break;
}
return reval;

}