Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for System.Data.SQLite/SQLiteCommand.cs
|
2024-11-19
| ||
| 18:01 | Preliminary work on adding more 'Changed' event types. file: [c64926f066] check-in: [a55cf38927] user: mistachkin branch: trunk, size: 62632 | |
|
2024-07-03
| ||
| 16:16 | Add the IncludeDefaultFlags connection string property, enabled by default. Make test 'pool-2.1' stricter. file: [1e17cf4092] check-in: [5beb96136e] user: mistachkin branch: trunk, size: 62014 | |
|
2024-07-02
| ||
| 05:10 | Add the AggressiveDisposal connection flag. Other pre-release fixes. file: [4152869adc] check-in: [8d439ebdde] user: mistachkin branch: trunk, size: 61745 | |
|
2024-07-01
| ||
| 21:42 | Follow-up to experimental (and broken) check-in [73602c161a], further changes to statement disposal, pursuant to connection pool stress issues. file: [ad0dd1b99e] check-in: [0ed2dd7edd] user: mistachkin branch: trunk, size: 61025 | |
|
2024-06-30
| ||
| 14:41 | Experimental robustness enhancements to the command and data reader disposal semantics. file: [d8b91208a2] check-in: [73602c161a] user: mistachkin branch: trunk, size: 60283 | |
|
2024-06-26
| ||
| 16:26 | Add support for the 'SQLite_TraceCategories' environment variable. file: [25b19a451b] check-in: [37849c1af4] user: mistachkin branch: trunk, size: 59539 | |
|
2024-05-24
| ||
| 21:20 | Ignore disposal status of the connection when checking whether the DisposedConnection / FinalizedConnection event sub-types for the Changed event should be raised. file: [931d1bf4bf] check-in: [954385b694] user: mistachkin branch: trunk, size: 59490 | |
|
2024-05-23
| ||
| 23:15 | Work-in-progress on addressing forum post 25cafb35e5. file: [936fc73344] check-in: [6d7348176c] user: mistachkin branch: pst-25cafb35e5, size: 59469 | |
|
2023-07-31
| ||
| 06:02 | Minor coding style changes to the SQLiteCommand.Connection property setter. file: [1393fb2353] check-in: [8b7fbfe97f] user: mistachkin branch: trunk, size: 59205 | |
|
2023-06-09
| ||
| 16:38 | Fix compilation issues for the .NET Compact Framework 2.0. file: [c41c26ac18] check-in: [47564c00f6] user: mistachkin branch: trunk, size: 59289 | |
|
2023-05-15
| ||
| 18:55 | Add the 'SQLite_GlobalCommandBehaviors' setting to augment command behaviors applicable to all ExecuteNonQuery, ExecuteScalar, and ExecuteReader calls. file: [d536248dde] check-in: [5e1ccca997] user: mistachkin branch: trunk, size: 59022 | |
| 04:47 | Corrections to the SQLiteCommand.GetDiagnostics testing support method. file: [7e0402382e] check-in: [044f07f543] user: mistachkin branch: trunk, size: 56645 | |
| 04:17 | Attempt to make corrections to the number of records affected by queries. Pursuant to forum post [f4e718891d]. file: [d837471dee] check-in: [ea4c3f4f82] user: mistachkin branch: trunk, size: 55862 | |
| 01:28 | Missed one. file: [8cd25e3460] check-in: [0eb43a337d] user: mistachkin branch: trunk, size: 55842 | |
| 01:27 | Fix comment and minor coding style. file: [1fefa3da5d] check-in: [399f5b8068] user: mistachkin branch: trunk, size: 55843 | |
| 01:22 | Modularize and extend the recent Read() fix for ExecuteScalar to the ExecuteNonQuery methods as well, with tests. file: [8380207e7a] check-in: [b71ee43a09] user: mistachkin branch: trunk, size: 55862 | |
|
2023-05-14
| ||
| 18:00 | Fix spacing. file: [9298f0fb92] check-in: [34a0a2aa7c] user: mistachkin branch: trunk, size: 53532 | |
| 01:32 | Add comments. Also, make it possible to force extra reads to occur, i.e. for non-write transactions. file: [46d42abe2f] check-in: [4666149ec7] user: mistachkin branch: trunk, size: 53542 | |
| 01:08 | Make it possible to opt-out of the handling added to the ExecuteScalar method for write transactions that require more than one step. file: [7457d952dd] check-in: [bd594a1673] user: mistachkin branch: trunk, size: 51417 | |
|
2023-05-13
| ||
| 22:25 | Further refinements to the fix from check-in [8c9e834b95]. file: [828c374a63] check-in: [faffabbd80] user: mistachkin branch: trunk, size: 46106 | |
| 21:21 | Further refinements to retry logic. Also, restrict the fix from check-in [8c9e834b95] to only be active for write transactions. file: [b86558b70f] check-in: [2a78948bf0] user: mistachkin branch: trunk, size: 46083 | |
| 17:36 | Experimental fix for the INSERT RETURNING issue from forum post f4e718891d. file: [2bb50e8dee] check-in: [8c9e834b95] user: mistachkin branch: trunk, size: 44883 | |
| 05:54 | In Prepare, read the retry properties from the command, not the connection. file: [6a9abb0820] check-in: [8800b650c8] user: mistachkin branch: trunk, size: 44780 | |
|
2023-05-12
| ||
| 23:38 | Improve internal accounting of retry logic. file: [16d72d2dfb] check-in: [0852d4ef63] user: mistachkin branch: trunk, size: 43689 | |
| 22:28 | Add the 'StepRetries' connection string property. Also, revise how the 'PrepareRetries' connection string property works internally. file: [d90c92d2da] check-in: [98877b1863] user: mistachkin branch: trunk, size: 42303 | |
| 21:29 | Add the LogRetry connection flag and the SQLite_ForceLogRetry environment variable. file: [ab6bf63870] check-in: [1162d19e69] user: mistachkin branch: trunk, size: 42159 | |
|
2023-01-18
| ||
| 05:09 | Add the SqlStringPreview connection event type. file: [d8e8645a1c] check-in: [4188296299] user: mistachkin branch: trunk, size: 42156 | |
|
2022-07-20
| ||
| 19:35 | Further refinements. file: [14a076ca69] check-in: [8f81d1b191] user: mistachkin branch: windowFunc, size: 41737 | |
|
2021-10-12
| ||
| 21:39 | Modify visibility of an internal static field. file: [dfa8b5993d] check-in: [374d0c963e] user: mistachkin branch: trunk, size: 40996 | |
|
2020-02-02
| ||
| 04:18 | Add an overload of the static Execute method to the SQLiteCommand class that accepts an open connection. file: [38ddbd8225] check-in: [344a8bd45f] user: mistachkin branch: trunk, size: 40995 | |
|
2016-06-15
| ||
| 20:22 | Prevent the SQLiteCommand.ExecuteScalar method from throwing an exception when there are no result columns. file: [8149058714] check-in: [29e1de6a30] user: mistachkin branch: trunk, size: 38159 | |
|
2016-06-02
| ||
| 19:35 | Add VerifyOnly method to the SQLiteCommand class. file: [90dcca79d4] check-in: [36669ce629] user: mistachkin branch: trunk, size: 38132 | |
|
2015-08-28
| ||
| 22:16 | Fix implementation and tests for SQLiteCommand.Reset method. Remove (now) superfluous new code. file: [ff35e1abe6] check-in: [6fa1fe8314] user: mistachkin branch: cmdReset, size: 35978 | |
| 20:26 | Work in progress on exerpimental method to reset the statements associated with a SQLiteCommand. file: [8323778914] check-in: [f12609cfe9] user: mistachkin branch: cmdReset, size: 35730 | |
|
2015-03-26
| ||
| 20:38 | When creating a parameter associated with a specific command, keep track of that command. file: [dbc59162b5] check-in: [64d7e6903e] user: mistachkin branch: trunk, size: 33704 | |
|
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: [61eb9c3f0b] check-in: [5b359db222] user: mistachkin branch: interopParams2, size: 33510 | |
|
2014-11-07
| ||
| 23:48 | Defer disposing of the connection created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a]. file: [f0f3f4e876] check-in: [ad79758d0c] user: mistachkin branch: trunk, size: 33510 | |
|
2014-09-26
| ||
| 04:01 | Change the type of all '_version' fields to simply 'int' instead of 'long', which will hopefully result in a small speed increase. file: [e5e8ebcea8] check-in: [ffbc71c72b] user: mistachkin branch: experimental, size: 30484 | |
|
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: [e9d6948e25] check-in: [26a20dd470] user: mistachkin branch: interopParams, size: 30485 | |
|
2014-03-06
| ||
| 08:12 | Raise the static SQLiteConnection.Changed event when any SQLiteCommand or SQLiteDataReader object is disposed. file: [88f29a08ed] check-in: [6eea79dc10] user: mistachkin branch: trunk, size: 30485 | |
|
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: [dad394fdf2] check-in: [16f09dbc53] user: mistachkin branch: trunk, size: 30262 | |
|
2013-09-13
| ||
| 01:38 | Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter. file: [2a48fdffc9] check-in: [00b02c1aa6] user: mistachkin branch: trunk, size: 30288 | |
|
2013-09-06
| ||
| 04:29 | Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for [aba4549801]. Update Eagle in externals to pickup fixes necessary for testing. file: [425cbdf7fe] check-in: [7e2f11fd49] user: mistachkin branch: trunk, size: 27225 | |
|
2013-09-05
| ||
| 05:26 | Move the statement list disposal code in the SQLiteCommand class into its own method. file: [36cf845480] check-in: [f629afe04c] user: mistachkin branch: trunk, size: 27202 | |
|
2013-09-04
| ||
| 03:42 | Allow monitoring of the creation of all critical handle derived class instances. file: [c9cc664545] check-in: [b194408bb5] user: mistachkin branch: onChanged, size: 26921 | |
|
2013-07-15
| ||
| 05:54 | Fix SQLiteCommand object disposal issue revealed by the previous check-in. file: [8377a461a9] check-in: [db65a60fcf] user: mistachkin branch: marshalFixes, size: 26898 | |
| 05:16 | Modify classes implementing the IDisposable pattern to set the disposed flag after their base classes have been disposed. file: [c5596a4a1b] check-in: [db3a299625] user: mistachkin branch: marshalFixes, size: 26726 | |
|
2013-03-22
| ||
| 23:40 | Add GetAllAsText connection flag to force all column values to be returned as text. Pursuant to [e06c4caff3]. file: [200b36d17e] check-in: [2cd9814a44] user: mistachkin branch: trunk, size: 26625 | |
|
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: [3c9d90867b] check-in: [b2c5c6e2a0] user: mistachkin branch: trunk, size: 25580 | |
|
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: [8e465681f4] check-in: [5759e099be] user: mistachkin branch: trunk, size: 22225 | |
|
2012-07-22
| ||
| 06:54 | Remove all superfluous UTF-8 byte-order-marks. file: [ad55c53c05] check-in: [2c82e6c1a3] user: mistachkin branch: trunk, size: 22064 | |
|
2012-07-12
| ||
| 07:11 | Add support for internal state checking at key points in the public classes that use a connection. Also, adjust the number of iterations for the stress test. file: [cde6de4797] check-in: [007a7bb78f] user: mistachkin branch: trunk, size: 22067 | |
|
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: [85c0c2cac0] check-in: [c532a87e4d] user: mistachkin branch: IDisposablePattern, size: 21473 | |
|
2011-11-15
| ||
| 04:01 | Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite core library source identifier. Enhance and revising Trace output (in DEBUG only) to be more accurate and to report resource cleanup exceptions. More work on unit testing infrastructure and the test case for ticket [e30b820248]. The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer. file: [153888ae4f] check-in: [1808779aa2] user: mistachkin branch: tkt-e30b820248, size: 19491 | |
|
2011-07-07
| ||
| 10:05 | Isolate the hard-coding of the VS designer version number. Normalize all the project web site URLs to end with a slash. file: [a83d4b2e05] check-in: [20d41af53e] user: mistachkin branch: trunk, size: 19369 | |
|
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: [2f7e7db78c] check-in: [644aeca13c] user: shaneh branch: vs2010, size: 19346 | |
|
2010-08-05
| ||
| 02:03 | 1.0.66.0 file: [c737193a70] check-in: [7ec6a118ce] user: rmsimpson branch: sourceforge, size: 18707 | |
|
2009-07-10
| ||
| 04:43 | 1.0.64.0 file: [417bd61719] check-in: [de1a94066c] user: rmsimpson branch: sourceforge, size: 18737 | |
|
2008-09-02
| ||
| 15:46 | pre 1.0.59.0 file: [87c670d9f4] check-in: [c0dab1edea] user: rmsimpson branch: sourceforge, size: 18718 | |
|
2008-08-11
| ||
| 21:12 | 1.0.56.0 file: [cbec05e622] check-in: [faaaeb7bd7] user: rmsimpson branch: sourceforge, size: 18748 | |
|
2008-08-06
| ||
| 21:40 | 1.0.55.0 file: [a2e0f94134] check-in: [24425920c8] user: rmsimpson branch: sourceforge, size: 19375 | |
|
2008-07-24
| ||
| 06:19 | 1.0.53.0 file: [1eaff6f9d5] check-in: [2b553f96c4] user: rmsimpson branch: sourceforge, size: 19375 | |
|
2008-07-16
| ||
| 23:32 | 1.0.52.0 file: [9b4bf5f2e8] check-in: [1084c98790] user: rmsimpson branch: sourceforge, size: 19375 | |
|
2008-05-28
| ||
| 08:18 | 1.0.49.0 file: [dcb835876b] check-in: [f3f45cefd1] user: rmsimpson branch: sourceforge, size: 19185 | |
|
2007-12-04
| ||
| 16:07 | 1.0.47.0 file: [7afe20fc98] check-in: [7518ccfcff] user: rmsimpson branch: sourceforge, size: 19116 | |
|
2007-10-01
| ||
| 03:25 | 1.0.46.0 file: [fc368a6009] check-in: [67f18e8aaa] user: rmsimpson branch: sourceforge, size: 19107 | |
|
2007-09-25
| ||
| 22:45 | 1.0.45.0 file: [68fbf3ad79] check-in: [5a232b012b] user: rmsimpson branch: sourceforge, size: 19004 | |
|
2007-04-22
| ||
| 23:23 | 1.0.41.0 file: [00b9f788eb] check-in: [06c93533ad] user: rmsimpson branch: sourceforge, size: 18591 | |
|
2007-01-12
| ||
| 02:42 | 1.0.39.1 file: [bd1976e4cf] check-in: [7661398d85] user: rmsimpson branch: sourceforge, size: 17892 | |
|
2007-01-10
| ||
| 14:49 | 1.0.39.0 file: [af21a2bcbd] check-in: [e8355ff70e] user: rmsimpson branch: sourceforge, size: 17892 | |
|
2006-09-11
| ||
| 21:15 | 1.0.35.1 file: [db02bf4637] check-in: [e57d6e37d5] user: rmsimpson branch: sourceforge, size: 17904 | |
|
2006-09-10
| ||
| 19:27 | 1.0.35.0 file: [e5662348ac] check-in: [0bebedcaf5] user: rmsimpson branch: sourceforge, size: 17758 | |
|
2006-07-16
| ||
| 17:43 | 1.0.31.0 - scalar function returns null instead of dbnull file: [e8533706d3] check-in: [f96ea449db] user: rmsimpson branch: sourceforge, size: 17615 | |
|
2006-05-16
| ||
| 13:39 | 1.0.29.0 file: [cde8ebec6f] check-in: [9eac19ba95] user: rmsimpson branch: sourceforge, size: 17594 | |
|
2006-04-13
| ||
| 19:35 | 1.0.28.0 fixes file: [095f0c79dc] check-in: [55fffe0c75] user: rmsimpson branch: sourceforge, size: 17594 | |
|
2006-04-12
| ||
| 05:47 | 1.0.28.0 prep file: [91ab42bdb4] check-in: [49268d8c86] user: rmsimpson branch: sourceforge, size: 17528 | |
|
2006-02-26
| ||
| 18:26 | 1.0.27.0 final file: [7c38257b29] check-in: [add85aba10] user: rmsimpson branch: sourceforge, size: 17528 | |
|
2006-02-25
| ||
| 07:50 | Work in progress file: [b7a5561a64] check-in: [059f612efa] user: rmsimpson branch: sourceforge, size: 17460 | |
|
2006-02-24
| ||
| 06:07 | work in progress file: [231d3c840e] check-in: [1283114bab] user: rmsimpson branch: sourceforge, size: 17490 | |
| 02:58 | no message file: [08df09cc18] check-in: [aef54e6441] user: rmsimpson branch: sourceforge, size: 17279 | |
|
2006-02-14
| ||
| 19:41 | 1.0.26.1 file: [21d9def6fb] check-in: [0cff10df69] user: rmsimpson branch: sourceforge, size: 15743 | |
|
2006-02-10
| ||
| 15:08 | Fixed a dispose issue for commands with active readers file: [b0fac8b068] check-in: [505e5291d5] user: rmsimpson branch: sourceforge, size: 15942 | |
|
2006-01-27
| ||
| 05:55 | First shot at nested transactions and transaction enlistment file: [aa15df1703] check-in: [9e2d3ca71a] user: rmsimpson branch: sourceforge, size: 15713 | |
|
2006-01-06
| ||
| 16:46 | Fix Connection property to allow setting to null, and fix Dispose method to erase the command from the connection file: [a335f292bd] check-in: [5514a73a4e] user: rmsimpson branch: sourceforge, size: 15430 | |
|
2005-12-07
| ||
| 22:40 | Fix over-aggressive preparation of statements before execution file: [5badc60f26] check-in: [ba2464b7f6] user: rmsimpson branch: sourceforge, size: 15418 | |
|
2005-08-31
| ||
| 22:00 | Minor tweaks file: [f6a94c75f1] check-in: [409cdff9bc] user: rmsimpson branch: sourceforge, size: 15011 | |
|
2005-08-30
| ||
| 16:52 | Added new overrides to remove any necessary casting by end-users file: [e5cbf5dbce] check-in: [c8fd4d6f09] user: rmsimpson branch: sourceforge, size: 14902 | |
|
2005-08-16
| ||
| 19:12 | 1.0.14 file: [f8bffa0184] check-in: [4453746b7a] user: rmsimpson branch: sourceforge, size: 14009 | |
|
2005-08-04
| ||
| 15:25 | 1.0.12 updates and cleanup file: [872886b6dd] check-in: [3ebf811b1e] user: rmsimpson branch: sourceforge, size: 12839 | |
|
2005-08-03
| ||
| 06:43 | 1.0.12 updates file: [e960f81e6b] check-in: [e269288997] user: rmsimpson branch: sourceforge, size: 12507 | |
|
2005-08-01
| ||
| 19:23 | 1.11 updates file: [232841d3fa] check-in: [e79f975b58] user: rmsimpson branch: sourceforge, size: 12431 | |
|
2005-05-25
| ||
| 22:19 | VersionInfo and documentation updates file: [6938c3b9bb] check-in: [fa8370b96e] user: rmsimpson branch: sourceforge, size: 12448 | |
|
2005-03-24
| ||
| 19:37 | 1.08 Refresh, added documentation file: [3c54d69f2b] check-in: [b56fd4b082] user: rmsimpson branch: sourceforge, size: 12511 | |
|
2005-03-04
| ||
| 21:30 | Increased performance ExecuteScalar() and ExecuteNonQuery() resulting in a nice boost in the insert 100k rows tests and user-function tests file: [1e134c25ef] check-in: [5f06409677] user: rmsimpson branch: sourceforge, size: 10608 | |
|
2005-03-02
| ||
| 23:10 | Misc. code optimizations file: [24ac4ca5e1] check-in: [bf66bbedce] user: rmsimpson branch: sourceforge, size: 9498 | |
| 15:57 | Changed Cancel() -- should not throw an error even if not implemented file: [d3fdf09628] check-in: [f35dd3aa68] user: rmsimpson branch: sourceforge, size: 9423 | |
|
2005-03-01
| ||
| 16:04 | Added: Initial revision file: [20d7206d71] check-in: [ec237b0123] user: rmsimpson branch: sourceforge, size: 9466 | |