bgcolor # mtime type status resolution priority severity subsystem title #e8e8e8 caccdc5332 2014-11-08 02:05:12 Feature_Request Review Open Medium Important VsDesigner VS-TableDesigner looses foreign key constraint names #e8e8e8 487741add1 2014-11-08 02:04:57 Feature_Request Review Open Medium Important VsDesigner VS-TableDesigner looses WITHOUT ROWID #e8e8e8 9ed18c6ae3 2014-11-08 02:04:45 Feature_Request Review Open Medium Important VsDesigner VS-TableDesigner looses partial indexes #e8e8e8 6d5cdbd91d 2014-11-08 02:04:20 Feature_Request Review Open Medium Important VsDesigner VS-TableDesigner creates wrong foreign key constraints #c8c8c8 ce4d70ea6f 2022-07-07 03:43:12 Code_Defect Pending Fixed Medium Important Connection SQLiteConnection does not appear to dispose of _sql field, might be a memory leak #c8c8c8 14228ed006 2022-01-13 15:33:26 Incident Pending Pending_Reproduction Medium Important Connection Dispose problem on read only file. #c8c8c8 009ea91ce9 2022-01-27 05:56:13 Incident Pending Under_Review Medium Important Data_Reader SQLiteDataAdapter.FillSchema problem with left joined tables #f2dcdc 070b05bef9 2021-01-12 11:50:41 Feature_Request Open Important SQLiteDataReader.IsDBNull(-1) should throw an exception #f2dcdc 07ab75483c 2012-12-24 00:16:13 Feature_Request Open External_Bug Low Important VsDesignerInstaller Cannot install VS 2008/2010 design-time components side-by-side #f2dcdc 84cf1f4917 2018-01-24 19:56:04 Feature_Request Open Open Low Minor Db_Type_Conversion Please add support for DateTimeOffset #f2dcdc c5838530b8 2011-10-26 13:27:18 Feature_Request Open Open Low Minor LINQ APPLY Joins are not supported #f2dcdc 4fceac257e 2013-07-19 22:32:11 Feature_Request Open Not_Backwards_Compatible Low Minor Native_Assembly SQLITE_ENABLE_FTS3_PARENTHESIS #f2dcdc ccb2891dc8 2013-05-23 10:05:58 Feature_Request Open Open Low Minor Native_Assembly Compile with SQLITE_SOUNDEX to enable soundex(X) function generally #f2dcdc 2cd99601e6 2018-01-24 08:27:31 Feature_Request Open Open Low Minor None BulkCopy support #f2dcdc 9ac7d2c07e 2012-12-29 06:14:16 Feature_Request Open Workaround Low Minor VsDesigner Problem with table designer within VS 2010 #f2dcdc dbbacbd841 2013-04-19 13:58:12 Feature_Request Open Open Medium Cosmetic Integration_Via_PInvoke Make builds with both native interop files as linked resources #f2dcdc e073a5bc7c 2013-07-19 22:16:43 Feature_Request Open Not_Backwards_Compatible Medium Cosmetic None Add possibility to distinguish exceptions #f2dcdc f4d358993c 2016-03-21 23:03:38 Feature_Request Open Under_Review Medium Important Connection Provide an implementation of OpenAsync #f2dcdc 2b823bfe08 2015-01-28 18:16:55 Feature_Request Open Not_Backwards_Compatible Medium Important Data_Reader Reading NULL from double column should return NaN #f2dcdc 2bfd91266a 2021-05-04 07:21:20 Performance Open Under_Review Medium Important Integration_Via_PInvoke CPU is burned when parallel work is done #f2dcdc a39cd89d85 2014-08-01 18:42:23 Feature_Request Open Under_Review Medium Important Integration_Via_PInvoke Allow configuration of threading mode #f2dcdc 8f05349da7 2019-04-03 08:59:16 Feature_Request Open Under_Review Medium Important LINQ Support for windowing functions in Sqlite EF6 #f2dcdc 919a8c2a91 2017-11-13 17:43:20 Feature_Request Open Under_Review Medium Important LINQ System.Data.SQLite.EF6 & DateTimeOffset #f2dcdc 76c2eaadc0 2015-04-24 15:22:22 Feature_Request Open Under_Review Medium Important LINQ No such function: BigCount #f2dcdc eb0cada674 2014-05-22 16:52:03 Feature_Request Open Under_Review Medium Important LINQ DeleteDatabase method not supported #f2dcdc d17f503188 2019-02-26 01:23:53 Feature_Request Open Under_Review Medium Important Native_Assembly .NET Core 2.x ARM 32bit support for linux based devices #f2dcdc 4e0608662b 2018-11-14 03:06:50 Feature_Request Open Under_Review Medium Important Native_Assembly How do you modify the default limits? #f2dcdc bca2ac9de9 2018-10-22 12:11:42 Feature_Request Open Under_Review Medium Important Native_Assembly Add ARM support with .NET Core 2.0/2.1 #f2dcdc d18b2679ec 2014-11-05 18:59:20 Feature_Request Open Open Medium Important None typeof() based mapping of SQLiteDateFormats for ConnectionString #f2dcdc dcfa77e180 2016-04-29 21:19:11 Feature_Request Open Under_Review Medium Important NuGetPackage Use standard sqlite3.dll in NuGet packages #f2dcdc 1ec39fe4bd 2013-07-19 22:16:12 Feature_Request Open Not_Backwards_Compatible Medium Minor Connection SQLiteConnection.GetSchema ForeignKeys metadata collection returns incorrect FK constraint names #cacae5 6d8a515408 2014-10-17 15:06:35 Performance Deferred Under_Review Low Minor Data_Reader SQLiteDataReader.GetSchemaTable is very slow #cacae5 a6bfb32a36 2016-01-28 20:45:21 Feature_Request Deferred Open Medium Cosmetic None Allow Custom Data Mapper #cacae5 f9010bdcf9 2020-10-29 02:33:27 Performance Deferred Need_More_Info Medium Critical Native_Assembly Query execution takes longer time with System.Data.Sqlite1.0.113.0 and the same executes faster with 1.0.66.0 version dll #cacae5 2f9f7025e2 2021-05-02 18:21:22 Feature_Request Deferred Under_Review Medium Important Build_AndOr_Projects Precompiled Statically-Linked Binaries for .NET Framework 4.8 #cacae5 fbbccf88bd 2017-09-06 09:25:14 Feature_Request Deferred Need_More_Info Medium Important Build_AndOr_Projects Support .NET Core #cacae5 2568cd294a 2015-01-26 18:51:46 Feature_Request Deferred Missing_Tools_Or_Sdk Medium Important Build_AndOr_Projects System.Data.SQLite on Windows CE x86 with .NET3.5 #cacae5 e38eb0faa8 2017-08-11 21:02:11 Feature_Request Deferred Under_Review Medium Important Connection Open DB from given IStream (or something more clever?) #cacae5 6315daaa7a 2019-10-19 19:25:35 Incident Deferred Under_Review Medium Important Data_Adapter DataAdapter.Update method need so long #cacae5 7b35bf9c24 2020-04-06 21:43:26 Performance Deferred Under_Review Medium Important Data_Reader CheckClosed() serious performance hit #cacae5 7b0e16c1d1 2017-01-05 05:47:15 Performance Deferred Need_More_Info Medium Important Data_Reader Performance of GetSchemaTable() depends heavily on number of indizes in the database #cacae5 f199b0fd29 2016-10-10 20:14:22 Performance Deferred Under_Review Medium Important Data_Reader Suggest that SQLiteDataReaderValue should be a union #cacae5 db4515dc34 2015-05-22 18:55:48 Feature_Request Deferred Works_As_Designed Medium Important Data_Reader Wrong constraints reported. #cacae5 d3d0e0e5e0 2020-03-05 01:02:40 Feature_Request Deferred Need_More_Info Medium Important Db_Type_Conversion Support SQL Server "rowversion" data type #cacae5 feb95c6ec0 2020-10-28 01:43:47 Performance Deferred Open Medium Important Integration_Via_PInvoke SQLiteConnection.open perf issue, in SQLite 3.32.1 #cacae5 ec2bfa16f1 2019-06-03 13:42:44 Feature_Request Deferred Under_Review Medium Important Integration_Via_PInvoke Add support async/await #cacae5 5ce9595972 2018-03-14 14:43:22 Feature_Request Deferred Open Medium Important Integration_Via_PInvoke Feature add pre update event #cacae5 97d1fee4aa 2017-08-10 20:32:32 Feature_Request Deferred Under_Review Medium Important Integration_Via_PInvoke VFS support #cacae5 3e25b51c82 2016-06-21 20:18:19 Feature_Request Deferred Works_As_Designed Medium Important Integration_Via_PInvoke SQLiteUpdateEventHandler without rowid #cacae5 bbdcff2284 2016-02-25 19:56:22 Feature_Request Deferred Open Medium Important Integration_Via_PInvoke Support for custom FTS tokenizers #cacae5 d109559938 2020-10-28 01:43:00 Feature_Request Deferred Open Medium Important LINQ NotSupportedException: APPLY joins are not supported #cacae5 988e2d6107 2019-01-15 15:56:33 Incident Deferred Need_More_Info Medium Important LINQ EF6 implementation does not work as expected #cacae5 320effb28c 2017-10-16 03:02:32 Feature_Request Deferred Under_Review Medium Important LINQ SQLiteProviderManifest ignores precision on DateTime value #cacae5 ab69552447 2017-05-11 19:51:14 Feature_Request Deferred Under_Review Medium Important LINQ Incorrect APPLY JOIN #cacae5 104723107d 2017-04-03 23:25:24 Performance Deferred Open Medium Important LINQ Very slow running all operation if the database located on a shared folder #cacae5 ad007dc72a 2016-09-09 20:15:06 Feature_Request Deferred Under_Review Medium Important LINQ EF6 code-based configuration #cacae5 1a93312113 2016-06-21 20:21:32 Feature_Request Deferred Need_More_Info Medium Important LINQ The Any() query fails But Contains() query runs well. What is the Problem? #cacae5 488d0aca46 2015-11-28 15:48:26 Feature_Request Deferred Mailing_List Medium Important LINQ Is it possible auto update the sqlite schema and update/add the tables and FX and Index? #cacae5 3289ab0450 2015-05-16 23:16:38 Performance Deferred Open Medium Important LINQ Bad performance of query generation for Contains #cacae5 6b5ef4ff7a 2014-11-04 07:20:40 Feature_Request Deferred Open Medium Important LINQ Add support for Entity Framework 6 Code First Migrations #cacae5 537b718e1b 2016-02-15 20:09:33 Feature_Request Deferred Rejected Medium Important Legacy_CryptoAPI Use of RC4 for database encryption #cacae5 d9f9223b79 2020-10-24 19:05:03 Feature_Request Deferred Open Medium Important Native_Assembly DLL not found exception when publishing as a single file for arm via visual studio #cacae5 fc3c46bb07 2019-10-05 03:38:34 Feature_Request Deferred Works_As_Designed Medium Important Native_Assembly SQLite.Interop.dll not found when using System.Data.SQLite.Core NuGet package with Xamarin #cacae5 1b3f42cfc5 2019-03-22 01:33:58 Feature_Request Deferred Under_Review Medium Important Native_Assembly Failing Windows App Cert Kit #cacae5 091de1d638 2016-01-28 20:45:06 Feature_Request Deferred Open Medium Important None Support .NET Core and EF7 #cacae5 788fe7b885 2015-06-17 18:39:13 Feature_Request Deferred Open Medium Important None Working with System.Data.Sqlite on Mac OsX #cacae5 ef6d8c2897 2014-07-11 18:21:54 Feature_Request Deferred Open Medium Important None Add support for Universal Apps #cacae5 942ab10de2 2016-06-16 02:42:51 Feature_Request Deferred Not_Backwards_Compatible Medium Important NuGetPackage Make nuget package support asp.net core #cacae5 f37ca75121 2015-06-03 02:37:18 Feature_Request Deferred Under_Review Medium Important NuGetPackage EF6 Model-First SQL code generation error! #cacae5 f713a6b495 2014-09-09 18:11:33 Feature_Request Deferred Under_Review Medium Important NuGetPackage NuGet packages #cacae5 a99252c116 2017-10-16 03:08:03 Performance Deferred Under_Review Medium Important Statement Performance issue when using multiple SQLiteCommandParameter #cacae5 bc7dc46b0b 2017-06-09 22:38:56 Feature_Request Deferred Under_Review Medium Important Virtual_Table DeclareTable returning "not and error" for WITHOUT ROWID virtual tables #cacae5 d5167367fe 2015-02-05 20:25:37 Feature_Request Deferred Under_Review Medium Important VsDesigner Designer from Database : OnDelete property value missing #cacae5 857e8a8fe7 2014-12-05 22:19:06 Feature_Request Deferred Open Medium Important VsDesigner Foreign key with multiple columns #cacae5 0e33c39e05 2015-03-05 00:39:37 Feature_Request Deferred Rejected Medium Minor Integration_Via_PInvoke Locked interop DLLs when dealing with IIS #cacae5 db4a4b99e4 2016-09-05 20:14:45 Feature_Request Deferred Under_Review Medium Minor None Full support of extensions for System.Data.SQLite #cacae5 db7a713f4f 2015-07-06 13:30:25 Feature_Request Deferred Not_Backwards_Compatible NextRelease Important NuGetPackage Change nuget build targets to use 'Content' rather than 'Copy' and 'Delete'