System.Data.SQLite

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

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

History for System.Data.SQLite/SQLiteBase.cs

2024-07-03
23:13
Add the Serialize and Deserialize methods to the SQLiteConnection class. file: [b3cfec51a7] check-in: [502ca25961] user: mistachkin branch: trunk, size: 89697
2024-07-02
14:37
Add some comments. file: [02d445786a] check-in: [3e72cd9da8] user: mistachkin branch: trunk, size: 87737
05:10
Add the AggressiveDisposal connection flag. Other pre-release fixes. file: [449c46cbf5] check-in: [8d439ebdde] user: mistachkin branch: trunk, size: 87457
2024-06-26
20:29
Add another trace category. file: [131089ae1b] check-in: [74a0d7dca3] user: mistachkin branch: trunk, size: 88182
17:06
Add another trace category value. file: [09f3312ee2] check-in: [e7c3adce8f] user: mistachkin branch: trunk, size: 88102
16:43
Further tracing enhancements. file: [b7e864b62e] check-in: [5ee0181745] user: mistachkin branch: trunk, size: 87978
16:26
Add support for the 'SQLite_TraceCategories' environment variable. file: [33d876e6b1] check-in: [37849c1af4] user: mistachkin branch: trunk, size: 87945
2024-06-25
21:09
Add the 'ConnectionPoolOnly' flag. file: [0c571fba35] check-in: [c545a8aaef] user: mistachkin branch: trunk, size: 87182
2024-03-25
01:20
Updates to lists of core library constants. file: [9dae4e9e97] check-in: [55bae7dd04] user: mistachkin branch: trunk, size: 86901
2023-05-15
04:29
Update the 'LogAll' connection flags value to include the new 'LogRetry' flag. file: [464faf6e63] check-in: [dd78ea7b5c] user: mistachkin branch: trunk, size: 86854
2023-05-13
21:21
Further refinements to retry logic. Also, restrict the fix from check-in [8c9e834b95] to only be active for write transactions. file: [21b44c4897] check-in: [2a78948bf0] user: mistachkin branch: trunk, size: 86832
05:54
In Prepare, read the retry properties from the command, not the connection. file: [93c367ff0f] check-in: [8800b650c8] user: mistachkin branch: trunk, size: 86479
2023-05-12
21:29
Add the LogRetry connection flag and the SQLite_ForceLogRetry environment variable. file: [5b593740cb] check-in: [1162d19e69] user: mistachkin branch: trunk, size: 86397
2023-04-08
20:11
Update SQLite core library to the latest 3.41 release branch code. file: [c3a76d3c1e] check-in: [2517335da5] user: mistachkin branch: trunk, size: 86071
2023-01-17
18:25
Add comments. file: [ebb9f03bf9] check-in: [43b5d891f7] user: mistachkin branch: trunk, size: 84929
07:31
Add initial testing for the Trace2 event. file: [618d420a02] check-in: [843fbaa836] user: mistachkin branch: trunk, size: 83706
04:07
Initial work on fully supporting the sqlite3_trace_v2 core library API. Pursuant to forum post https://sqlite.org/forum/forumpost/1c418d7edc. file: [cfbbf1447d] check-in: [5ad580f5ec] user: mistachkin branch: trunk, size: 83569
2023-01-11
20:59
Add support for the (new) sqlite3_is_interrupted core library API. file: [52783227bc] check-in: [5cf635b987] user: mistachkin branch: trunk, size: 83571
2022-07-20
19:09
More work on integrating new functionality into the function and virtual table support subsystems. file: [da701da77d] check-in: [e9d2b9b571] user: mistachkin branch: windowFunc, size: 83387
03:54
More work on upgrading the underlying custom function infrastructure. file: [021cb6c360] check-in: [4a89490941] user: mistachkin branch: windowFunc, size: 83056
02:48
More work-in-progress on window function support. file: [b1b17ac008] check-in: [cf1b031ddf] user: mistachkin branch: windowFunc, size: 83029
02:31
Initial work at stubbing in support for creating window functions. file: [e4b81c16bd] check-in: [f2bc86f69d] user: mistachkin branch: windowFunc, size: 83064
2022-07-06
21:33
Suppress finalizer calls for SQLite3 objects that are closed. Fix for [ce4d70ea6f]. file: [4fcd872b90] check-in: [e242effb07] user: mistachkin branch: trunk, size: 82951
2022-06-01
14:28
Minor changes to get things compiling for the .NET Compact Framework again. file: [d7310d428b] check-in: [e76de45fff] user: mistachkin branch: trunk, size: 81916
2021-12-09
22:45
Tidy some things up. file: [07a6816807] check-in: [ac17cde538] user: mistachkin branch: trunk, size: 80021
2021-12-07
02:32
Keep count of the number of calls into the Open and Close methods. file: [86239fe8da] check-in: [1632b701e5] user: mistachkin branch: trunk, size: 80047
2021-12-05
02:07
Revert incorrect Dispose changes from check-in [95d4c93286]. file: [d06dab734a] check-in: [3e5f903c51] user: mistachkin branch: trunk, size: 78726
2021-12-04
03:12
Initial work on addressing several object lifecycle issues with pooled database connections. file: [b4675b5f23] check-in: [95d4c93286] user: mistachkin branch: trunk, size: 78496
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: [626eca0457] check-in: [2541fcec64] user: mistachkin branch: trunk, size: 77779
2021-06-07
17:34
Change ForceLogPrepare to an instanced property, primarily in order to avoid lock contention. Pursuant to https://sqlite.org/forum/forumpost/0cf95d2717. file: [fc095ff758] check-in: [15055f1aac] user: mistachkin branch: trunk, size: 77404
2021-03-05
08:12
Add support for math functions now provided by the SQLite core library. file: [ce915c7ea9] check-in: [d9db7c6868] user: mistachkin branch: trunk, size: 77253
2021-02-19
02:50
Add 'TextPassword' connection string property for use with the SQLite Encryption Extension. file: [b2905c712b] check-in: [d2ec91fd6e] user: mistachkin branch: trunk, size: 76981
2020-01-19
03:27
Add support for the new DBCONFIG options and update several tests. file: [c2e4aaa992] check-in: [436f0e76b2] user: mistachkin branch: corePreRelease, size: 76955
2019-10-26
23:06
Some fixes. Add tests. Update version history docs. file: [89d102652b] check-in: [e82be4000d] user: mistachkin branch: limits, size: 74767
2019-10-24
22:37
Initial work on being able to change limits via sqlite3_limit(). file: [ac67e19a7c] check-in: [d279011853] user: mistachkin branch: limits, size: 74570
2019-10-05
03:32
Add support for new DBCONFIG options from the SQLite core library. Pursuant to [03b6b0edd7]. file: [0e9e23c1c5] check-in: [42082ffc4d] user: mistachkin branch: trunk, size: 71755
2019-03-24
00:04
Fix typos in documentation. Fix for [4bd6914554]. file: [1d49511ac3] check-in: [10da1211e5] user: mistachkin branch: trunk, size: 69617
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: [f61013cf26] check-in: [02ed8cae60] user: mistachkin branch: trunk, size: 69617
00:01
Add experimental StrictConformance connection flag to force strict compliance to the ADO.NET standard. Pursuant to [e36e05e299]. file: [95b97441db] check-in: [4012cc2587] user: mistachkin branch: trunk, size: 69208
2018-08-26
22:53
Add the GetInvariantInt64 and GetInvariantDouble connection flags. file: [dbfc69e3ad] check-in: [e945d6e2f9] user: mistachkin branch: trunk, size: 68946
2018-04-28
15:59
Add preliminary support for the SQLITE_DBCONFIG_RESET_DATABASE control. file: [2f4b41162d] check-in: [4e485e3e31] user: mistachkin branch: trunk, size: 68470
2018-03-09
17:45
The GetSchemaTable method must verify the base table name (for a column) actually refers to a base table before attempting to query its metadata. Pursuant to [baf42ee135]. file: [06a95a9126] check-in: [63ae5401bf] user: mistachkin branch: trunk, size: 67942
2018-02-26
19:17
Add tests for the database option values added via check-in [b7ba6996c1]. file: [5d7ca1e6a4] check-in: [b3872ff42e] user: mistachkin branch: trunk, size: 67852
17:25
Add more database connection configuration options for the sqlite3_db_config() interface. file: [2dd06eaab5] check-in: [b7ba6996c1] user: mistachkin branch: trunk, size: 61896
2018-02-08
01:02
Sync up (fallback) error messages with those in the SQLite core library. Mask off extended error codes prior to using the fallback table. Add tests for preserving extended error codes in the SQLiteException class. file: [ba0d075ba1] check-in: [accc5da1ee] user: mistachkin branch: trunk, size: 60597
2018-02-03
22:17
When unhooking native delegates from a connection, use sqlite3_trace_v2() when it is available. file: [91dca8c65d] check-in: [9f103baaad] user: mistachkin branch: trunk, size: 60305
2018-01-30
21:16
Add experimental WaitForEnlistmentReset connection flag and WaitTimeout connection string property. file: [9f68c1f986] check-in: [19447f0a41] user: mistachkin branch: trunk, size: 59788
2017-11-09
08:04
Attempt to invalidate all native delegates from a connection during its disposal. Pursuant to [0e48e80333]. Still needs tests. file: [beb3f8bf86] check-in: [aa99152568] user: mistachkin branch: tkt-0e48e80333, size: 59414
2017-10-18
17:59
Add GetInvariantDecimal connection flag, enabled by default, to force returning of decimal values using the invariant culture. Update version history docs. file: [39c5b96fbd] check-in: [b37afb1ddc] user: mistachkin branch: trunk, size: 59428
2017-10-17
20:01
Add the 'BindInvariantDecimal' connection flag, enabled by default, which forces Decimal parameters to be converted to strings using the invariant culture. file: [666cc27cc1] check-in: [da44957e76] user: mistachkin branch: trunk, size: 59166
2017-09-16
05:49
Add BindDecimalAsText connection flag to force Decimal typed parameters to be bound as text. Pursuant to [b167206ad3]. file: [1b096ab8f6] check-in: [995978db06] user: mistachkin branch: trunk, size: 58757
2017-09-07
20:06
Add GetDecimalAsText connection flag to force Decimal typed columns to be returned as text. Pursuant to [b167206ad3]. file: [79cee7b4d2] check-in: [59d87c8bce] user: mistachkin branch: trunk, size: 58468
2016-11-04
02:00
Add 'AllowNestedTransactions' connection flag to enable nested transactions. file: [f896f4a977] check-in: [ffd3c1b1d8] user: mistachkin branch: tkt-1f7bfff467, size: 58180
2016-10-27
20:19
Bump version to 1.0.104.0. Update version history docs. Prevent the GetByte, GetChar, and GetInt16 methods of the SQLiteDataReader class from throwing exceptions for large integer values. Pursuant to [5535448538]. file: [912af3fd5e] check-in: [2b70123e05] user: mistachkin branch: trunk, size: 57822
2016-09-28
07:02
Remove the SharedCache flag from the internal SQLiteOpenFlagsEnum enumeration, because it is no longer used. Also, further cleanup. file: [441fac1f81] check-in: [f2d4512fc7] user: mistachkin branch: trunk, size: 57752
2016-07-22
22:18
Add support for setting all the on/off style database configuration options, including SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. Fix for [f64f4aee95]. file: [cbebdd047e] check-in: [3a27201398] user: mistachkin branch: trunk, size: 57752
2016-07-01
09:06
Add experimental support for incremental blob I/O. file: [3a36ec41bb] check-in: [ccf2547bfd] user: mistachkin branch: blobIo, size: 56187
2016-06-20
20:30
Reorganize the new connection flags. file: [f4c8f74366] check-in: [d1e833bf59] user: mistachkin branch: customDataTypes, size: 55303
04:51
When looking up type callbacks, permit the parameter name to be used if the appropriate connection flag is set. file: [8573792d7d] check-in: [e268cdb240] user: mistachkin branch: customDataTypes, size: 54980
2016-06-19
03:40
Integrate the new custom database type callbacks into the statement class. Add TypeName property to the SQLiteParameter class and make use of it. Add UseParameterDbTypeForTypeName connection flag. Update version history docs. file: [705bc9a861] check-in: [5973dcfa17] user: mistachkin branch: customDataTypes, size: 54741
02:59
Add the new connection flags. file: [9b1bb60717] check-in: [ff93dd1274] user: mistachkin branch: customDataTypes, size: 54437
2016-06-18
21:34
Add IsReadOnly method to the SQLiteConnection class. file: [831fe4ea3d] check-in: [c4f8b9e65b] user: mistachkin branch: trunk, size: 53290
2016-05-26
18:19
Handle parameter binding for boolean values using a new internal method. Consistently enable LogBind flag support for the .NET Compact Framework. file: [d02b4e9b0f] check-in: [d38c8328d0] user: mistachkin branch: trunk, size: 53123
2016-04-27
21:44
Update SQLite core library to the latest trunk code. Update the SQLiteConnection.EnableExtensions method to make use of the new SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION option, when available. file: [7d60dc5f08] check-in: [5b30c66448] user: mistachkin branch: trunk, size: 53007
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: [81ca8dc0bc] check-in: [ecf9a72b79] user: mistachkin branch: trunk, size: 52560
2015-09-25
21:16
Make GetValue work for boolean columns with textual 'True' and 'False' values. Fix for [7714b60d61]. file: [375202b0d9] check-in: [ed83298257] user: mistachkin branch: trunk, size: 52362
2015-09-04
19:59
Add FileName property to the SQLiteConnection class. file: [fdced7279f] check-in: [71cc174339] user: mistachkin branch: dbFileName, size: 52212
2015-08-12
19:59
Revise and extend compilation fixes from the previous check-in. file: [92079037d9] check-in: [9582604b8d] user: mistachkin branch: trunk, size: 51770
2015-07-17
02:01
Add the UnbindFunctionsOnClose connection flag. file: [ed443be3f9] check-in: [2a6efe65f7] user: mistachkin branch: trunk, size: 51475
01:08
Add UnbindFunction method to the SQLiteConnection class. file: [f84434debe] check-in: [187e8cb03d] user: mistachkin branch: trunk, size: 51265
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: [e99d7cfcef] check-in: [3b020c8c80] user: mistachkin branch: trunk, size: 50363
2015-06-13
20:45
Update list of CONFIG parameters. file: [1b155a638f] check-in: [d1d2020750] user: mistachkin branch: trunk, size: 49290
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: [7ba13442d5] check-in: [6bf64f992e] user: mistachkin branch: zipvfs, size: 49188
2015-04-21
18:18
Improve ADO.NET conformance of the SQLiteDataReader.RecordsAffected property. Fix for [74542e702e]. file: [c249da85bd] check-in: [68239f46ea] user: mistachkin branch: trunk, size: 49072
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: [ac3827a2c5] check-in: [e5f6b68387] user: mistachkin branch: trunk, size: 49661
2015-02-12
18:18
Enable easier integration with CEROD. file: [c2e712fc8f] check-in: [d3eb5c0fcc] user: mistachkin branch: trunk, size: 49378
2015-01-29
00:57
Enable easier integration with SEE. file: [99d148c37b] check-in: [328517cce9] user: mistachkin branch: trunk, size: 49353
2014-11-14
01:18
The interop assembly methods should use 'ref' parameters, not 'out' parameters, since the native interop methods are not actually guaranteed to set output parameters to well-defined values. Also, add more parameter validation to the interop assembly, paying special attention to output parameters, especially optional ones. Pursuant to [3b43ffdbd7]. file: [cfbbb7124c] check-in: [5b359db222] user: mistachkin branch: interopParams2, size: 49330
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: [a314df1178] check-in: [59d43c48bb] user: mistachkin branch: trunk, size: 49326
2014-06-27
04:49
The interop assembly methods should use 'ref' parameters, not 'out' parameters, since the native interop methods are not actually guaranteed to set output parameters to well-defined values. Also, add more parameter validation to the interop assembly, paying special attention to output parameters, especially optional ones. Pursuant to [3b43ffdbd7]. file: [b3d932a752] check-in: [26a20dd470] user: mistachkin branch: interopParams, size: 48648
2014-05-27
05:56
Add DetectStringType connection flag. file: [5085fab788] check-in: [229927cfce] user: mistachkin branch: tkt-3c00ec5b52, size: 48644
05:34
Merge updates from trunk. file: [05de68a6eb] check-in: [e7d0d8c183] user: mistachkin branch: tkt-3c00ec5b52, size: 48215
05:33
Revise how the SQLiteLog class is used in the default debug builds (i.e. when INTEROP_LOG is enabled). file: [0460248a1e] check-in: [1affdac144] user: mistachkin branch: trunk, size: 47789
2014-05-26
20:56
Rename MapTextToAffinity connection flag to DetectTextAffinity. Update version history docs. file: [23814310e4] check-in: [837870c7bb] user: mistachkin branch: tkt-3c00ec5b52, size: 48045
2014-05-18
06:57
Add experimental MapTextToAffinity connection flag to permit automatic attempts to map textual column values onto values with an appropriate type affinity. file: [e9e61f0b86] check-in: [f5dd5dcfde] user: mistachkin branch: tkt-3c00ec5b52, size: 48006
2014-04-28
08:15
Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface. file: [4c6ea72f4d] check-in: [6911b6547b] user: mistachkin branch: linqServiceProvider, size: 47619
2014-03-30
01:19
Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1]. file: [0e42dc803a] check-in: [79365bcaed] user: mistachkin branch: isolationLevels, size: 47312
2014-03-14
20:20
Add StickyHasRows connection flag to cause the SQLiteDataReader.HasRows property to return non-zero if there were ever any rows in the associated result sets. file: [00e73f714e] check-in: [59bbbbfcdb] user: mistachkin branch: stickyHasRows, size: 46676
2014-02-01
00:51
Add support for per-connection mappings between type names and DbType values. Pursuant to [e87af1d06a]. file: [41b6f94353] check-in: [d84ccf015e] user: mistachkin branch: trunk, size: 46413
2014-01-17
00:10
Add connection flags NoConnectionPool and UseConnectionPool. Several enhancements to the stress test. file: [1d6284a648] check-in: [54f887ca5c] user: mistachkin branch: trunk, size: 45415
2014-01-04
01:03
Put new connection flags in logical order. Add several new composite connection flags. Update comments. file: [bb048f7491] check-in: [133692ee96] user: mistachkin branch: trunk, size: 44562
00:50
Fix comment for the BindAndGetAllAsText connection flag. file: [da31f0896c] check-in: [1b99a129a8] user: mistachkin branch: trunk, size: 43336
00:04
Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings. file: [4e9e14ec81] check-in: [f2f08c2ab7] user: mistachkin branch: trunk, size: 43320
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: [ff7368e1c8] check-in: [16f09dbc53] user: mistachkin branch: trunk, size: 42915
2013-11-07
01:27
Never create a new connection wrapper in the SQLiteConnection.Shutdown method. Add experimental GetMemoryStatistics, ReleaseMemory, and Shutdown methods to the SQLiteConnection class. Add memory leak detection to the test project for the .NET Compact Framework. Miscellaneous internal refactoring and additional comments. file: [5c1081462c] check-in: [aa16f48eea] user: mistachkin branch: trunk, size: 42226
2013-10-15
06:52
Add AutoCommit property to the SQLiteConnection class. Fix for [9ba9346f75]. file: [4807af2b3c] check-in: [a6dfd19657] user: mistachkin branch: trunk, size: 41457
2013-09-18
02:10
Add experimental support for interfacing with the authorizer callback mechanism in the SQLite core library. file: [9bbe8b955e] check-in: [12c508890c] user: mistachkin branch: trunk, size: 41177
2013-07-04
18:49
Rename the new NoFunctions connection flag to NoBindFunctions. file: [24f130ccbc] check-in: [8e945470fe] user: mistachkin branch: trunk, size: 41099
06:00
Add SQLiteConnection.BindFunction method to facilitate adding custom functions on a per-connection basis. file: [03e3667e99] check-in: [1fa0ac70f3] user: mistachkin branch: trunk, size: 41098
2013-07-02
07:07
Enable setting of the logging related SQLiteModule properties via the connection flags. file: [3e6b3b42a8] check-in: [7c20d612a1] user: mistachkin branch: trunk, size: 40382
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: [14fcfa6ba6] check-in: [dff9a878dd] user: mistachkin branch: trunk, size: 39264
10:16
Allow virtual tables implemented in managed code to implement functions. file: [3a632814f2] check-in: [3e1da60858] user: mistachkin branch: trunk, size: 38842
2013-06-25
21:49
Add connection flags to allow loading of extensions and the creation of modules to be disabled. file: [7b1c072a5d] check-in: [1e947f24b6] user: mistachkin branch: virtualTables, size: 37684
2013-06-22
02:51
Support compiling without built-in support for creating virtual tables in managed code, thus allowing the vtshim extension module to be excluded. file: [b99ff56772] check-in: [a85fc42853] user: mistachkin branch: virtualTables, size: 37303
00:52
Improve diagnostics for test data-1.1. Fix connection handle leak by removing superfluous _ownHandle fields and add properties instead. file: [0ca5f8fe3d] check-in: [0e4ebe697a] user: mistachkin branch: virtualTables, size: 37268
2013-06-21
07:21
Rename the SQLiteModuleBase class to SQLiteModule. file: [62d1e26bfd] check-in: [f0ccb3cd64] user: mistachkin branch: virtualTables, size: 37086
2013-06-19
07:02
Pickup SQLite core library with disposable vtable support from upstream. More work on integration of the SQLiteModuleBase class. Add initial tests. file: [dc2fdac456] check-in: [15b1d1d825] user: mistachkin branch: virtualTables, size: 37098
2013-06-07
00:56
Implement the xDisconnect and xDestroy virtual table methods. file: [bd64f89c8e] check-in: [f19e7df898] user: mistachkin branch: virtualTables, size: 36296
00:28
Keep track of whether the DeclareVirtualTable method has been called by a virtual table module. file: [5f23edeec9] check-in: [091ead1daf] user: mistachkin branch: virtualTables, size: 35966
00:04
Add initial marshalling infrastructure and start implementing the xCreate and xConnect virtual table methods. file: [a689528ae8] check-in: [bf5505be7a] user: mistachkin branch: virtualTables, size: 35785
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: [2b61f8ad41] check-in: [4f933521a1] user: mistachkin branch: trunk, size: 35066
2013-03-22
23:40
Add GetAllAsText connection flag to force all column values to be returned as text. Pursuant to [e06c4caff3]. file: [b9c4af80f5] check-in: [2cd9814a44] user: mistachkin branch: trunk, size: 35037
2013-02-19
09:55
Add BindAllAsText connection flag to force binding of all values as text. file: [db15b52752] check-in: [cb62e486b5] user: mistachkin branch: trunk, size: 34449
2013-02-15
01:14
Add the ability to select the legacy connection closing algorithm at compile-time. file: [94b5eadf00] check-in: [2f90848c8e] user: mistachkin branch: legacyClose, size: 34191
2013-01-31
23:19
Add BindUInt32AsInt64 connection flag to force binding of UInt32 values as Int64 instead. Pursuant to ticket [c010fa6584]. file: [6951889d36] check-in: [99c7362ca8] user: mistachkin branch: tkt-c010fa6584, size: 34156
07:36
Avoid throwing overflow exceptions from the SQLite3.GetValue method for integral column types. Fix for [c010fa6584]. file: [97b95be2da] check-in: [618f5890e7] user: mistachkin branch: tkt-c010fa6584, size: 33911
2012-10-18
16:51
Improve automatic detection of the sqlite3_close_v2 function when compiled to use the standard SQLite library. file: [3033315bed] check-in: [cf55a3e9b9] user: mistachkin branch: trunk, size: 33475
2012-10-12
16:09
Add a LogMessage method overload to the SQLiteConnection class that takes a SQLiteErrorCode. file: [d05529e749] check-in: [d874518f31] user: mistachkin branch: threadAbortProtect, size: 32767
11:28
Enhance Thread.Abort protection and add a special test for it. Also, enhance the test suite infrastructure in support of this new test and fix comments in a related test file. file: [ea2adc2b8c] check-in: [6f81afd900] user: mistachkin branch: threadAbortProtect, size: 32755
2012-10-11
06:58
Add sqlite3_backup_finish_interop function with optional diagnostics. Improvements to sqlite3_finalize_interop diagnostics. Make interop function names consistent. file: [3994ed2958] check-in: [c826898164] user: mistachkin branch: trunk, size: 31111
2012-10-06
07:05
Avoid throwing non-fatal exceptions during connection disposal. Make the handle checking and disposal code more consistent. Update version history docs with the latest changes. Allow stress test to optionally skip some workloads. file: [827a0c1d49] check-in: [8e2c95ad40] user: mistachkin branch: trunk, size: 30982
05:57
Make the SQLiteBase.ResetConnection method throw an exception if the connection handle is closed or invalid. file: [7f242ad72c] check-in: [1045210882] user: mistachkin branch: trunk, size: 30525
2012-10-05
00:17
More refinements to disposal locking semantics on the .NET Compact Framework. file: [ce69583cf3] check-in: [ac5f4cc084] user: mistachkin branch: trunk, size: 30329
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: [832f2ed264] check-in: [5759e099be] user: mistachkin branch: trunk, size: 29881
2012-09-12
04:29
Update SQLite core library to the latest trunk code and add support for the sqlite3_errstr API. file: [a75e44c8f1] check-in: [aa7259812f] user: mistachkin branch: trunk, size: 28927
2012-09-11
08:05
Refactor core SQLite library return code handling to make use of the enumerated SQLiteErrorCode type. Initial work on supporting the sqlite3_errstr() API. file: [a356b6f488] check-in: [a6c16dc93b] user: mistachkin branch: trunk, size: 28143
2012-07-22
06:54
Remove all superfluous UTF-8 byte-order-marks. file: [22335a4249] check-in: [2c82e6c1a3] user: mistachkin branch: trunk, size: 25126
2012-07-11
06:47
Add support for URI file names. file: [a92c6a0240] check-in: [cf96d6650f] user: mistachkin branch: trunk, size: 25129
2012-06-12
08:52
Experimental changes to support the prototype sqlite3_close_v2 interface. file: [9b8da40a4c] check-in: [8b0d3259cb] user: mistachkin branch: deferred-close, size: 25112
2012-06-05
03:19
Add SetMemoryStatus instance method to the SQLiteConnection class and the necessary internal infrastructure to support it. Also, fixup several doc comments and bump all versions to 1.0.82.0. file: [a9bf5a7098] check-in: [9ecb2876c2] user: mistachkin branch: trunk, size: 24899
2012-05-04
16:04
Prevent returning a connection handle whose finalizer may be pending on the GC thread. Part of fix for ticket [996d13cd87]. Also, update Eagle in externals to latest trunk. file: [42a70d9d52] check-in: [5c0646db9d] user: mistachkin branch: trunk, size: 23876
2012-05-03
17:15
Obtain a lock on the connection handle prior to finalizing a statement and/or finishing a backup object. file: [1fd782bc39] check-in: [fbf498a216] user: mistachkin branch: trunk, size: 23868
15:11
Fix a couple more potential GC race conditions. file: [e4e861613b] check-in: [ed16f61cf7] user: mistachkin branch: trunk, size: 23670
13:44
Do not attempt to reset a connection if it has been closed. Also, prevent any potential GC race while resetting a connection. Keep track of the total number of connections successfully opened and closed from any of the pools. Enhance test for ticket [996d13cd87] to make sure that at least one connection was opened and closed from a connection pool. file: [d4291d502d] check-in: [7b3fe92dcb] user: mistachkin branch: trunk, size: 23209
06:35
Experimental code to use SafeHandle instead of CriticalHandle for connection handles because they should not be closed until their statements and backup objects are all finalized. file: [1a8ab6ff1d] check-in: [cb270f5cd8] user: mistachkin branch: safeHandle, size: 23743
2012-04-30
17:54
Rename internal SQLiteLastError methods to GetLastError. file: [9829f8b08a] check-in: [5ee7dd00e0] user: mistachkin branch: tkt-996d13cd87, size: 23129
17:45
Add connection handle locking semantics to the SQLiteBase.SQLiteLastError method. file: [f651223272] check-in: [74ccc76eee] user: mistachkin branch: tkt-996d13cd87, size: 23141
17:18
Remove superfluous using statement. file: [b5a1883322] check-in: [b8fb8d4b6a] user: mistachkin branch: tkt-996d13cd87, size: 22989
17:17
Fix potential race condition between SQLiteBase.CloseConnection (via GC) and SQLiteBase.ResetConnection (via pool) when used on the same connection handle object. file: [0434c39b41] check-in: [0ed439a5e7] user: mistachkin branch: tkt-996d13cd87, size: 23016
16:27
Remove superfluous lock from the static helper methods in the SQLiteBase class. file: [6616198f0a] check-in: [c593d21c60] user: mistachkin branch: tkt-996d13cd87, size: 22730
2012-04-29
05:00
Remove superfluous using statement. file: [c1f1b5f849] check-in: [0b2bf29623] user: mistachkin branch: tkt-996d13cd87, size: 22922
04:58
Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection. file: [b5b09000fb] check-in: [9005890cba] user: mistachkin branch: tkt-996d13cd87, size: 22959
03:27
Modify static IsAutocommit method to prevent it from passing IntPtr.Zero to the native library. file: [f5f5096f42] check-in: [5dd7f49382] user: mistachkin branch: tkt-996d13cd87, size: 22653
03:23
Revise handling of CriticalHandle derived classes to make them more thread-safe. file: [b79b4b227f] check-in: [feda13301a] user: mistachkin branch: tkt-996d13cd87, size: 22609
2012-04-07
22:18
Update all versions to 1.0.81.0. Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly. Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec. file: [180cfcf2fe] check-in: [fd6a7e09b8] user: mistachkin branch: trunk, size: 22514
2012-03-24
14:29
Fix semantics of backup handle finalization. Add tests. file: [4d66b87043] check-in: [5522052e80] user: mistachkin branch: backupApi, size: 22487
12:47
More work on the backup API support. file: [269f7cacfa] check-in: [6d5a1889b6] user: mistachkin branch: backupApi, size: 22445
10:05
Start of work on ticket [c71846ed57], supporting the SQLite online backup API. file: [e740d947b1] check-in: [6eac31ab88] user: mistachkin branch: backupApi, size: 22147
2012-02-20
13:48
Make sure that we interrupt any pending SQLite query if a custom collation method throws an exception. Also, enable logging of all callback exceptions by default. file: [b0ff2b03c6] check-in: [afe080eb9a] user: mistachkin branch: trunk, size: 19555
2012-02-19
08:11
Make sure that exceptions are never thrown back to native code from user-provided function and collation implementations. Also, log all such caught callback exceptions if the appropriate connection flag is set. Fix for ticket [8a426d12eb]. Pass connection flags into SQLiteFunction binding method and refactor internal interfaces to support this. Change type of _contextDataList (SQLiteFunction) dictionary keys from long to IntPtr. file: [84663f3b1c] check-in: [6136a92dc5] user: mistachkin branch: logBind, size: 19539
03:49
Add the ability to log all parameter binding activity and refactor the necessary internal interfaces to support this. In the implicit conversion operators to IntPtr for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the object being converted is null. Make sure the SQLiteLog class is not referenced when building for Windows CE. file: [be37a7dc27] check-in: [20e1e255b6] user: mistachkin branch: logBind, size: 19154
2012-01-25
17:09
Add enumerated Flags property to the SQLiteConnection class to control extra behavioral options. file: [fff4f755a4] check-in: [6a90082172] user: mistachkin branch: trunk, size: 18399
2011-12-16
03:32
Start of making sure that all core components containing IDisposable objects implement IDisposable and that they follow the established best-practices when doing so. file: [d5b320c956] check-in: [c532a87e4d] user: mistachkin branch: IDisposablePattern, size: 17885
2011-11-29
07:20
Revise how statement parameter binding handles blittable types. Also, allow binding to unsigned integer and long values that do not fit into their associated signed types. file: [2fc9c69951] check-in: [1ab2413f5d] user: mistachkin branch: trunk, size: 16474
2011-11-16
03:07
Never attempt to configure the native SQLite logging interface if the SQLite core library has already been initialized for the process. Fix for ticket [2ce0870fad]. file: [919e59e331] check-in: [f48d1b0376] user: mistachkin branch: trunk, size: 16298
2011-11-13
21:47
Add MemoryHighwater property to the SQLiteConnection class. Also, enhance unit test infrastructure to report it. file: [bf57ba4cb4] check-in: [6959d8f05a] user: mistachkin branch: trunk, size: 16216
08:59
Add MemoryUsed property to the SQLiteConnection class. Also, report memory in use by the core SQLite library when running the unit test suite. file: [4184336023] check-in: [dd01ee7c55] user: mistachkin branch: trunk, size: 15989
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: [803fd3752d] check-in: [df7dcd3166] user: mistachkin branch: tkt-343d392b51, size: 15812
2011-09-20
21:51
Add LastInsertRowId property to the connection class. Also, update docs and tests. file: [87e6b58562] check-in: [c726454277] user: mistachkin branch: trunk, size: 15787
2011-07-13
16:35
Support the new SQLITE_FCNTL_WIN32_AV_RETRY file control. Add interop project files for static linking to the VC runtime. file: [8552a773f4] check-in: [c90bf3896e] user: mistachkin branch: trunk, size: 15591
2011-07-08
10:22
Make the fix for [e1b2e0f769] more robust for corner cases. file: [ae907e5f2b] check-in: [ce4f34e190] user: mistachkin branch: trunk, size: 15512
2011-07-01
11:36
Remove unused 'using' statements from System.Data.SQLite. file: [adfb5c0ca4] check-in: [b270e24e93] user: mistachkin branch: build-enhancements, size: 15346
2011-04-26
03:56
Added LogMessage() to expose the sqlite3_log() interface. file: [7a937ff03d] check-in: [d908d628e8] user: shaneh branch: trunk, size: 15446
2011-04-22
18:08
Initial implementation of SQLITE_CONFIG_LOG interface. file: [39566f6a30] check-in: [fc3e41ac85] user: shaneh branch: trunk, size: 14957
2011-04-15
17:33
Added support for sqlite3_extended_result_codes(), sqlite3_errcode(), and sqlite3_extended_errcode(). file: [d6a2c908a4] check-in: [41ad3433f5] user: shaneh branch: trunk, size: 13677
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: [32961c5888] check-in: [644aeca13c] user: shaneh branch: vs2010, size: 12839
2010-08-05
02:03
1.0.66.0 file: [b09058d60c] check-in: [7ec6a118ce] user: rmsimpson branch: sourceforge, size: 12497
2009-06-29
22:59
1.0.63.0 file: [e6cb621381] check-in: [26297c39cc] user: rmsimpson branch: sourceforge, size: 12437
2008-09-22
16:27
1.0.59.0 file: [21ee588377] check-in: [147afad4ff] user: rmsimpson branch: sourceforge, size: 12239
2008-09-02
15:46
pre 1.0.59.0 file: [ad95d483b6] check-in: [c0dab1edea] user: rmsimpson branch: sourceforge, size: 12118
2008-08-06
21:40
1.0.55.0 file: [308e381940] check-in: [24425920c8] user: rmsimpson branch: sourceforge, size: 11933
2008-07-24
06:19
1.0.53.0 file: [a8d23897e5] check-in: [2b553f96c4] user: rmsimpson branch: sourceforge, size: 10542
2008-07-16
23:32
1.0.52.0 file: [aadab2087c] check-in: [1084c98790] user: rmsimpson branch: sourceforge, size: 10438
2007-09-25
22:45
1.0.45.0 file: [b346931e86] check-in: [5a232b012b] user: rmsimpson branch: sourceforge, size: 9946
2007-04-22
23:23
1.0.41.0 file: [464a64dd65] check-in: [06c93533ad] user: rmsimpson branch: sourceforge, size: 9389
2006-11-18
22:21
1.0.37.0 file: [4a65d68786] check-in: [98df3968b8] user: rmsimpson branch: sourceforge, size: 8876
2006-10-23
21:28
1.0.36.0 file: [caf8f69608] check-in: [b23bfc47c3] user: rmsimpson branch: sourceforge, size: 8700
2006-08-06
17:55
1.0.32.0 file: [54084bf868] check-in: [6b4fd5077c] user: rmsimpson branch: sourceforge, size: 10159
2006-07-02
06:45
1.0.30.0 file: [6623c6e825] check-in: [c03b78555a] user: rmsimpson branch: sourceforge, size: 10038
2006-04-11
18:02
64-bit fixes file: [36c9b6d8eb] check-in: [5dea167156] user: rmsimpson branch: sourceforge, size: 10086
2006-03-27
17:05
Fix GetValue to retrieve guids properly file: [f7683d14fb] check-in: [8ad750184a] user: rmsimpson branch: sourceforge, size: 10030
2006-02-11
15:19
1.0.26.0 file: [578d61e93f] check-in: [5cdbe425f7] user: rmsimpson branch: sourceforge, size: 9939
2006-02-10
19:44
Lots of schema fixes and support for new 3.3.4 stuff file: [2998765b2c] check-in: [9e6e1cf6df] user: rmsimpson branch: sourceforge, size: 10596
2006-01-10
18:41
Supports encrypted databases file: [723ac0c204] check-in: [0b89858658] user: rmsimpson branch: sourceforge, size: 10150
2005-12-07
22:40
Fix over-aggressive preparation of statements before execution file: [b731c4cdbd] check-in: [ba2464b7f6] user: rmsimpson branch: sourceforge, size: 10019
2005-10-19
17:17
1.0.20 file: [98fa9ea414] check-in: [ff09f9f46e] user: rmsimpson branch: sourceforge, size: 10418
2005-08-16
19:12
1.0.14 file: [499404e46f] check-in: [4453746b7a] user: rmsimpson branch: sourceforge, size: 10101
2005-08-04
15:25
1.0.12 updates and cleanup file: [b5a97a0ad6] check-in: [3ebf811b1e] user: rmsimpson branch: sourceforge, size: 10098
2005-08-03
06:43
1.0.12 updates file: [d9868e95a7] check-in: [e269288997] user: rmsimpson branch: sourceforge, size: 10088
2005-03-24
19:37
1.08 Refresh, added documentation file: [fc0a7f96a2] check-in: [b56fd4b082] user: rmsimpson branch: sourceforge, size: 10027
2005-03-04
21:30
Added more internal-use utility type conversion helpers file: [1627c62708] check-in: [1f38aec2e8] user: rmsimpson branch: sourceforge, size: 9567
2005-03-02
15:56
Added future support for sqlite3_interrupt file: [fb4f6d8aec] check-in: [ffba634160] user: rmsimpson branch: sourceforge, size: 9004
2005-03-01
16:04
Added: Initial revision file: [e5360bb7da] check-in: [ec237b0123] user: rmsimpson branch: sourceforge, size: 8966