System.Data.SQLite

Check-in [e35dd9e966]
Login

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

Overview
Comment:Improve NuGet package descriptions on the FAQ and download pages.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e35dd9e9664d76cc9ea9526c702e16716f444062
User & Date: mistachkin 2015-08-21 01:36:20.345
Context
2015-08-21
19:53
Sync up extended error codes with the SQLite core library. check-in: c6cacbbfa5 user: mistachkin tags: trunk
01:36
Improve NuGet package descriptions on the FAQ and download pages. check-in: e35dd9e966 user: mistachkin tags: trunk
2015-08-20
18:30
Update the downloads page. check-in: 7a0650058f user: mistachkin tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to www/downloads.wiki.
︙︙
2203
2204
2205
2206
2207
2208
2209

2210
2211
2212
2213
2214
2215
2216
2217

        versions of System.Data.SQLite 1.0.98.0 (3.8.11.1).  The .NET Framework
        3.5 SP1, 4.0, 4.5, 4.5.1, 4.5.2, or 4.6 is required.  For the included
        native binaries, the version of the Visual C++ runtime corresponding to
        the .NET Framework used by the associated managed assembly is statically
        linked.
        <br />
        <big><b>This package depends on the &quot;EntityFramework&quot;

        package.</b></big>
        <br />
        <br />
        <big><b><i>As of version 1.0.92.0, this package will not directly
        contain any of the required binaries.  Instead, this package will
        depend on the &quot;System.Data.SQLite.Core&quot;,
        &quot;System.Data.SQLite.Linq&quot;, and
        &quot;System.Data.SQLite.EF6&quot; packages.</i></b></big>








>
|








2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218

        versions of System.Data.SQLite 1.0.98.0 (3.8.11.1).  The .NET Framework
        3.5 SP1, 4.0, 4.5, 4.5.1, 4.5.2, or 4.6 is required.  For the included
        native binaries, the version of the Visual C++ runtime corresponding to
        the .NET Framework used by the associated managed assembly is statically
        linked.
        <br />
        <big><b>This package depends on the &quot;EntityFramework&quot;
        package, version 6.0 or higher (indirectly via the
        &quot;System.Data.SQLite.EF6&quot; package).</b></big>
        <br />
        <br />
        <big><b><i>As of version 1.0.92.0, this package will not directly
        contain any of the required binaries.  Instead, this package will
        depend on the &quot;System.Data.SQLite.Core&quot;,
        &quot;System.Data.SQLite.Linq&quot;, and
        &quot;System.Data.SQLite.EF6&quot; packages.</i></b></big>
︙︙
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295

      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support Entity
        Framework 6 using System.Data.SQLite 1.0.98.0 (3.8.11.1).  The .NET
        Framework 4.0, 4.5, 4.5.1, 4.5.2, or 4.6 is required.
        <br />
        <big><b>This package depends on the &quot;EntityFramework&quot;
        package.</b></big>
        <br />
        (sha1: 741d1e08ce801f9770edd1706e10d4c5284b403e)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>








|








2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296

      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support Entity
        Framework 6 using System.Data.SQLite 1.0.98.0 (3.8.11.1).  The .NET
        Framework 4.0, 4.5, 4.5.1, 4.5.2, or 4.6 is required.
        <br />
        <big><b>This package depends on the &quot;EntityFramework&quot;
        package, version 6.0 or higher.</b></big>
        <br />
        (sha1: 741d1e08ce801f9770edd1706e10d4c5284b403e)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
︙︙
Changes to www/faq.wiki.
︙︙
215
216
217
218
219
220
221
222
223
224
225
226
227
228


229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293





294






295
296
297
298
299


300



301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319





320
321





322
323
324
325
326
327
328
329
330
331
332
333

334




335
336
337
338
339
340
341
342
343
344
345
346
347
348










349




350
351
352
353
354
355
356

  <b>no longer</b> supported for the Express editions due to licensing
  restrictions.
</p>

<hr>
<a name="q5"></a>
<p>
  <b>(5) Is there a NuGet package?</b>
</p>

<p>
  Yes, the following official NuGet packages are available:

  <ul>


    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite">
      System.Data.SQLite</a>: The SQLite database engine for both x86 and x64
      along with the ADO.NET provider, including support for LINQ and Entity
      Framework 6.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Beta">
      System.Data.SQLite.Beta</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider, including support for LINQ
      and Entity Framework 6.  <br><b>This package may contain &quot;beta&quot;
      code and is not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core">
      System.Data.SQLite.Core</a>: The SQLite database engine for both x86 and
      x64 along with the ADO.NET provider.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Beta">
      System.Data.SQLite.Core.Beta</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider.  <br><b>This package may contain
      &quot;beta&quot; code and is not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Test">
      System.Data.SQLite.Core.Test</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider.  <br><b>This package may contain
      pre-release code and is not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL">
      System.Data.SQLite.Core.MSIL</a>: Just the managed ADO.NET provider for
      SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Beta">
      System.Data.SQLite.Core.MSIL.Beta</a>: Just the managed ADO.NET provider
      for SQLite.  <br><b>This package may contain &quot;beta&quot; code and is
      not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Test">
      System.Data.SQLite.Core.MSIL.Test</a>: Just the managed ADO.NET provider
      for SQLite.  <br><b>This package may contain pre-release code and is not
      intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6">
      System.Data.SQLite.EF6</a>: Just support for Entity Framework 6 using
      System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Beta">
      System.Data.SQLite.EF6.Beta</a>: Just support for Entity Framework 6
      using System.Data.SQLite.  <br><b>This package may contain





      &quot;beta&quot; code and is not intended for production use.</b>






    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Test">
      System.Data.SQLite.EF6.Test</a>: Just support for Entity Framework 6


      using System.Data.SQLite.  <br><b>This package may contain pre-release



      code and is not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq">
      System.Data.SQLite.Linq</a>: Just support for LINQ using
      System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Beta">
      System.Data.SQLite.Linq.Beta</a>: Just support for LINQ using
      System.Data.SQLite.  <br><b>This package may contain &quot;beta&quot;
      code and is not intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Test">
      System.Data.SQLite.Linq.Test</a>: Just support for LINQ using





      System.Data.SQLite.  <br><b>This package may contain pre-release code
      and is not intended for production use.</b>





    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL">
      System.Data.SQLite.MSIL</a>: Just the managed ADO.NET provider for
      SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Beta">
      System.Data.SQLite.MSIL.Beta</a>: Just the managed ADO.NET provider for
      SQLite.  <br><b>This package may contain &quot;beta&quot; code and is

      not intended for production use.</b>




    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Test">
      System.Data.SQLite.MSIL.Test</a>: Just the managed ADO.NET provider for
      SQLite.  <br><b>This package may contain pre-release code and is not
      intended for production use.</b>
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Test">
      System.Data.SQLite.Test</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider, including support for LINQ
      and Entity Framework 6.  <br><b>This package may contain pre-release










      code and is not intended for production use.</b>




    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.x86">
      System.Data.SQLite.x86</a>: The SQLite database engine combined with a
      complete ADO.NET provider all rolled into a single mixed-mode assembly
      for x86.








