System.Data.SQLite

All files named ”System.Data.SQLite/SQLiteConvert.cs”
Login

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

History for System.Data.SQLite/SQLiteConvert.cs

2025-01-18
03:51
Fix a typo in the previous check-in. file: [48c9845456] check-in: [ae10148ec8] user: mistachkin branch: trunk, size: 113661
2024-12-11
03:32
Add experimental support for the 'Binary' DateTime format. file: [aff871c726] check-in: [fa96f58515] user: mistachkin branch: trunk, size: 113680
2024-11-19
18:01
Preliminary work on adding more 'Changed' event types. file: [75fd2c88ad] check-in: [a55cf38927] user: mistachkin branch: trunk, size: 112488
2024-08-11
23:25
Expose the SQLiteConvert.TypeToDbType method. file: [3e2e576252] check-in: [2fa3ceabad] user: mistachkin branch: trunk, size: 111781
2024-06-29
01:41
Fix minor bug in a new method caused by a typo. file: [b7366ee8ce] check-in: [57d6cf2744] user: mistachkin branch: trunk, size: 111470
2024-06-26
16:26
Add support for the 'SQLite_TraceCategories' environment variable. file: [fe6af8b8e2] check-in: [37849c1af4] user: mistachkin branch: trunk, size: 111444
2024-05-31
04:46
Add support for the DataReaderPreview event type. file: [7e3c27fbf7] check-in: [5d0156f7f6] user: mistachkin branch: trunk, size: 111390
2023-07-07
16:46
Revise how 'shared' define constants / compile-time options are handled. file: [823d90f247] check-in: [b6d571be01] user: mistachkin branch: trunk, size: 111218
2023-01-18
05:09
Add the SqlStringPreview connection event type. file: [15086d6c5e] check-in: [4188296299] user: mistachkin branch: trunk, size: 110018
2023-01-10
15:40
Preliminary changes to add a couple new events. file: [57eb4409a6] check-in: [6ea27254da] user: mistachkin branch: trunk, size: 109901
2022-10-10
19:37
Minor coding style improvements to the internal JD computation method. file: [9a5024c4b9] check-in: [055bb6ae4d] user: mistachkin branch: trunk, size: 109629
2022-07-06
00:48
Enhancements to the SQLiteConnection.Changed event. Cleanup several tests. Pursuant to [ce4d70ea6f]. file: [7c8ebf9cde] check-in: [50a09e2598] user: mistachkin branch: trunk, size: 109286
2021-10-11
01:09
Initial work on a way to handle 'database is busy' events via wrapping the native 'sqlite3_busy_handler' API. file: [edfc1c4ad3] check-in: [2541fcec64] user: mistachkin branch: trunk, size: 108594
2020-10-29
02:46
Re-add preliminary support for the .NET Framework 4.8. file: [a49b3e070a] check-in: [3ede7fccc6] user: mistachkin branch: trunk, size: 108093
2020-09-23
00:13
Make use of the Marshal.PtrToStringUTF8 method provided by the .NET Standard 2.1. Pursuant to [d3b877c7e0]. file: [ba84706d69] check-in: [9f4378b851] user: mistachkin branch: trunk, size: 108083
2020-05-24
00:36
Get this branch up-to-date with most trunk changes. file: [125e08f3ca] check-in: [bf714af93b] user: mistachkin branch: branch-1.0.112, size: 107895
2020-04-25
19:21
Support automatic value conversions for columns with a declared type of MEDIUMINT or MEDIUMUINT. Pursuant to [515cb60b10]. file: [5215693ff1] check-in: [b4eb15b5a5] user: mistachkin branch: trunk, size: 107905
2020-03-10
03:44
Add preliminary support for the .NET Framework 4.8. file: [b5f80e6256] check-in: [d6b5423937] user: mistachkin branch: trunk, size: 107759
2019-10-05
19:42
Various build fixes. file: [e52563912a] check-in: [11811c57fd] user: mistachkin branch: netStandard21, size: 107749
2018-12-23
04:56
Add HidePassword connection flag to remove the password from the connection string once the database is opened. Pursuant to [23d8d6171e]. file: [b0efe60198] check-in: [02ed8cae60] user: mistachkin branch: trunk, size: 107711
2018-08-27
04:56
Reform how connection flags are checked. file: [6f5a7be2cb] check-in: [c947d6b1fb] user: mistachkin branch: trunk, size: 105873
2018-05-06
20:09
Add preliminary support for the .NET Framework 4.7.2. Also, update the SQLite core library to the latest 3.23.2 release candidate. file: [0616c7c743] check-in: [880e608b09] user: mistachkin branch: trunk, size: 106056
2018-01-30
18:37
Compilation fixes for the .NET Compact Framework. file: [8fbe14cab8] check-in: [e637ca41cf] user: mistachkin branch: trunk, size: 106045
2018-01-24
19:07
Additions and corrections to the DbType mapping related lookup tables. Pursuant to ticket [a799e3978f]. file: [00062df3c3] check-in: [d583659651] user: mistachkin branch: tkt-a799e3978f, size: 106013
2017-11-07
01:00
Avoid unnecessary lock contention and managed heap allocations in the data type mapping subsystem. file: [bce2cb8cdf] check-in: [ca18c8f4dd] user: mistachkin branch: trunk, size: 105069
2017-09-16
06:20
Add the 'DECIMALTEXT' and 'NUMERICTEXT' type mappings. file: [b50027b2ed] check-in: [354e4df35c] user: mistachkin branch: trunk, size: 105315
2017-09-07
20:06
Add GetDecimalAsText connection flag to force Decimal typed columns to be returned as text. Pursuant to [b167206ad3]. file: [55382c0dfe] check-in: [59d87c8bce] user: mistachkin branch: trunk, size: 105163
2017-05-08
01:18
Avoid using the Int32.ToString method overload with no arguments. Depending on the current culture, it interacts badly when later parsing the returned strings with the invariant culture. Reported by David Rickard via the ML. file: [9340f17f5e] check-in: [9b146be3f9] user: mistachkin branch: trunk, size: 104827
2016-12-06
01:49
Candidate fix for ticket [69cf6e5dc8]. file: [1b2ae1ff50] check-in: [471c16c617] user: mistachkin branch: tkt-69cf6e5dc8, size: 104131
2016-03-24
01:36
On Mono, it appears that custom comparers used with the Dictionary<TKey,TValue> class must implement the IComparer<T> interface. file: [e26d9fd6f6] check-in: [46f51266d5] user: mistachkin branch: trunk, size: 104121
2016-03-23
23:35
Move some things out of the UnsafeNativeMethods class. There are several reasons: 1) easier to maintain. 2) avoiding static call graph issues with CriticalHandle. 3) better separation of cross-platform and platform-specific code. file: [7cba89c517] check-in: [d3e312825a] user: mistachkin branch: trunk, size: 103686
2016-03-02
18:32
The 'UnixEpoch' DateTime format should use Int64 internally, not Int32. file: [935059c43a] check-in: [d28375563e] user: mistachkin branch: trunk, size: 103704
2016-01-13
00:06
For column types that resolve to boolean, recognize case-insensitive prefixes of 'True' and 'False'. Fix for [dbd65441a5]. Add NoVerifyTextAffinity connection flag to skip type affinity checking when fetching a column value as a string. Pursuant to [dbd65441a5]. file: [2449d92445] check-in: [ecf9a72b79] user: mistachkin branch: trunk, size: 103675
2015-12-12
02:02
Coding style adjustment. file: [f50e363299] check-in: [9b51e7a273] user: mistachkin branch: tkt-5251bd0878, size: 103275
01:59
Revise fix for [5251bd0878] to use null for the 'COLUMN_NAME' if the original value was DBNull.Value. file: [e628c14407] check-in: [f8c2007d48] user: mistachkin branch: tkt-5251bd0878, size: 103297
2015-08-12
22:21
Add some workarounds to allow the core managed assembly to work on Mono 4.0. file: [155c514b74] check-in: [e7803b3ae7] user: mistachkin branch: trunk, size: 102345
2015-07-16
00:56
Extend OnChanged notifications to handle basic connection pool integration. file: [24875106a3] check-in: [b2cffa5974] user: mistachkin branch: trunk, size: 102288
2015-06-24
20:02
Change the base type for the SQLiteConnectionFlags enumeration to long integer. Improve exception handling in all native callbacks implemented in the SQLiteConnection class. Add Progress event and ProgressOps connection string property to enable raising progress events during long-running queries. file: [439bc8d1a2] check-in: [3b020c8c80] user: mistachkin branch: trunk, size: 102004
2015-06-03
02:16
Support alternate VFSs when opening a database connection. More work on ZipVFS integration. This is an interim check-in and needs testing. file: [e85cd403f4] check-in: [6bf64f992e] user: mistachkin branch: zipvfs, size: 101627
2015-02-19
01:00
Add BindDateTimeWithKind connection flag to force DateTime parameter values to match the DateTimeKind associated with the connection, if applicable. Fix for [a7d04fb111]. file: [b5490341a5] check-in: [e5f6b68387] user: mistachkin branch: trunk, size: 101583
2014-11-01
21:10
Improve coding style. file: [f930ca3633] check-in: [4a5306964c] user: mistachkin branch: newJulianDay, size: 101582
21:08
Improve backward compatibility by throwing exceptions for Julian Day values that are out of the range supported by the DateTime class in the .NET Framework. Fix issue with millisecond accuracy. file: [0e8cc1f0c6] check-in: [c3dc93e495] user: mistachkin branch: newJulianDay, size: 101607
18:46
Minor fix to whitespace. file: [6bbb786ed7] check-in: [b276a44703] user: mistachkin branch: newJulianDay, size: 100892
2014-10-31
23:36
Completely remove use of DateTime.FromOADate and DateTime.ToOADate methods. Improve comments. Now passes existing tests. More tests are still necessary. file: [1133265ac2] check-in: [36b4f89052] user: mistachkin branch: newJulianDay, size: 100896
22:40
Improve handling of out-of-range Julian Day values. file: [fcabe3ccc6] check-in: [c559792dba] user: mistachkin branch: newJulianDay, size: 99083
21:36
Add experimental port of the Julian Day handling functions from the SQLite core library. Still needs tests. Pursuant to [3e783eecbe]. file: [fe92a7418b] check-in: [fe17cded54] user: mistachkin branch: newJulianDay, size: 96887
2014-08-19
17:58
Add per-connection caching of the 'Use_SQLiteConvert_DefaultDbType' and 'Use_SQLiteConvert_DefaultTypeName' settings. Pursuant to [58ed318f2f]. file: [5d21452795] check-in: [948fd5b3a3] user: mistachkin branch: trunk, size: 93113
2014-08-12
19:19
Add NoConvertSettings connection flag to disable querying of runtime configuration settings from within the SQLiteConvert class. Pursuant to [58ed318f2f]. file: [085e441d93] check-in: [59d43c48bb] user: mistachkin branch: trunk, size: 91369
2014-08-02
20:46
Make sure default data type warnings are always issued when applicable. file: [540c3cc0b6] check-in: [2413338b69] user: mistachkin branch: trunk, size: 90379
2014-07-30
00:39
Minimize usage of the 'Use_SQLiteConvert_DefaultDbType' and 'Use_SQLiteConvert_DefaultTypeName' settings. Fix for [58ed318f2f]. file: [5e77275261] check-in: [69065c8e3b] user: mistachkin branch: trunk, size: 88133
2014-05-30
23:25
Add DetectTextAffinity and DetectStringType connection flags to enable automatic detection of column types, when necessary. Pursuant to [3c00ec5b52]. file: [64e6359dab] check-in: [58e932f761] user: mistachkin branch: trunk, size: 87984
21:16
Fix DateTime constant handling in the LINQ assembly. Fix for [da9f18d039]. file: [a12882d8f7] check-in: [4dc462af32] user: mistachkin branch: trunk, size: 83509
2014-05-29
04:52
Add the DefaultDbType and DefaultTypeName connection string properties to the SQLiteConnectionStringBuilder class. file: [abb6f4268b] check-in: [67d18c8ae3] user: mistachkin branch: trunk, size: 82454
2014-05-27
05:56
Add DetectStringType connection flag. file: [fc542b5bef] check-in: [229927cfce] user: mistachkin branch: tkt-3c00ec5b52, size: 86939
2014-05-26
22:52
Fix stray whitespace. file: [0bc7582467] check-in: [48fe67dae9] user: mistachkin branch: trunk, size: 82464
22:43
Refactor how the SQLiteDataReader class handles the connection flags associated with its command. file: [d2cc027863] check-in: [fc72de85c8] user: mistachkin branch: trunk, size: 82466
2014-05-18
07:09
Fix compilation for the .NET Compact Framework. Use invariant culture for Int64/Double parsing. file: [d5e7a4bb94] check-in: [9e3a7fdf26] user: mistachkin branch: tkt-3c00ec5b52, size: 86234
06:57
Add experimental MapTextToAffinity connection flag to permit automatic attempts to map textual column values onto values with an appropriate type affinity. file: [de5442461b] check-in: [f5dd5dcfde] user: mistachkin branch: tkt-3c00ec5b52, size: 85506
2014-05-15
23:44
Fix a FormatException in the SQLiteConnection.Schema_Indexes method when the default type has been changed to String. Pursuant to [3c00ec5b52]. file: [007d837101] check-in: [5b282efc5f] user: mistachkin branch: trunk, size: 81644
00:05
Also support overriding the default DbType value and type name via a 'configuration setting' (i.e. via the environment or the DLL config file). file: [0e793b338f] check-in: [216889c23b] user: mistachkin branch: trunk, size: 78802
2014-05-14
18:45
Work in progress for feature request [3c00ec5b52]. file: [797158c37c] check-in: [9c5dda4992] user: mistachkin branch: tkt-3c00ec5b52, size: 77548
2014-03-06
09:00
Also raise the static SQLiteConnection.Changed event when any SQLiteDataReader object is closed. file: [7d82548373] check-in: [ad12fa479a] user: mistachkin branch: trunk, size: 76688
08:12
Raise the static SQLiteConnection.Changed event when any SQLiteCommand or SQLiteDataReader object is disposed. file: [85edce12f0] check-in: [6eea79dc10] user: mistachkin branch: trunk, size: 76570
2014-02-01
00:51
Add support for per-connection mappings between type names and DbType values. Pursuant to [e87af1d06a]. file: [e77a1e682b] check-in: [d84ccf015e] user: mistachkin branch: trunk, size: 76333
2014-01-18
01:52
Update SQLite core library to the latest trunk code. file: [b5deeddfb2] check-in: [56ef8a255f] user: mistachkin branch: trunk, size: 72698
2014-01-04
00:04
Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings. file: [df9b086d82] check-in: [f2f08c2ab7] user: mistachkin branch: trunk, size: 72520
2013-12-11
07:54
Remove the now unused SQLiteConvert.ColumnToType method. Add TraceWarning connection flag to enable tracing of type mapping failures and disable tracing of them by default, pursuant to [6d45c782e4]. Update internal error message list to include SQLITE_NOTICE and SQLITE_WARNING. Update internal SQLiteConfigOpsEnum enumeration to include recently added values in the SQLite core library. file: [b394246f1e] check-in: [16f09dbc53] user: mistachkin branch: trunk, size: 71369
2013-09-18
02:10
Add experimental support for interfacing with the authorizer callback mechanism in the SQLite core library. file: [f4c267273f] check-in: [12c508890c] user: mistachkin branch: trunk, size: 71389
2013-09-13
01:38
Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter. file: [5dec6b3469] check-in: [00b02c1aa6] user: mistachkin branch: trunk, size: 63776
2013-09-04
03:42
Allow monitoring of the creation of all critical handle derived class instances. file: [d2e649aba9] check-in: [b194408bb5] user: mistachkin branch: onChanged, size: 63536
2013-08-29
23:00
Raise the static OnChanged event for the connection when a data reader is created. file: [95ea38e270] check-in: [85f27cc9f8] user: mistachkin branch: onChanged, size: 63043
2013-07-04
19:50
Experimental changes to validate that SQLiteStatement parameters are not disposed. file: [c9669251f6] check-in: [e325dfa45f] user: mistachkin branch: strictStatement, size: 62941
2013-07-01
18:22
In the SQLiteFunction class, check if the database connection is open prior to attempting to call the Cancel method. Add NoFunctions connection flag to skip binding functions registered in the application domain. Fixes and adjustments to comments. Add several data-types for compatibility purposes. Fix for [fe50b8c2e8]. file: [944673ae63] check-in: [dff9a878dd] user: mistachkin branch: trunk, size: 62912
2013-06-28
06:47
When reading a DateTime value, avoid unnecessary string conversions. Fix for [4d87fbc742]. file: [7cc06b3bf4] check-in: [e1b4194a30] user: mistachkin branch: trunk, size: 62630
2013-06-26
04:23
Add generic variants of the SQLiteModuleEnumerable and SQLiteVirtualTableCursorEnumerator classes. file: [442ec30ab0] check-in: [7da399e402] user: mistachkin branch: trunk, size: 61544
2013-06-21
06:27
Fix disposal semantics for classes derived from the SQLiteModuleBase class. Use the String.Format method consistently. Enable virtual table related native memory allocation tracking on the .NET Compact Framework. file: [749f9412ea] check-in: [f9041807b3] user: mistachkin branch: virtualTables, size: 61542
03:11
Major cleanup and refactoring of the ISQLiteManagedModule interface. Fix a small memory leak in DeclareVirtualTable. Add the ability to persist SQLiteValue values beyond the duration of the method call in progress. Add SQLiteVirtualTable base class. Update SQLiteVirtualTableCursor base class to be IDisposable and to support storing the filtering parameters. Make parameter naming in the ISQLiteManagedModule interface consistent with other managed code. Add SQLiteVirtualTable parameter to the ISQLiteManagedModule interface methods where necessary. Remove incorrect SQLiteIndex object creation from the IndexToIntPtr method. Keep track of all managed table and cursor object instances associated with their native pointers. Zero out the native sqlite3_vtab object right after allocation. Correct declarations for the sqlite3_vtab and sqlite3_vtab_cursor structures. Add SQLiteModuleEnumerable and SQLiteVirtualTableCursorEnumerable classes to allow an IEnumerable to provide the data for a virtual table. file: [8cf19bc208] check-in: [d3ac8fc2c3] user: mistachkin branch: virtualTables, size: 61460
2013-05-30
00:44
Add DateTimeFormatString connection string property to allow the DateTime format string used for all parsing and formatting to be overridden. Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to [bbdda6eae2]. file: [cabae4cd9a] check-in: [4f933521a1] user: mistachkin branch: trunk, size: 61443
2013-05-29
23:04
Honor the DateTimeFormat and DateTimeKind connection string properties even when the BindAllAsText connection flag is in use. file: [4eb5e38b81] check-in: [d81d546e99] user: mistachkin branch: trunk, size: 58668
10:04
Further refactoring work on the DbType/TypeName map handling. file: [6ef36bff99] check-in: [48b50f802e] user: mistachkin branch: trunk, size: 58654
2013-05-28
09:34
When translating a DbType to a type name, be sure to prioritize the type names supported by the EDMX components. Fix for [47f4bac575]. file: [e8e9c80c89] check-in: [4aa2360885] user: mistachkin branch: trunk, size: 56047
08:19
Fix incorrect comment. file: [b3a45ed0b9] check-in: [3a98512a05] user: mistachkin branch: trunk, size: 55472
2013-05-27
21:23
If the connection string cannot be parsed, throw an exception with an error message describing the problem. file: [5c1d2ca897] check-in: [89b5dbd444] user: mistachkin branch: trunk, size: 55468
2013-05-01
00:28
Update to comments and version history docs. file: [e3bd621412] check-in: [37f936471c] user: mistachkin branch: trunk, size: 55009
00:06
Allow semi-colons in the data source file name. Fix for ticket [e47b3d8346]. file: [95e44f7239] check-in: [8e0bb4c6cd] user: mistachkin branch: trunk, size: 54993
2013-04-29
23:00
NULL values should be mapped to type 'object', not 'DBNull'. Fix for ticket [48a6b8e4ca]. Also see ticket [49e30d7612]. file: [97af3f3526] check-in: [dcc277f29a] user: mistachkin branch: trunk, size: 50916
2013-03-06
22:14
Preliminary changes to fix ticket [3567020edf]. Missing tests. file: [b44e8b3e9f] check-in: [bea6b5d82d] user: mistachkin branch: tkt-3567020edf, size: 50916
2013-01-31
07:38
Clarify and improve type conversion arrays in the SQLiteConvert class. file: [e93483e93b] check-in: [e755582cbc] user: mistachkin branch: trunk, size: 50844
03:24
Centralize building of the column type name map. Remove AUTOINCREMENT from the column type name map. Add BIGUINT, SMALLUINT, TINYSINT, and ULONG to the column type name map. file: [e6d8f30ca5] check-in: [c7b39f9c3b] user: mistachkin branch: trunk, size: 48167
2013-01-30
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. file: [dce9af1c10] check-in: [ad2b42f3cc] user: mistachkin branch: trunk, size: 49535
2013-01-17
21:01
Bump all versions to 1.0.85.0. Add static Execute method to the SQLiteCommand class. Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor. When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed. file: [adb4e71f9b] check-in: [b2c5c6e2a0] user: mistachkin branch: trunk, size: 47397
2012-12-15
09:07
Add ParseViaFramework property to the SQLiteConnection class to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Pursuant to [b4cc611998]. file: [bb9d395347] check-in: [ba458b79fd] user: mistachkin branch: trunk, size: 46068
2012-09-20
11:53
Allow opened connections to skip adding the extension functions included in the interop assembly. Support loading of SQLite extensions. Add more notifications that use the new static Changed event. Miscellaneous comment cleanup. Cleanup usage of compile-time options for the .NET Framework version. Fix argument checking for the batch file tools. file: [8cfbc45c8e] check-in: [5759e099be] user: mistachkin branch: trunk, size: 45944
02:39
Fire notification events before a connection is opened or closed. Enhance documentation comments to that include references. Workaround issue in NDoc3 to allow project reference links to be resolved correctly. file: [1d46d44435] check-in: [69f6030c7f] user: mistachkin branch: trunk, size: 45391
2012-07-22
06:54
Remove all superfluous UTF-8 byte-order-marks. file: [c370613d93] check-in: [2c82e6c1a3] user: mistachkin branch: trunk, size: 44506
2012-07-21
06:56
Change the default value for the Synchronous connection string property to Full to match the default used by the SQLite core library itself. Add the ability to skip applying default connection settings to opened databases via the new SetDefaults connection string property. Add the FullUri connection string property to the SQLiteConnectionStringBuilder class. Refactor and enhance all the connection string property handling code in the SQLiteConnection.Open method. Consistently use the three argument overload of the String.Format method (i.e. the one that takes a CultureInfo). file: [244a085323] check-in: [9dfa1577a6] user: mistachkin branch: trunk, size: 44509
2012-07-16
04:58
Add define constants to support enabling or disabling individual groups of trace statements. Remove superfluous cast from the call to the sqlite3_config_none P/Invoke method. Make sure to remove any stale database from previous stress test runs. Stop leaking callbacks from the stress test. file: [f1c4f95973] check-in: [1164a207ef] user: mistachkin branch: trunk, size: 42877
2012-06-20
11:13
Improve documentation for the connection string properties and the DateTime formats. file: [9be505bdb6] check-in: [c09a59295c] user: mistachkin branch: trunk, size: 42834
2012-05-14
16:53
Fix an issue converting SQL type names that contain spaces between the name and opening parenthesis. Also, update SQLite native library to the 3.7.12 release. file: [4698e44c89] check-in: [bce7f5f71c] user: mistachkin branch: trunk, size: 42622
2012-02-24
15:41
Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite. file: [0e5c798ff4] check-in: [a594f67d47] user: mistachkin branch: trunk, size: 42612
2012-02-20
06:17
Add static ToUnixEpoch method to the SQLiteConvert class, update docs and tests. file: [8e97e8b20b] check-in: [f74a1ac3f1] user: mistachkin branch: trunk, size: 42574
2012-02-19
13:22
When converting a DateTime instance of an 'Unspecified' kind to a string, use the same kind as the connection, if available. Also, cleanup handling of the default formats for UTC and local time. file: [7db59dcb60] check-in: [dbdf2561a4] user: mistachkin branch: logBind, size: 42154
2012-02-14
22:12
Issue warnings on the trace listners if a column type or type name cannot be mapped properly. See ticket [4bbf851fa5]. file: [7665ceacf7] check-in: [10fae679b2] user: mistachkin branch: trunk, size: 41051
2012-01-15
01:27
DateTime conversion functions that can be static, should be static, see ticket [4bbf851fa5]. file: [87dd6680e4] check-in: [114024ffe7] user: mistachkin branch: trunk, size: 40536
2011-11-30
00:34
Recognize the TIMESTAMP column data type as a DateTime object. Fix for ticket [bb4b04d457]. file: [fc6082a6e1] check-in: [e96f0d17a5] user: mistachkin branch: trunk, size: 40515
2011-10-15
10:14
Lock access to the _typeNames dictionary. Fix for ticket [84718e79fa]. file: [1bbbb0d998] check-in: [13a3981ec0] user: mistachkin branch: trunk, size: 40449
2011-10-13
06:19
Both BOOLEAN and BOOL should end up being presented as the System.Boolean CLR type. Fix for ticket [544dba0a2f]. file: [6c219723ae] check-in: [453dc69391] user: mistachkin branch: trunk, size: 40236
2011-10-11
07:21
Merge all fixes, enhancements, and tests related to ticket [343d392b51] into trunk. file: [1a1072873f] check-in: [fc49363310] user: mistachkin branch: trunk, size: 40175
2011-10-09
03:19
Copy the fix for the Bind_DateTime method to the SQLite3_UTF16 class. Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Add the necessary method overloads to allow the DateTimeFormat and/or DateTimeKind to be specified by external callers. Reorganize the recognized DateTime formats so that ones with more information are always tried first. Also, add variants that support a trailing timezone specifier. Centralize DateTime format handling in the unit test infrastructure via the new getDateTimeFormat procedure. Revise setupDb unit test infrastructure procedure to accept a DateTimeKind. More changes to tests for ticket [343d392b51]. file: [e0c17958a2] check-in: [df7dcd3166] user: mistachkin branch: tkt-343d392b51, size: 37527
2011-10-07
00:30
Start of work to resolve ticket [343d392b51]. file: [415f3fdc65] check-in: [030e404034] user: mistachkin branch: tkt-343d392b51, size: 32442
2011-10-02
23:56
Update batch tools to allow precompiled static binaries to be built and packaged. Also, update test procedures web page. Finally, do not use ToLowerInvariant when compiling for the Compact Framework. file: [aef01aefa1] check-in: [0b847e5208] user: mistachkin branch: trunk, size: 32440
2011-09-24
08:09
Fix optimized DbType lookup for database type names that contain parenthesis. file: [232f9c5ec9] check-in: [9d9fa54984] user: mistachkin branch: trunk, size: 32346
07:41
Reduce the number of String.Compare calls in the hot path for SQLiteCommand.ExecuteReader. file: [3b0ad5b1dd] check-in: [32ce066699] user: mistachkin branch: trunk, size: 32098
2011-09-23
07:20
Experimental changes for better DateTime handling in the LINQ assembly (incomplete, do not use yet). file: [c04032b741] check-in: [1fc7a1a94c] user: mistachkin branch: LinqDateTime, size: 32613
2011-09-21
08:27
Allow finer control over the DateTime parsing and formatting on a per-connection basis. Also, update the Eagle library to the latest trunk. file: [d60fb5152b] check-in: [a5a8b8a682] user: mistachkin branch: trunk, size: 30752
2011-07-11
19:40
Refactor the logging interface to be thread-safe and 'self-initializing'. Stop ignoring errors returned by sqlite3_config(SQLITE_CONFIG_LOG). Provide a default log handler and allow it to be added/removed dynamically. Allow logging to be temporarily enabled/disabled without modifying the underlying delegates. file: [cc49ac0198] check-in: [1d955a6031] user: mistachkin branch: trunk, size: 28448
2011-07-05
07:47
Fix for [2c630bffa7] and [b0a5990f48]. file: [88ade138e8] check-in: [eb6a22a1a9] user: mistachkin branch: trunk, size: 28357
06:07
Fix for [448d663d11], with tests. Also fixes [2a0c90d7b0]. See also [08f3d3daf2]. file: [93421a843f] check-in: [50b4844f0c] user: mistachkin branch: trunk, size: 28377
2011-07-01
11:36
Remove unused 'using' statements from System.Data.SQLite. file: [7f67283b05] check-in: [b270e24e93] user: mistachkin branch: build-enhancements, size: 27322
2010-12-16
17:49
Changes to get base portions compiling under Visual Studio 2010. Still much to be done. Need to sort out packaging, installation, wince, etc. file: [e2f539e6e5] check-in: [644aeca13c] user: shaneh branch: vs2010, size: 27436
2010-08-11
16:14
Updates for 67 release file: [74c07b5a21] check-in: [09564699fe] user: rmsimpson branch: sourceforge, size: 26934
2010-08-05
02:03
1.0.66.0 file: [1603afc7d9] check-in: [7ec6a118ce] user: rmsimpson branch: sourceforge, size: 26622
2008-08-06
21:40
1.0.55.0 file: [13ae070006] check-in: [24425920c8] user: rmsimpson branch: sourceforge, size: 26594
2008-07-26
04:34
1.0.54.0 file: [92c0cf74a7] check-in: [41d8f0f895] user: rmsimpson branch: sourceforge, size: 24954
2008-07-16
23:32
1.0.52.0 file: [5de199d8fe] check-in: [1084c98790] user: rmsimpson branch: sourceforge, size: 23351
2008-06-27
21:33
1.0.50.0 file: [2c3cda4340] check-in: [1db667d2bd] user: rmsimpson branch: sourceforge, size: 22214
2008-05-28
08:18
1.0.49.0 file: [786dd3ef7d] check-in: [f3f45cefd1] user: rmsimpson branch: sourceforge, size: 21906
2007-12-04
16:07
1.0.47.0 file: [adaa6b7a8e] check-in: [7518ccfcff] user: rmsimpson branch: sourceforge, size: 20591
2007-09-25
22:45
1.0.45.0 file: [8fa3c31fc3] check-in: [5a232b012b] user: rmsimpson branch: sourceforge, size: 20927
2007-04-23
07:59
1.0.41.0 file: [6b91e19399] check-in: [acd17b1cf8] user: rmsimpson branch: sourceforge, size: 20921
2007-04-22
23:23
1.0.41.0 file: [455bd1db95] check-in: [06c93533ad] user: rmsimpson branch: sourceforge, size: 19753
2006-10-23
21:28
1.0.36.0 file: [36f66f417a] check-in: [b23bfc47c3] user: rmsimpson branch: sourceforge, size: 19747
2006-10-16
14:51
Add smalldate and smalldatetime file: [a7503ab58f] check-in: [c655bb861a] user: rmsimpson branch: sourceforge, size: 19690
2006-09-03
18:15
1.0.34.0 file: [200bbd56f7] check-in: [563830df65] user: rmsimpson branch: sourceforge, size: 19633
2006-08-06
17:55
1.0.32.0 file: [bd6a54f307] check-in: [6b4fd5077c] user: rmsimpson branch: sourceforge, size: 19632
2006-07-02
06:45
1.0.30.0 file: [ccacbe8493] check-in: [c03b78555a] user: rmsimpson branch: sourceforge, size: 19558
2006-04-12
05:47
1.0.28.0 prep file: [1287a157e6] check-in: [49268d8c86] user: rmsimpson branch: sourceforge, size: 19031
2006-04-11
18:02
64-bit fixes file: [83aa367f1d] check-in: [5dea167156] user: rmsimpson branch: sourceforge, size: 18928
2006-02-02
23:09
Documentation changes only file: [8b7ee71c49] check-in: [5852cf0475] user: rmsimpson branch: sourceforge, size: 18187
2005-11-21
16:30
Added more ISO8601 datetimes file: [45a5e32e08] check-in: [c16bb7e835] user: rmsimpson branch: sourceforge, size: 18360
2005-11-18
15:58
Fixed LONGTEXT and LONGCHAR that were being incorrectly typed file: [9cd06b4c84] check-in: [10eda27cb2] user: rmsimpson branch: sourceforge, size: 18144
15:36
Added a few new ISO8601 datetime conversion patterns file: [0fa870257d] check-in: [e7ba6b83c2] user: rmsimpson branch: sourceforge, size: 18144
2005-11-10
21:08
Globalization bugfixes file: [6d95741f8e] check-in: [3a7fb899f7] user: rmsimpson branch: sourceforge, size: 18131
2005-11-03
20:41
Minor conversion fixes file: [8f33144c96] check-in: [7df5ddfcd3] user: rmsimpson branch: sourceforge, size: 18129
2005-08-22
18:18
1.0.15 file: [f62b1ba1f4] check-in: [4ff57a0919] user: rmsimpson branch: sourceforge, size: 18118
2005-08-17
21:14
Globalization updates file: [7ae7d3cdb2] check-in: [d54fc9e9fb] user: rmsimpson branch: sourceforge, size: 18141
2005-08-16
19:12
1.0.14 file: [e3e7599248] check-in: [4453746b7a] user: rmsimpson branch: sourceforge, size: 18223
2005-08-06
06:46
UTF-16 bugfixes and performance enhancements file: [fa2fbea772] check-in: [0b55ce3401] user: rmsimpson branch: sourceforge, size: 17938
2005-08-05
06:14
1.0.12 final file: [84b20ff38f] check-in: [9e5f1b5614] user: rmsimpson branch: sourceforge, size: 19683
2005-08-04
15:25
1.0.12 updates and cleanup file: [40d0aed5e2] check-in: [3ebf811b1e] user: rmsimpson branch: sourceforge, size: 19282
2005-05-24
22:12
VS2005 Beta 2 updates file: [04c0037110] check-in: [f4aec657e0] user: rmsimpson branch: sourceforge, size: 19114
2005-03-24
19:37
1.08 Refresh, added documentation file: [243110f461] check-in: [b56fd4b082] user: rmsimpson branch: sourceforge, size: 19062
2005-03-04
21:30
Added more internal-use utility type conversion helpers file: [ec25bc72cf] check-in: [1f38aec2e8] user: rmsimpson branch: sourceforge, size: 18046
2005-03-01
16:04
Added: Initial revision file: [a746c57897] check-in: [ec237b0123] user: rmsimpson branch: sourceforge, size: 17212