SQL SERVERÓëC#µÄÊý¾ÝÀàÐͶÔÓ¦±í

ÐòºÅ
Àà±ð
SQLServer
C Sharp
±¸×¢
1
ÕûÊý
bit
Boolean
Trueת»»Îª1Falseת»»Îª0
2
tinyint
Byte
C Sharp Êý¾ÝÀàÐͶ¼Î»ÓÚSystemÃüÃû¿Õ¼ä
3
smallint
Int16
4
int
Int32
5
bigint
Int64
6
smallmoney
Decimal
7
money
Decimal
8
numeric
Decimal
9
decimal
Decimal
10
¸¡µãÊý
float
Double
11
real
Single
12
ÈÕÆÚºÍʱ¼ä
smalldatetime
DateTime
13
datetime
DateTime
14
timestamp
DateTime
15
×Ö·û´®
char
String
16
text
String
17
varchar
String
18
nchar
String
19
ntext
String
20
nvarchar
String
21
¶þ½øÖÆÊý¾Ý
¡¡
¡¡
binary
Byte[]
22
varbinary
Byte[]
23
image
Byte[]
24
ÆäËû
uniqueidentifier
Guid
25
Variant
Object
 PS.±¾À´´òËãתÔØTrackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=95675(SQL SERVERÓëC#ÖÐÊý¾ÝÀàÐ͵ĶÔÓ¦¹Øϵ) ,µ«¾õµÃ×÷ÕßÒÔ´úÂëµÄ·½Ê½Ð´³öÀ´,¿´ÆðÀ´²»ÊÇÄÇôֱ¹Û,²éÕÒÒ²²»·½±ã.ËùÒԲο¼ÁË×÷ÕßµÄÎÄÕºÍSQLServer05µÄ°ïÖúÎĵµÖÆ×÷ÁËÒÔÉÏÕâ¸ö±í¸ñ.
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1288946
 
/// <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";
     b