|



<
|

>
>







<
<
<
<
<
<
<
<






<
<
<
<
<
<
<
<
<
<
<
<
<
<






<
<
<
<
<
<
<
<
<
<
<
<
<
<







|
|
|
>
>
>
>
>
|
>
>
>
>
>
>



|
|
>
>
|
>
>
>
|



|
|
|





|
<



|
|
>
>
>
>
>
|
|
>
>
>
>
>



|
|
|



|
|
|
>
|
>
>
>
>





|
<






|
>
>
>
>
>
>
>
>
>
>
|
>
>
>
>








215
216
217
218
219
220
221
222
223
224
225

226
227
228
229
230
231
232
233
234
235
236








237
238
239
240
241
242














243
244
245
246
247
248














249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294

295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335

336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364

  <b>no longer</b> supported for the Express editions due to licensing
  restrictions.
</p>

<hr>
<a name="q5"></a>
<p>
  <b>(5) Are NuGet packages available?</b>
</p>

<p>

  Yes.
  <ul>
    <b>These are the primary NuGet packages:</b>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite">
      System.Data.SQLite</a>: The SQLite database engine for both x86 and x64
      along with the ADO.NET provider, including support for LINQ and Entity
      Framework 6.
    </li>









    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core">
      System.Data.SQLite.Core</a>: The SQLite database engine for both x86 and
      x64 along with the ADO.NET provider.
    </li>















    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL">
      System.Data.SQLite.Core.MSIL</a>: Just the managed ADO.NET provider for
      SQLite.
    </li>















    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6">
      System.Data.SQLite.EF6</a>: Just support for Entity Framework 6 using
      System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq">
      System.Data.SQLite.Linq</a>: Just support for LINQ using
      System.Data.SQLite.
    </li>
  </ul>
  <br>
  <ul>
    <b>These NuGet packages may contain &quot;beta&quot; code and are not
    intended for production use.</b>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Beta">
      System.Data.SQLite.Beta</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider, including support for LINQ
      and Entity Framework 6.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Beta">
      System.Data.SQLite.Core.Beta</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Beta">
      System.Data.SQLite.Core.MSIL.Beta</a>: Just the managed ADO.NET provider
      for SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Beta">
      System.Data.SQLite.EF6.Beta</a>: Just support for Entity Framework 6
      using System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Beta">
      System.Data.SQLite.Linq.Beta</a>: Just support for LINQ using
      System.Data.SQLite.

    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Beta">
      System.Data.SQLite.MSIL.Beta</a>: Just the managed ADO.NET provider for
      SQLite.
    </li>
  </ul>
  <br>
  <ul>
    <b>These NuGet packages may contain pre-release code and are not intended
    for production use.</b>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Test">
      System.Data.SQLite.Core.Test</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Test">
      System.Data.SQLite.Core.MSIL.Test</a>: Just the managed ADO.NET provider
      for SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Test">
      System.Data.SQLite.EF6.Test</a>: Just support for Entity Framework 6
      using System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Test">
      System.Data.SQLite.Linq.Test</a>: Just support for LINQ using
      System.Data.SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Test">
      System.Data.SQLite.MSIL.Test</a>: Just the managed ADO.NET provider for
      SQLite.

    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.Test">
      System.Data.SQLite.Test</a>: The SQLite database engine for both x86
      and x64 along with the ADO.NET provider, including support for LINQ
      and Entity Framework 6.
    </li>
  </ul>
  <br>
  <ul>
    <b>Finally, there are legacy NuGet packages for backwards compatibility.
    If possible, projects using these should be updated to use either the
    &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;
    package instead of using these legacy packages.  These legacy NuGet
    packages should not be used for new projects and may stop receiving
    updates in the future.</b>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL">
      System.Data.SQLite.MSIL</a>: Just the managed ADO.NET provider for
      SQLite.
    </li>

    <li>
      <a href="https://www.nuget.org/packages/System.Data.SQLite.x86">
      System.Data.SQLite.x86</a>: The SQLite database engine combined with a
      complete ADO.NET provider all rolled into a single mixed-mode assembly
      for x86.
︙︙