System.Data.SQLite
Check-in [ad2b42f3cc]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Support automatic value conversions for columns with a declared type of INTEGER8, INTEGER16, INTEGER32, INTEGER64, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, or UINT64.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ad2b42f3cc86f9caa68e79aa5c7b7330cd18e036
User & Date: mistachkin 2013-01-30 01:00:10
References
2013-01-30
16:08 Ticket [c010fa6584] Sign extension of unsigned 32-bit numbers. status still Open with 3 other changes artifact: 76ffbd1135 user: anonymous
01:02 Ticket [c010fa6584]: 3 changes artifact: 522172f15b user: mistachkin
Context
2013-01-30
21:38
Avoid trying to use SleepEx on Windows CE. check-in: a7c52f8f33 user: mistachkin tags: trunk
01:00
Support automatic value conversions for columns with a declared type of INTEGER8, INTEGER16, INTEGER32, INTEGER64, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, or UINT64. check-in: ad2b42f3cc user: mistachkin tags: trunk
2013-01-29
03:34
Remove superfluous 'using' statements from some tests. check-in: 0ca77b6031 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/version.html.

    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.85.0 - March XX, 2013 <font color="red">(release scheduled)</font></b></p>
    47     47       <ul>
    48     48         <li>Updated to <a href="http://www.sqlite.org/src/info/trunk">SQLite 3.7.16</a>.</li>
    49     49         <li>Add static Execute method to the SQLiteCommand class.</li>
    50     50         <li>Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.</li>
    51     51         <li>When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.</li>
           52  +      <li>Support automatic value conversions for columns with a declared type of INTEGER8, INTEGER16, INTEGER32, INTEGER64, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, or UINT64.</li>
    52     53       </ul>
    53     54       <p><b>1.0.84.0 - January 9, 2013</b></p>
    54     55       <ul>
    55     56         <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_15_2.html">SQLite 3.7.15.2</a>.</li>
    56     57         <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for <a href="http://system.data.sqlite.org/index.html/info/6434e23a0f">[6434e23a0f]</a>.</li>
    57     58         <li>Add Cancel method to the SQLiteConnection class to interrupt a long running query.</li>
    58     59         <li>Improve thread safety of the SQLiteLog.LogMessage method.</li>

