{"id":549,"date":"2017-07-17T22:23:58","date_gmt":"2017-07-17T14:23:58","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=549"},"modified":"2017-07-17T22:23:58","modified_gmt":"2017-07-17T14:23:58","slug":"system-data-dbtype-%e4%b8%8e%e5%85%b6%e5%ae%83dbtype%e7%9a%84%e6%98%a0%e5%b0%84%e5%85%b3%e7%b3%bb","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=549","title":{"rendered":"System.Data.DbType \u4e0e\u5176\u5b83DbType\u7684\u6620\u5c04\u5173\u7cfb"},"content":{"rendered":"<p>\u6709\u5982\u4e0b\u7c7b\u578b\u7684\u6620\u5c04\u5bf9\u7167\uff1a<br \/>\n<strong>System.Data.SqlClient.SqlDbType<br \/>\nSystem.Data.OleDb.OleDbType<br \/>\nSystem.Data.Odbc.OdbcType<br \/>\nSystem.Data.OracleClient.OracleType<\/strong><\/p>\n<p>\u683c\u5f0f\uff1aDbType.\u679a\u4e3e\u540d\uff08\u679a\u4e3e\u503c\uff09 = DbType.\u679a\u4e3e\u540d\uff08\u679a\u4e3e\u503c\uff09<\/p>\n<h3>System.Data.SqlClient.SqlDbType<\/h3>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nSystem.Data.SqlClient.SqlDbType.BigInt(0)   =  System.Data.DbType.Int64(12)\r\nSystem.Data.SqlClient.SqlDbType.Binary(1)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.SqlClient.SqlDbType.Bit(2)   =  System.Data.DbType.Boolean(3)\r\nSystem.Data.SqlClient.SqlDbType.Char(3)   =  System.Data.DbType.AnsiStringFixedLength(22)\r\nSystem.Data.SqlClient.SqlDbType.DateTime(4)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.SqlClient.SqlDbType.Decimal(5)   =  System.Data.DbType.Decimal(7)\r\nSystem.Data.SqlClient.SqlDbType.Float(6)   =  System.Data.DbType.Double(8)\r\nSystem.Data.SqlClient.SqlDbType.Image(7)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.SqlClient.SqlDbType.Int(8)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.SqlClient.SqlDbType.Money(9)   =  System.Data.DbType.Currency(4)\r\nSystem.Data.SqlClient.SqlDbType.NChar(10)   =  System.Data.DbType.StringFixedLength(23)\r\nSystem.Data.SqlClient.SqlDbType.NText(11)   =  System.Data.DbType.String(16)\r\nSystem.Data.SqlClient.SqlDbType.NVarChar(12)   =  System.Data.DbType.String(16)\r\nSystem.Data.SqlClient.SqlDbType.Real(13)   =  System.Data.DbType.Single(15)\r\nSystem.Data.SqlClient.SqlDbType.UniqueIdentifier(14)   =  System.Data.DbType.Guid(9)\r\nSystem.Data.SqlClient.SqlDbType.SmallDateTime(15)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.SqlClient.SqlDbType.SmallInt(16)   =  System.Data.DbType.Int16(10)\r\nSystem.Data.SqlClient.SqlDbType.SmallMoney(17)   =  System.Data.DbType.Currency(4)\r\nSystem.Data.SqlClient.SqlDbType.Text(18)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.SqlClient.SqlDbType.Timestamp(19)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.SqlClient.SqlDbType.TinyInt(20)   =  System.Data.DbType.Byte(2)\r\nSystem.Data.SqlClient.SqlDbType.VarBinary(21)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.SqlClient.SqlDbType.VarChar(22)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.SqlClient.SqlDbType.Variant(23)   =  System.Data.DbType.Object(13)\r\nSystem.Data.SqlClient.SqlDbType.Xml(25)   =  System.Data.DbType.Xml(25)\r\nSystem.Data.SqlClient.SqlDbType.Udt(29)   =  System.Data.DbType.Object(13)\r\nSystem.Data.SqlClient.SqlDbType.Structured(30)   =  System.Data.DbType.Object(13)\r\nSystem.Data.SqlClient.SqlDbType.Date(31)   =  System.Data.DbType.Date(5)\r\nSystem.Data.SqlClient.SqlDbType.Time(32)   =  System.Data.DbType.Time(17)\r\nSystem.Data.SqlClient.SqlDbType.DateTime2(33)   =  System.Data.DbType.DateTime2(26)\r\nSystem.Data.SqlClient.SqlDbType.DateTimeOffset(34)   =  System.Data.DbType.DateTimeOffset(27)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3>System.Data.OleDb.OleDbType<\/h3>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nSystem.Data.OleDb.OleDbType.Empty(0)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OleDb.OleDbType.SmallInt(2)   =  System.Data.DbType.Int16(10)\r\nSystem.Data.OleDb.OleDbType.Integer(3)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.OleDb.OleDbType.Single(4)   =  System.Data.DbType.Single(15)\r\nSystem.Data.OleDb.OleDbType.Double(5)   =  System.Data.DbType.Double(8)\r\nSystem.Data.OleDb.OleDbType.Currency(6)   =  System.Data.DbType.Currency(4)\r\nSystem.Data.OleDb.OleDbType.Date(7)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OleDb.OleDbType.BSTR(8)   =  System.Data.DbType.String(16)\r\nSystem.Data.OleDb.OleDbType.IDispatch(9)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OleDb.OleDbType.Error(10)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.OleDb.OleDbType.Boolean(11)   =  System.Data.DbType.Boolean(3)\r\nSystem.Data.OleDb.OleDbType.Variant(12)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OleDb.OleDbType.IUnknown(13)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OleDb.OleDbType.Decimal(14)   =  System.Data.DbType.Decimal(7)\r\nSystem.Data.OleDb.OleDbType.TinyInt(16)   =  System.Data.DbType.SByte(14)\r\nSystem.Data.OleDb.OleDbType.UnsignedTinyInt(17)   =  System.Data.DbType.Byte(2)\r\nSystem.Data.OleDb.OleDbType.UnsignedSmallInt(18)   =  System.Data.DbType.UInt16(18)\r\nSystem.Data.OleDb.OleDbType.UnsignedInt(19)   =  System.Data.DbType.UInt32(19)\r\nSystem.Data.OleDb.OleDbType.BigInt(20)   =  System.Data.DbType.Int64(12)\r\nSystem.Data.OleDb.OleDbType.UnsignedBigInt(21)   =  System.Data.DbType.UInt64(20)\r\nSystem.Data.OleDb.OleDbType.Filetime(64)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OleDb.OleDbType.Guid(72)   =  System.Data.DbType.Guid(9)\r\nSystem.Data.OleDb.OleDbType.Binary(128)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OleDb.OleDbType.Char(129)   =  System.Data.DbType.AnsiStringFixedLength(22)\r\nSystem.Data.OleDb.OleDbType.WChar(130)   =  System.Data.DbType.StringFixedLength(23)\r\nSystem.Data.OleDb.OleDbType.Numeric(131)   =  System.Data.DbType.Decimal(7)\r\nSystem.Data.OleDb.OleDbType.DBDate(133)   =  System.Data.DbType.Date(5)\r\nSystem.Data.OleDb.OleDbType.DBTime(134)   =  System.Data.DbType.Time(17)\r\nSystem.Data.OleDb.OleDbType.DBTimeStamp(135)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OleDb.OleDbType.PropVariant(138)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OleDb.OleDbType.VarNumeric(139)   =  System.Data.DbType.VarNumeric(21)\r\nSystem.Data.OleDb.OleDbType.VarChar(200)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OleDb.OleDbType.LongVarChar(201)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OleDb.OleDbType.VarWChar(202)   =  System.Data.DbType.String(16)\r\nSystem.Data.OleDb.OleDbType.LongVarWChar(203)   =  System.Data.DbType.String(16)\r\nSystem.Data.OleDb.OleDbType.VarBinary(204)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OleDb.OleDbType.LongVarBinary(205)   =  System.Data.DbType.Binary(1)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3>System.Data.Odbc.OdbcType<\/h3>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nSystem.Data.Odbc.OdbcType.BigInt(1)   =  System.Data.DbType.Int64(12)\r\nSystem.Data.Odbc.OdbcType.Binary(2)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.Odbc.OdbcType.Bit(3)   =  System.Data.DbType.Boolean(3)\r\nSystem.Data.Odbc.OdbcType.Char(4)   =  System.Data.DbType.AnsiStringFixedLength(22)\r\nSystem.Data.Odbc.OdbcType.DateTime(5)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.Odbc.OdbcType.Decimal(6)   =  System.Data.DbType.Decimal(7)\r\nSystem.Data.Odbc.OdbcType.Numeric(7)   =  System.Data.DbType.Decimal(7)\r\nSystem.Data.Odbc.OdbcType.Double(8)   =  System.Data.DbType.Double(8)\r\nSystem.Data.Odbc.OdbcType.Image(9)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.Odbc.OdbcType.Int(10)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.Odbc.OdbcType.NChar(11)   =  System.Data.DbType.StringFixedLength(23)\r\nSystem.Data.Odbc.OdbcType.NText(12)   =  System.Data.DbType.String(16)\r\nSystem.Data.Odbc.OdbcType.NVarChar(13)   =  System.Data.DbType.String(16)\r\nSystem.Data.Odbc.OdbcType.Real(14)   =  System.Data.DbType.Single(15)\r\nSystem.Data.Odbc.OdbcType.UniqueIdentifier(15)   =  System.Data.DbType.Guid(9)\r\nSystem.Data.Odbc.OdbcType.SmallDateTime(16)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.Odbc.OdbcType.SmallInt(17)   =  System.Data.DbType.Int16(10)\r\nSystem.Data.Odbc.OdbcType.Text(18)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.Odbc.OdbcType.Timestamp(19)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.Odbc.OdbcType.TinyInt(20)   =  System.Data.DbType.Byte(2)\r\nSystem.Data.Odbc.OdbcType.VarBinary(21)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.Odbc.OdbcType.VarChar(22)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.Odbc.OdbcType.Date(23)   =  System.Data.DbType.Date(5)\r\nSystem.Data.Odbc.OdbcType.Time(24)   =  System.Data.DbType.Time(17)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h3>System.Data.OracleClient.OracleType<\/h3>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nSystem.Data.OracleClient.OracleType.BFile(1)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OracleClient.OracleType.Blob(2)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OracleClient.OracleType.Char(3)   =  System.Data.DbType.AnsiStringFixedLength(22)\r\nSystem.Data.OracleClient.OracleType.Clob(4)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OracleClient.OracleType.Cursor(5)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OracleClient.OracleType.DateTime(6)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OracleClient.OracleType.IntervalDayToSecond(7)   =  System.Data.DbType.Object(13)\r\nSystem.Data.OracleClient.OracleType.IntervalYearToMonth(8)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.OracleClient.OracleType.LongRaw(9)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OracleClient.OracleType.LongVarChar(10)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OracleClient.OracleType.NChar(11)   =  System.Data.DbType.StringFixedLength(23)\r\nSystem.Data.OracleClient.OracleType.NClob(12)   =  System.Data.DbType.String(16)\r\nSystem.Data.OracleClient.OracleType.Number(13)   =  System.Data.DbType.VarNumeric(21)\r\nSystem.Data.OracleClient.OracleType.NVarChar(14)   =  System.Data.DbType.String(16)\r\nSystem.Data.OracleClient.OracleType.Raw(15)   =  System.Data.DbType.Binary(1)\r\nSystem.Data.OracleClient.OracleType.RowId(16)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OracleClient.OracleType.Timestamp(18)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OracleClient.OracleType.TimestampLocal(19)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OracleClient.OracleType.TimestampWithTZ(20)   =  System.Data.DbType.DateTime(6)\r\nSystem.Data.OracleClient.OracleType.VarChar(22)   =  System.Data.DbType.AnsiString(0)\r\nSystem.Data.OracleClient.OracleType.Byte(23)   =  System.Data.DbType.Byte(2)\r\nSystem.Data.OracleClient.OracleType.UInt16(24)   =  System.Data.DbType.UInt16(18)\r\nSystem.Data.OracleClient.OracleType.UInt32(25)   =  System.Data.DbType.UInt32(19)\r\nSystem.Data.OracleClient.OracleType.SByte(26)   =  System.Data.DbType.SByte(14)\r\nSystem.Data.OracleClient.OracleType.Int16(27)   =  System.Data.DbType.Int16(10)\r\nSystem.Data.OracleClient.OracleType.Int32(28)   =  System.Data.DbType.Int32(11)\r\nSystem.Data.OracleClient.OracleType.Float(29)   =  System.Data.DbType.Single(15)\r\nSystem.Data.OracleClient.OracleType.Double(30)   =  System.Data.DbType.Double(8)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u5982\u4e0b\u7c7b\u578b\u7684\u6620\u5c04\u5bf9\u7167\uff1a System.Data.SqlClient.SqlDbT&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=549\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-549","post","type-post","status-publish","format-standard","hentry","category-csharp"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=549"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/549\/revisions"}],"predecessor-version":[{"id":550,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/549\/revisions\/550"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}