System.Data.SQLite: Check-in [789558b44e]

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

Overview

Comment:	Update mailing list addresses.
Downloads:	Tarball \| ZIP archive \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| nextRelease
Files:	files \| file ages \| folders
SHA1:	789558b44e990e06a55f10c7e08f78f50084f35e
User & Date:	mistachkin 2015-03-03 00:08:26

Context

2015-03-03
00:09		Cosmetic change to the previous check-in. check-in: 2eda4ee714 user: mistachkin tags: nextRelease
00:08		Update mailing list addresses. check-in: 789558b44e user: mistachkin tags: nextRelease
2015-03-02
23:11		When counting the number of tables in the GetSchemaTable method, do not include those that have a null or empty name. Fix for [92dbf1229a]. check-in: 154d609bbe user: mistachkin tags: nextRelease

Changes

Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to Doc/Extra/Provider/dbfactorysupport.html.

        cnn.ConnectionString = "Data Source=test.db3";
        cnn.Open();
      }</pre>
      </div>
      <hr>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Factory%20Support">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

        cnn.ConnectionString = "Data Source=test.db3";
        cnn.Open();
      }</pre>
      </div>
      <hr>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Factory%20Support">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/designer.html.

          Due to Visual Studio licensing restrictions, the Express Editions can no
          longer be supported.
        </font>
      </p>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Designer%20Support">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

          Due to Visual Studio licensing restrictions, the Express Editions can no
          longer be supported.
        </font>
      </p>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Designer%20Support">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/environment.html.

          type name that should be used when a per-connection value is not
          available.</td>
        </tr>
      </table>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Environment%20Variables">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

          type name that should be used when a per-connection value is not
          available.</td>
        </tr>
      </table>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Environment%20Variables">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/limitations.html.

        occur if one thread is attempting to read while another thread is attempting to
        write. Whichever thread got its lock first will be the one to execute, and the
        other thread will block until the CommandTimeout value elapses or the other
        thread finishes.</p>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Limitations">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

        occur if one thread is attempting to read while another thread is attempting to
        write. Whichever thread got its lock first will be the one to execute, and the
        other thread will block until the CommandTimeout value elapses or the other
        thread finishes.</p>
      <hr/>
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Limitations">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/optimizing.html.

      <p>Every database engine worth its salt utilizes prepared statements. If you're 
        not coding for this, you're not writing optimized SQL, and that's the bottom 
        line.
      </p>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Optimizing">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

      <p>Every database engine worth its salt utilizes prepared statements. If you're 
        not coding for this, you're not writing optimized SQL, and that's the bottom 
        line.
      </p>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Optimizing">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/version.html.

        <LI>
          Added support for user-defined collations.
        </LI>
      </UL>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Version%20History">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

        <LI>
          Added support for user-defined collations.
        </LI>
      </UL>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Version%20History">
            Send comments on this topic.</a>
        </p>
        <p>
        </p>
      </div>
    </div>
    </div>
  </body>
</html>

Changes to Doc/Extra/Provider/welcome.html.

        the System.Data.SQLite library (e.g. &quot;096&quot;).&nbsp; The
        <b>SQLite.Interop.XXX.DLL</b> file is a fully native assembly compiled for
        the ARM processor, and System.Data.SQLite is the fully-managed Compact
        Framework assembly.</p>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Welcome">
          Send comments on this topic.<!--[if gte IE 5]><tool:tip element="seeAlsoToolTip" avoidmouse="false" /><tool:tip element="languageFilterToolTip" avoidmouse="false" /><![endif]-->    </div>
    </div>
  </body>
</html>

        the System.Data.SQLite library (e.g. &quot;096&quot;).&nbsp; The
        <b>SQLite.Interop.XXX.DLL</b> file is a fully native assembly compiled for
        the ARM processor, and System.Data.SQLite is the fully-managed Compact
        Framework assembly.</p>
      <hr />
      <div id="footer">
        <p>
          <a href="mailto:sqlite-users@mailinglists.sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Welcome">
          Send comments on this topic.<!--[if gte IE 5]><tool:tip element="seeAlsoToolTip" avoidmouse="false" /><tool:tip element="languageFilterToolTip" avoidmouse="false" /><![endif]-->    </div>
    </div>
  </body>
