資料庫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;

}