Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | 1.0.17 readme |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | sourceforge |
Files: | files | file ages | folders |
SHA1: |
e4ddf884bb4ae290b39b086edae36812 |
User & Date: | rmsimpson 2005-08-27 23:18:39.000 |
Context
2005-08-27
| ||
23:18 | 1.0.17 check-in: e32ca9884b user: rmsimpson tags: sourceforge | |
23:18 | 1.0.17 readme check-in: e4ddf884bb user: rmsimpson tags: sourceforge | |
23:17 | Added itanium and x64 platform build settings check-in: 065c6034ae user: rmsimpson tags: sourceforge | |
Changes
Changes to readme.htm.
1 2 3 4 5 6 7 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET 2.0 SQLite Data Provider<br> | | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET 2.0 SQLite Data Provider<br> Version 1.0.17- Aug 27, 2005<br> Interop using SQLite 3.2.5<br> Written by Robert Simpson (<a href="mailto:robert@blackcastlesoft.com">robert@blackcastlesoft.com</a>)<br> Released to the public domain, use at your own risk!<br> <br> This provider was written and tested using the Visual Studio 2005 Beta 2 release.<br> <br> The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2"> |
︙ | ︙ | |||
31 32 33 34 35 36 37 | app.config level. <li> Full support for ATTACH'ed databases. Exposed as <i>Catalogs</i> in the schema. When cloning a connection, all attached databases are automatically re-attached to the new connection. <li> DbConnection.GetSchema(...) support includes the <i>MetaDataCollections</i>, <i>DataSourceInformation</i>, | | | | | > | > > | 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 | app.config level. <li> Full support for ATTACH'ed databases. Exposed as <i>Catalogs</i> in the schema. When cloning a connection, all attached databases are automatically re-attached to the new connection. <li> DbConnection.GetSchema(...) support includes the <i>MetaDataCollections</i>, <i>DataSourceInformation</i>, <i>Columns</i>, <i>Tables</i>, <i>Views, ViewColumns, </i><i>Catalogs, </i><i>Indexes, IndexColumns </i>and <em>ForeignKeys</em> keywords. <li> Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace and detailed schema information even for complex queries. <li> Named and unnamed parameters. <li> Full UTF-8 and UTF-16 support, each with optimized pipelines into the native database core. <li> Multiple simultaneous DataReaders (one DataReader per Command however). <li> Full support for user-defined scalar and aggregate functions, encapsulated into an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions. <li> Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class.</li> <li>Create and encrypt databases using Win2K+ Encrypting File System (EFS). Supports creating NTFS compressed database files.</li> </ul> <strong></strong> <h2> <strong>Design-Time Support (new as of 1.0.14)</strong></h2> <P>Until an installer is created, the steps for registering the provider for design-time support are:</P> <OL> <LI> |
︙ | ︙ | |||
83 84 85 86 87 88 89 | either your application's app.config or the system's machine.config located in the %SystemRoot%\Microsoft.Net\Framework\v2.xxxx\Config folder:<br> <br> <pre> <configuration> <system.data> <DbProviderFactories> | | | 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 | either your application's app.config or the system's machine.config located in the %SystemRoot%\Microsoft.Net\Framework\v2.xxxx\Config folder:<br> <br> <pre> <configuration> <system.data> <DbProviderFactories> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"<BR > type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.16.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data> </configuration> </pre> <P>If you choose to install the Visual Studio Design-Time support for SQLite, you must not add the above XML to your app.config. The installer will have already added it to your machine's machine.config file.</P> |
︙ | ︙ | |||
151 152 153 154 155 156 157 158 159 | <li> <FONT color="silver">Compile it. </FONT> </li> </ol> <b></b> <h2> <b>Version History</b></h2> <b>1.0.16 - August 24, 2005</b><br> <ul> | > > > > > > > > > > > > > > > > > | > > | > | > | > | | 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 | <li> <FONT color="silver">Compile it. </FONT> </li> </ol> <b></b> <h2> <b>Version History</b></h2> <b>1.0.17 - August 27, 2005</b><br> <ul> <li> Code merge with SQLite 3.2.5 <li>Added Itanium and x64 build settings to the project (needs testing) <li> Bugfixes and enhancements to several schema types <li> Additional design-time support to include index and foreign key enumerations. Requires re-registering the designer using INSTALL.CMD. The new designer code now allows the VS query designer and typed datasets to automatically link up foreign keys, use indexes, and automatically generate relationships from the schema.<li> Additional static methods on SQLiteConnection to create a database file, encrypt a file using the Encrypted File System (EFS) on NTFS (requires NT 2K or above) and NTFS file compression</li> </ul> <b>1.0.16 - August 24, 2005</b><br> <ul> <li> Code merge with SQLite 3.2.4 with the large delete bugfix in CVS (which will become 3.2.5 soon) <li> Added new GetSchema() types: IndexColumns, ViewColumns, ForeignKeys</li> </ul> <b>1.0.15 - August 22, 2005</b><br> <ul> <li> Code merge with SQLite 3.2.3 <LI> Minor updates for better design-time experience. More design-time code to follow in subsequent releases.</LI> </ul> <b>1.0.14 - August 16, 2005</b><br> <ul> <li> Fixed a bug in the SQLiteDataAdapter due to insufficient implementation of the class. The RowUpdating and RowUpdated events are now properly implemented, but unfortunately inserting and updating data in a DataTable or DataSet is now much slower. This is the proper design however, so the |
︙ | ︙ |