System.Data.SQLite

Check-in [789558b44e]
Login

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

Overview
Comment:Update mailing list addresses.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | nextRelease
Files: files | file ages | folders
SHA1: 789558b44e990e06a55f10c7e08f78f50084f35e
User & Date: mistachkin 2015-03-03 00:08:26.028
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
Unified Diff Ignore Whitespace Patch
Changes to Doc/Extra/Provider/dbfactorysupport.html.
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
        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>







|







101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
        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>
Changes to Doc/Extra/Provider/designer.html.
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
          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>







|







61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
          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>
Changes to Doc/Extra/Provider/environment.html.
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
          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>







|







191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
          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>
Changes to Doc/Extra/Provider/limitations.html.
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
        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>







|







94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
        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>
Changes to Doc/Extra/Provider/optimizing.html.
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
      <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>







|







118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
      <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>
Changes to Doc/Extra/Provider/version.html.
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
        <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>







|







1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
        <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>
Changes to Doc/Extra/Provider/welcome.html.
163
164
165
166
167
168
169
170
171
172
173
174
        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>







|




163
164
165
166
167
168
169
170
171
172
173
174
        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.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
            <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>







|







11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
            <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.
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
      {
        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()







|







795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
      {
        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.
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
        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()







|







564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
        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.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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>








|







38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52







53
54
55
56
57
58
59
<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>








|





|




|








|

|

|


|







>
>
>
>
>
>
>







11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<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>