SQL Server type C# type
Bitbool
tinyintbyte
smallintshort
Intint
bigintlong
realfloat
Floatdouble
moneydecimal
DatumTijdTijd
charstring
varcharstring
ncharstring
nvarcharstring
Textstring
nTextstring
imagebyte[]
binarybyte[]
uniqueidentifierGuid/ SqlDbType转换为C#数据类型
publiek statisch Type SqlType2CsharpType(SqlDbType sqlType)
{
switch (sqlType)
{
case SqlDbType.BigInt:
terugkeertype(Int64);
case SqlDbType.Binary:
return typeof(Object);
case SqlDbType.Bit:
return typeof(Booleaans);
case SqlDbType.Char:
return typeof(String);
case SqlDbType.DateTime:
retourtypeof(DatumTijd);
case SqlDbType.Decimal:
retourtypeof(Decimaal);
case SqlDbType.Float:
return typeof(Double);
case SqlDbType.Image:
return typeof(Object);
Zaak SqlDbType.Int:
retour typeof(Int32);
case SqlDbType.Money:
retourtypeof(Decimaal);
case SqlDbType.NChar:
return typeof(String);
case SqlDbType.NText:
return typeof(String);
case SqlDbType.NVarChar:
return typeof(String);
case SqlDbType.Real:
return typeof (Single);
case SqlDbType.SmallDateTime:
retourtypeof(DatumTijd);
case SqlDbType.SmallInt:
terugkeertype(Int16);
case SqlDbType.SmallMoney:
retourtypeof(Decimaal);
case SqlDbType.Text:
return typeof(String);
case SqlDbType.Timestamp:
return typeof(Object);
case SqlDbType.TinyInt:
return typeof(Byte);
case SqlDbType.Udt:// aangepast datatype
return typeof(Object);
case SqlDbType.UniqueIdentifier:
return typeof(Object);
case SqlDbType.VarBinary:
return typeof(Object);
case SqlDbType.VarChar:
return typeof(String);
case SqlDbType.Variant:
return typeof(Object);
case SqlDbType.Xml:
return typeof(Object);
Standaard:
return null;
}
}Kopieer de inhoud naar klembordCode:SQL Server-datatypes (bijv. varchar)
Converteer naar het type SqlDbType
publieke statische SqlDbType SqlTypeString2SqlType(string sqlTypeString)
{
SqlDbType dbType = SqlDbType.Variant; Standaard is Object
switch (sqlTypeString)
{
Case "int":
dbType = SqlDbType.Int;
pauze;
Case "Varchar":
dbType = SqlDbType.VarChar;
pauze;
Naamval "bit":
dbType = SqlDbType.Bit;
pauze;
Case "Datetime":
dbType = SqlDbType.DateTime;
pauze;
Naamval "decimaal":
dbType = SqlDbType.Decimal;
pauze;
Case "float":
dbType = SqlDbType.Float;
pauze;
Case "Afbeelding":
dbType = SqlDbType.Image;
pauze;
Case "geld":
dbType = SqlDbType.Money;
pauze;
Case "ntext":
dbType = SqlDbType.NText;
pauze;
Case "Nvarchar":
dbType = SqlDbType.NVarChar;
pauze;
Case "smalldatetime":
dbType = SqlDbType.SmallDateTime;
pauze;
Case "Smallint":
dbType = SqlDbType.SmallInt;
pauze;
Case "tekst":
dbType = SqlDbType.Text;
pauze;
Case "bigint":
dbType = SqlDbType.BigInt;
pauze;
Case "binair":
dbType = SqlDbType.Binary;
pauze;
Case "char":
dbType = SqlDbType.Char;
pauze;
Case "NCar":
dbType = SqlDbType.NChar;
pauze;
Naamval "numeriek":
dbType = SqlDbType.Decimal;
pauze;
Case "echt":
dbType = SqlDbType.Real;
pauze;
Geval "kleingeld":
dbType = SqlDbType.SmallMoney;
pauze;
Case "sql_variant":
dbType = SqlDbType.Variant;
pauze;
Case "tijdstempel":
dbType = SqlDbType.Timestamp;
pauze;
Case "Tinyint":
dbType = SqlDbType.TinyInt;
pauze;
Zaak "Uniqueidentifier":
dbType = SqlDbType.UniqueIdentifier;
pauze;
Case "varbinary":
dbType = SqlDbType.VarBinary;
pauze;
Case "XML":
dbType = SqlDbType.Xml;
pauze;
}
return dbType;
}
Kopieer de inhoud naar klembordCode:SQL Server-datatypes, omgezet naar typetypes in C#
publieke statische Type SQLTypeString2CsharpType(string sqlTypeString)
{
SqlDbType dbTpe = SqlTypeString2SqlType(sqlTypeString);
return SqlType2CsharpType(dbTpe);
}
Converteer datatypes in SQL Server naar strings van typen in C#
publieke statische string SqlTypeString2CsharpTypeString(string sqlTypeString)
{
Type type = SqlTypeString2CsharpType(sqlTypeString);
retourtype. Naam;
}
| 
Geplaatst op 19-01-2016 11:04:06
|
|
|
|
