mcs/class/System.Data/Documentation/en/ns-System.Data.SqlTypes.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <Namespace Name="System.Data.SqlTypes">
   3   <Docs>
   4     <summary>
   5       <attribution license="cc4" from="Microsoft" modified="false" />
   6       <para>The <see cref="N:System.Data.SqlTypes" /> namespace provides classes for native data types in ssNoVersion. These classes provide a safer, faster alternative to the data types provided by the .NET Framework common language runtime (CLR). Using the classes in this namespace helps prevent type conversion errors caused by loss of precision. Because other data types are converted to and from SqlTypes behind the scenes, explicitly creating and using objects within this namespace also yields faster code.</para>
   7     </summary>
   8     <remarks>
   9       <attribution license="cc4" from="Microsoft" modified="false" />
  10       <para>Each data type in SqlTypes has its equivalent data type in SQL Server, with the same underlying data representation. Many of them also have equivalent data types in the CLR. However, SqlDateTime, SqlDecimal, and SqlString have different underlying data structures with their corresponding .NET Framework data types. </para>
  11       <para>The following table maps the members of the SqlTypes namespace to Microsoft ssNoVersion data types and to the members of the <see cref="T:System.Data.SqlDbType" /> enumeration. </para>
  12       <list type="table">
  13         <listheader>
  14           <item>
  15             <term>
  16               <para>.NET Framework SqlTypes </para>
  17             </term>
  18             <description>
  19               <para>Native ssNoVersion</para>
  20             </description>
  21             <description>
  22               <para>.NET Framework SqlDbType</para>
  23             </description>
  24           </item>
  25         </listheader>
  26         <item>
  27           <term>
  28             <para>
  29               <see cref="T:System.Data.SqlTypes.SqlBinary" /> </para>
  30           </term>
  31           <description>
  32             <para>binary, image, timestamp, varbinary</para>
  33           </description>
  34           <description>
  35             <para>Binary, Image, TimeStamp, VarBinary</para>
  36           </description>
  37         </item>
  38         <item>
  39           <term>
  40             <para>
  41               <see cref="T:System.Data.SqlTypes.SqlBoolean" /> </para>
  42           </term>
  43           <description>
  44             <para>bit</para>
  45           </description>
  46           <description>
  47             <para>Bit</para>
  48           </description>
  49         </item>
  50         <item>
  51           <term>
  52             <para>
  53               <see cref="T:System.Data.SqlTypes.SqlByte" />
  54             </para>
  55           </term>
  56           <description>
  57             <para>tinyint</para>
  58           </description>
  59           <description>
  60             <para>TinyInt</para>
  61           </description>
  62         </item>
  63         <item>
  64           <term>
  65             <para>
  66               <see cref="T:System.Data.SqlTypes.SqlBytes" />
  67             </para>
  68           </term>
  69           <description>
  70             <para>binary, image, timestamp, varbinary</para>
  71           </description>
  72           <description>
  73             <para>Binary, Image, TimeStamp, VarBinary</para>
  74           </description>
  75         </item>
  76         <item>
  77           <term>
  78             <para>
  79               <see cref="T:System.Data.SqlTypes.SqlChars" />
  80             </para>
  81           </term>
  82           <description>
  83             <para>char, nchar, text, ntext, nvarchar, varchar</para>
  84           </description>
  85           <description>
  86             <para>Char, NChar, Text, Ntext, NVarChar, VarChar</para>
  87           </description>
  88         </item>
  89         <item>
  90           <term>
  91             <para>
  92               <see cref="T:System.Data.SqlTypes.SqlDateTime" /> </para>
  93           </term>
  94           <description>
  95             <para>datetime, smalldatetime</para>
  96           </description>
  97           <description>
  98             <para>DateTime, SmallDateTime</para>
  99           </description>
 100         </item>
 101         <item>
 102           <term>
 103             <para>
 104               <see cref="T:System.Data.SqlTypes.SqlDecimal" /> </para>
 105           </term>
 106           <description>
 107             <para>numeric, decimal</para>
 108           </description>
 109           <description>
 110             <para>Decimal</para>
 111           </description>
 112         </item>
 113         <item>
 114           <term>
 115             <para>
 116               <see cref="T:System.Data.SqlTypes.SqlDouble" /> </para>
 117           </term>
 118           <description>
 119             <para>float</para>
 120           </description>
 121           <description>
 122             <para>Float</para>
 123           </description>
 124         </item>
 125         <item>
 126           <term>
 127             <para>
 128               <see cref="T:System.Data.SqlTypes.SqlFileStream" /> </para>
 129           </term>
 130           <description>
 131             <para>varbinary</para>
 132           </description>
 133           <description>
 134             <para>VarBinary</para>
 135           </description>
 136         </item>
 137         <item>
 138           <term>
 139             <para>
 140               <see cref="T:System.Data.SqlTypes.SqlGuid" /> </para>
 141           </term>
 142           <description>
 143             <para>uniqueidentifier</para>
 144           </description>
 145           <description>
 146             <para>UniqueIdentifier</para>
 147           </description>
 148         </item>
 149         <item>
 150           <term>
 151             <para>
 152               <see cref="T:System.Data.SqlTypes.SqlInt16" /> </para>
 153           </term>
 154           <description>
 155             <para>smallint</para>
 156           </description>
 157           <description>
 158             <para>SmallInt</para>
 159           </description>
 160         </item>
 161         <item>
 162           <term>
 163             <para>
 164               <see cref="T:System.Data.SqlTypes.SqlInt32" /> </para>
 165           </term>
 166           <description>
 167             <para>int</para>
 168           </description>
 169           <description>
 170             <para>Int</para>
 171           </description>
 172         </item>
 173         <item>
 174           <term>
 175             <para>
 176               <see cref="T:System.Data.SqlTypes.SqlInt64" /> </para>
 177           </term>
 178           <description>
 179             <para>bigint</para>
 180           </description>
 181           <description>
 182             <para>BigInt</para>
 183           </description>
 184         </item>
 185         <item>
 186           <term>
 187             <para>
 188               <see cref="T:System.Data.SqlTypes.SqlMoney" /> </para>
 189           </term>
 190           <description>
 191             <para>money, smallmoney</para>
 192           </description>
 193           <description>
 194             <para>Money, SmallMoney</para>
 195           </description>
 196         </item>
 197         <item>
 198           <term>
 199             <para>
 200               <see cref="T:System.Data.SqlTypes.SqlSingle" /> </para>
 201           </term>
 202           <description>
 203             <para>real</para>
 204           </description>
 205           <description>
 206             <para>Real</para>
 207           </description>
 208         </item>
 209         <item>
 210           <term>
 211             <para>
 212               <see cref="T:System.Data.SqlTypes.SqlString" /> </para>
 213           </term>
 214           <description>
 215             <para>char, nchar, text, ntext, nvarchar, varchar</para>
 216           </description>
 217           <description>
 218             <para>Char, NChar, Text, Ntext, NVarChar, VarChar</para>
 219           </description>
 220         </item>
 221         <item>
 222           <term>
 223             <para>
 224               <see cref="T:System.Data.SqlTypes.SqlXml" /> </para>
 225           </term>
 226           <description>
 227             <para>xml</para>
 228           </description>
 229           <description>
 230             <para>Xml</para>
 231           </description>
 232         </item>
 233       </list>
 234     </remarks>
 235   </Docs>
 236 </Namespace>