SQL Server tip C# tip
bitbool
tinyintbyte
smallintshort
Intint
bigintlong
realfloat
plavajoči dvojček
denarno decimalno
datetimeDateTime
strun
varcharstring
ncharstring
nvarcharstring
textstring
ntextstring
imagebyte[]
Binarybyte[]
uniqueidentifierGuid/ SqlDbType转换为C#数据类型
javni statični tip SqlType2CsharpType (SqlDbType sqlType)
{
switch (sqlType)
{
primer SqlDbType.BigInt:
return typeof(Int64);
case SqlDbType.Binary:
return typeof(Object);
primer SqlDbType.Bit:
return typeof(Boolean);
primer SqlDbType.Char:
return typeof(String);
primer SqlDbType.DateTime:
return typeof(DateTime);
primer SqlDbType.Decimal:
return typeof (decimalno);
case SqlDbType.Float:
return typeof(Double);
primer SqlDbType.Image:
return typeof(Object);
PRIMER SqlDbType.Int:
return typeof(Int32);
primer SqlDbType.Money:
return typeof (decimalno);
primer SqlDbType.NChar:
return typeof(String);
primer SqlDbType.NText:
return typeof(String);
case SqlDbType.NVarChar:
return typeof(String);
primer SqlDbType.Real:
return typeof(Single);
primer SqlDbType.SmallDateTime:
return typeof(DateTime);
primer SqlDbType.SmallInt:
return typeof(Int16);
primer SqlDbType.SmallMoney:
return typeof (decimalno);
primer SqlDbType.Text:
return typeof(String);
primer SqlDbType.Timestamp:
return typeof(Object);
case SqlDbType.TinyInt:
return typeof(Byte);
case SqlDbType.Udt:// custom data type
return typeof(Object);
primer SqlDbType.UniqueIdentifier:
return typeof(Object);
case SqlDbType.VarBinary:
return typeof(Object);
case SqlDbType.VarChar:
return typeof(String);
case SqlDbType.Variant:
return typeof(Object);
primer SqlDbType.Xml:
return typeof(Object);
Privzeto:
return null;
}
}Kopirajte vsebino na odložiščeKoda:SQL Server podatkovni tipi (npr. varchar)
Pretvorba v SqlDbType tip
javni statični SqlDbType SqlTypeString2SqlType (string sqlTypeString)
{
SqlDbType dbType = SqlDbType.Variant; Privzeto je Object
switch (sqlTypeString)
{
Primer "int":
dbType = SqlDbType.Int;
premor;
Primer "Varchar":
dbType = SqlDbType.VarChar;
premor;
Primer "bit":
dbType = SqlDbType.Bit;
premor;
Primer "DateTime":
dbType = SqlDbType.DateTime;
premor;
Primer »decimal«:
dbType = SqlDbType.Decimal;
premor;
Primer "float":
dbType = SqlDbType.Float;
premor;
Primer "Slika":
dbType = SqlDbType.Image;
premor;
Primer "denar":
dbType = SqlDbType.Money;
premor;
Primer "Ntext":
dbType = SqlDbType.NText;
premor;
Primer "Nvarchar":
dbType = SqlDbType.NVarChar;
premor;
Primer "SmallDateTime":
dbType = SqlDbType.SmallDateTime;
premor;
Primer "Smallint":
dbType = SqlDbType.SmallInt;
premor;
Primer "Besedilo":
dbType = SqlDbType.Text;
premor;
Primer "Bigint":
dbType = SqlDbType.BigInt;
premor;
Primer "binarni":
dbType = SqlDbType.Binary;
premor;
Primer "Char":
dbType = SqlDbType.Char;
premor;
Primer "NCHAR":
dbType = SqlDbType.NChar;
premor;
Primer "numeričen":
dbType = SqlDbType.Decimal;
premor;
Primer "resničen":
dbType = SqlDbType.Real;
premor;
Primer "Smallmoney":
dbType = SqlDbType.SmallMoney;
premor;
Primer "sql_variant":
dbType = SqlDbType.Variant;
premor;
Primer "časovni žig":
dbType = SqlDbType.Timestamp;
premor;
Primer "Tinyint":
dbType = SqlDbType.TinyInt;
premor;
Primer "UniqueIdentifier":
dbType = SqlDbType.UniqueIdentifier;
premor;
Primer "varbinary":
dbType = SqlDbType.VarBinary;
premor;
Primer "XML":
dbType = SqlDbType.Xml;
premor;
}
vrni dbType;
}
Kopirajte vsebino na odložiščeKoda:Podatkovni tipi SQL Serverja, pretvorjeni v tipe v C#
javni statični tip SqlTypeString2CsharpType(string sqlTypeString)
{
SqlDbType dbTpe = SqlTypeString2SqlType(sqlTypeString);
return SqlType2CsharpType(dbTpe);
}
Pretvorite podatkovne tipe v SQL Serverju v nize tipov v C#
javni statični niz SqlTypeString2CsharpTypeString(string sqlTypeString)
{
Type type = SqlTypeString2CsharpType(sqlTypeString);
vrsta vračila. Ime;
}
| 
Objavljeno na 19. 01. 2016 11:04:06
|
|
|
|