</html>

Changes to Doc/SQLite.NET.ndoc.

            <property name="HtmlHelpName" value="SQLite.NET" />
            <property name="Title" value="SQLite ADO.NET Provider" />
            <property name="Version" value="" />
            <property name="OutputTarget" value="HtmlHelp" />
            <property name="BinaryTOC" value="False" />
            <property name="AdditionalContentResourceDirectory" value=".\Extra\" />
            <property name="AssemblyVersionInfo" value="AssemblyVersion" />
            <property name="FeedbackEmailAddress" value="sqlite-users@sqlite.org" />
            <property name="SdkDocVersion" value="SDK_v3_5" />
            <property name="SdkDocVersionString" value="VS.90" />
            <property name="DocumentAttributes" value="False" />
            <property name="IncludeDefaultThreadSafety" value="False" />
        </documenter>
    </documenters>
</project>

            <property name="HtmlHelpName" value="SQLite.NET" />
            <property name="Title" value="SQLite ADO.NET Provider" />
            <property name="Version" value="" />
            <property name="OutputTarget" value="HtmlHelp" />
            <property name="BinaryTOC" value="False" />
            <property name="AdditionalContentResourceDirectory" value=".\Extra\" />
            <property name="AssemblyVersionInfo" value="AssemblyVersion" />
            <property name="FeedbackEmailAddress" value="sqlite-users@mailinglists.sqlite.org" />
            <property name="SdkDocVersion" value="SDK_v3_5" />
            <property name="SdkDocVersionString" value="VS.90" />
            <property name="DocumentAttributes" value="False" />
            <property name="IncludeDefaultThreadSafety" value="False" />
        </documenter>
    </documenters>
</project>

Changes to SQLite.Designer/Editors/TableDesignerDoc.cs.

      {
        case __FRAMESHOW.FRAMESHOW_WinShown:
        case __FRAMESHOW.FRAMESHOW_WinRestored:
          SetPropertyWindow();
          if (_warned == false)
          {
            _warned = true;
            MessageBox.Show(this, "The table designer is still in development.  Please report bugs to the sqlite-users mailing list at sqlite-users@sqlite.org", "Feature Under Review", MessageBoxButtons.OK);
          }
          break;
      }
      return VSConstants.S_OK;
    }

    int IVsWindowFrameNotify.OnSize()

      {
        case __FRAMESHOW.FRAMESHOW_WinShown:
        case __FRAMESHOW.FRAMESHOW_WinRestored:
          SetPropertyWindow();
          if (_warned == false)
          {
            _warned = true;
            MessageBox.Show(this, "The table designer is still in development.  Please report bugs to the sqlite-users mailing list at sqlite-users@mailinglists.sqlite.org", "Feature Under Review", MessageBoxButtons.OK);
          }
          break;
      }
      return VSConstants.S_OK;
    }

    int IVsWindowFrameNotify.OnSize()

Changes to SQLite.Designer/Editors/ViewDesignerDoc.cs.

        case __FRAMESHOW.FRAMESHOW_WinShown:
        case __FRAMESHOW.FRAMESHOW_WinRestored:
          _timer.Enabled = true;
          SetPropertyWindow();
          if (_warned == false)
          {
            _warned = true;
            MessageBox.Show(this, "The view designer is still in development.  Please report bugs to the sqlite-users mailing list at sqlite-users@sqlite.org", "Feature Under Review", MessageBoxButtons.OK);
          }
          break;
      }
      return VSConstants.S_OK;
    }

    int IVsWindowFrameNotify.OnSize()

        case __FRAMESHOW.FRAMESHOW_WinShown:
        case __FRAMESHOW.FRAMESHOW_WinRestored:
          _timer.Enabled = true;
          SetPropertyWindow();
          if (_warned == false)
          {
            _warned = true;
            MessageBox.Show(this, "The view designer is still in development.  Please report bugs to the sqlite-users mailing list at sqlite-users@mailinglists.sqlite.org", "Feature Under Review", MessageBoxButtons.OK);
          }
          break;
      }
      return VSConstants.S_OK;
    }

    int IVsWindowFrameNotify.OnSize()