Changes to System.Data.SQLite/SQLiteConvert.cs.

   745    745   #endif
   746    746   
   747    747         return defaultTypeName;
   748    748       }
   749    749   
   750    750       private static SQLiteTypeNames[] _dbtypeNames = {
   751    751         new SQLiteTypeNames("INTEGER", DbType.Int64),
          752  +      new SQLiteTypeNames("INTEGER8", DbType.SByte),
          753  +      new SQLiteTypeNames("INTEGER16", DbType.Int16),
          754  +      new SQLiteTypeNames("INTEGER32", DbType.Int32),
          755  +      new SQLiteTypeNames("INTEGER64", DbType.Int64),
          756  +      new SQLiteTypeNames("UNSIGNEDINTEGER", DbType.UInt64),
          757  +      new SQLiteTypeNames("UNSIGNEDINTEGER8", DbType.Byte),
          758  +      new SQLiteTypeNames("UNSIGNEDINTEGER16", DbType.UInt16),
          759  +      new SQLiteTypeNames("UNSIGNEDINTEGER32", DbType.UInt32),
          760  +      new SQLiteTypeNames("UNSIGNEDINTEGER64", DbType.UInt64),
   752    761         new SQLiteTypeNames("TINYINT", DbType.Byte),
   753    762         new SQLiteTypeNames("INT", DbType.Int32),
          763  +      new SQLiteTypeNames("INT8", DbType.SByte),
          764  +      new SQLiteTypeNames("INT16", DbType.Int16),
          765  +      new SQLiteTypeNames("INT32", DbType.Int32),
          766  +      new SQLiteTypeNames("INT64", DbType.Int64),
          767  +      new SQLiteTypeNames("UINT", DbType.UInt32),
          768  +      new SQLiteTypeNames("UINT8", DbType.Byte),
          769  +      new SQLiteTypeNames("UINT16", DbType.UInt16),
          770  +      new SQLiteTypeNames("UINT32", DbType.UInt32),
          771  +      new SQLiteTypeNames("UINT64", DbType.UInt64),
   754    772         new SQLiteTypeNames("VARCHAR", DbType.AnsiString),
   755    773         new SQLiteTypeNames("NVARCHAR", DbType.String),
   756    774         new SQLiteTypeNames("CHAR", DbType.AnsiStringFixedLength),
   757    775         new SQLiteTypeNames("NCHAR", DbType.StringFixedLength),
   758    776         new SQLiteTypeNames("FLOAT", DbType.Double),
   759    777         new SQLiteTypeNames("REAL", DbType.Double),
   760    778         new SQLiteTypeNames("BIT", DbType.Boolean),
................................................................................
   863    881                 new SQLiteTypeNames("IDENTITY", DbType.Int64),
   864    882                 new SQLiteTypeNames("LONGTEXT", DbType.String),
   865    883                 new SQLiteTypeNames("LONGCHAR", DbType.String),
   866    884                 new SQLiteTypeNames("LONGVARCHAR", DbType.String),
   867    885                 new SQLiteTypeNames("LONG", DbType.Int64),
   868    886                 new SQLiteTypeNames("TINYINT", DbType.Byte),
   869    887                 new SQLiteTypeNames("INTEGER", DbType.Int64),
          888  +              new SQLiteTypeNames("INTEGER8", DbType.SByte),
          889  +              new SQLiteTypeNames("INTEGER16", DbType.Int16),
          890  +              new SQLiteTypeNames("INTEGER32", DbType.Int32),
          891  +              new SQLiteTypeNames("INTEGER64", DbType.Int64),
          892  +              new SQLiteTypeNames("UNSIGNEDINTEGER", DbType.UInt64),
          893  +              new SQLiteTypeNames("UNSIGNEDINTEGER8", DbType.Byte),
          894  +              new SQLiteTypeNames("UNSIGNEDINTEGER16", DbType.UInt16),
          895  +              new SQLiteTypeNames("UNSIGNEDINTEGER32", DbType.UInt32),
          896  +              new SQLiteTypeNames("UNSIGNEDINTEGER64", DbType.UInt64),
   870    897                 new SQLiteTypeNames("INT", DbType.Int32),
          898  +              new SQLiteTypeNames("INT8", DbType.SByte),
          899  +              new SQLiteTypeNames("INT16", DbType.Int16),
          900  +              new SQLiteTypeNames("INT32", DbType.Int32),
          901  +              new SQLiteTypeNames("INT64", DbType.Int64),
          902  +              new SQLiteTypeNames("UINT", DbType.UInt32),
          903  +              new SQLiteTypeNames("UINT8", DbType.Byte),
          904  +              new SQLiteTypeNames("UINT16", DbType.UInt16),
          905  +              new SQLiteTypeNames("UINT32", DbType.UInt32),
          906  +              new SQLiteTypeNames("UINT64", DbType.UInt64),
   871    907                 new SQLiteTypeNames("VARCHAR", DbType.String),
   872    908                 new SQLiteTypeNames("NVARCHAR", DbType.String),
   873    909                 new SQLiteTypeNames("CHAR", DbType.String),
   874    910                 new SQLiteTypeNames("NCHAR", DbType.String),
   875    911                 new SQLiteTypeNames("TEXT", DbType.String),
   876    912                 new SQLiteTypeNames("NTEXT", DbType.String),
   877    913                 new SQLiteTypeNames("STRING", DbType.String),

Changes to readme.htm.

   190    190       <b>1.0.85.0 - March XX, 2013 <font color="red">(release scheduled)</font></b>
   191    191   </p>
   192    192   <ul>
   193    193       <li>Updated to <a href="http://www.sqlite.org/src/info/trunk">SQLite 3.7.16</a>.</li>
   194    194       <li>Add static Execute method to the SQLiteCommand class.</li>
   195    195       <li>Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.</li>
   196    196       <li>When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.</li>
          197  +    <li>Support automatic value conversions for columns with a declared type of INTEGER8, INTEGER16, INTEGER32, INTEGER64, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, or UINT64.</li>
   197    198   </ul>
   198    199   <p>
   199    200       <b>1.0.84.0 - January 9, 2013</b>
   200    201   </p>
   201    202   <ul>
   202    203       <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_15_2.html">SQLite 3.7.15.2</a>.</li>
   203    204       <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].</li>

Changes to www/news.wiki.

     6      6       <b>1.0.85.0 - March XX, 2013 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9      9       <li>Updated to [http://www.sqlite.org/src/info/trunk|SQLite 3.7.16].</li>
    10     10       <li>Add static Execute method to the SQLiteCommand class.</li>
    11     11       <li>Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.</li>
    12     12       <li>When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.</li>
           13  +    <li>Support automatic value conversions for columns with a declared type of INTEGER8, INTEGER16, INTEGER32, INTEGER64, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, or UINT64.</li>
    13     14   </ul>
    14     15   <p>
    15     16       <b>1.0.84.0 - January 9, 2013</b>
    16     17   </p>
    17     18   <ul>
    18     19       <li>Updated to [http://www.sqlite.org/releaselog/3_7_15_2.html|SQLite 3.7.15.2].</li>
    19     20       <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].</li>