Changes to www/contribute.wiki.

implementation of the same feature being prepared separately.

<h2>3.0 Check-in Privileges</h2>

Check-in privileges are granted on a case-by-case basis.   Your chances
of getting check-in privileges are much improved if you have a history
of submitting quality patches and/or making thoughtful posts on the
[https://www.mail-archive.com/sqlite-users@sqlite.org/ | mailing list].
A contributor agreement is, of course, a prerequisite for check-in
privileges.</p>

Contributors are asked to make all non-trivial changes on a branch.  A
System.Data.SQLite admin will review the branch and merge the changes
into the trunk.</p>

implementation of the same feature being prepared separately.

<h2>3.0 Check-in Privileges</h2>

Check-in privileges are granted on a case-by-case basis.   Your chances
of getting check-in privileges are much improved if you have a history
of submitting quality patches and/or making thoughtful posts on the
[https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/ | mailing list].
A contributor agreement is, of course, a prerequisite for check-in
privileges.</p>

Contributors are asked to make all non-trivial changes on a branch.  A
System.Data.SQLite admin will review the branch and merge the changes
into the trunk.</p>

Changes to www/support.wiki.

<p>
  Three separate mailing lists have been established to help support SQLite and
  System.Data.SQLite:
</p>

<ul>
  <li>
    <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
    sqlite-announce</a> - announcements of new releases or significant
    developments.
  </li>

  <li>
    <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
    sqlite-users</a> - general user discussion; most postings belong here.
  </li>

  <li>
    <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
    sqlite-dev</a> - developer conversations; for people who have or aspire to
    have write permission on the SQLite and/or System.Data.SQLite source code
    repositories.
  </li>
</ul>

<p>
  Most users of SQLite and/or System.Data.SQLite will want to join the
  <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
  sqlite-announce</a> list and many will want to join the
  <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
  sqlite-users</a> list.  The
  <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
  sqlite-dev</a> list is more specialized and appeals to a narrower audience.
  Off-site archives of the
  <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
  sqlite-users</a> list are available at:
</p>

<ul>
  <li>
    <a href="https://www.mail-archive.com/sqlite-users%40sqlite.org/">
    https://www.mail-archive.com/sqlite-users%40sqlite.org/</a>







  </li>

  <li>
    <a href="https://marc.info/?l=sqlite-users&r=1&w=2">
    https://marc.info/?l=sqlite-users&r=1&w=2</a>
  </li>








|





|




|








|

|

|


|







>
>
>
>
>
>
>

<p>
  Three separate mailing lists have been established to help support SQLite and
  System.Data.SQLite:
</p>

<ul>
  <li>
    <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-announce">
    sqlite-announce</a> - announcements of new releases or significant
    developments.
  </li>

  <li>
    <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users">
    sqlite-users</a> - general user discussion; most postings belong here.
  </li>

  <li>
    <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev">
    sqlite-dev</a> - developer conversations; for people who have or aspire to
    have write permission on the SQLite and/or System.Data.SQLite source code
    repositories.
  </li>
</ul>

<p>
  Most users of SQLite and/or System.Data.SQLite will want to join the
  <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-announce">
  sqlite-announce</a> list and many will want to join the
  <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users">
  sqlite-users</a> list.  The
  <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev">
  sqlite-dev</a> list is more specialized and appeals to a narrower audience.
  Off-site archives of the
  <a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users">
  sqlite-users</a> list are available at:
</p>

<ul>
  <li>
    <a href="https://www.mail-archive.com/sqlite-users%40sqlite.org/">
    https://www.mail-archive.com/sqlite-users%40sqlite.org/</a>
    (<b>Old Address, before mid-February 2015</b>)
  </li>

  <li>
    <a href="https://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/">
    https://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/</a>
    (<b>New Address, after mid-February 2015</b>)
  </li>

  <li>
    <a href="https://marc.info/?l=sqlite-users&r=1&w=2">
    https://marc.info/?l=sqlite-users&r=1&w=2</a>
  </li>