System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: c1e40a9f5c83fa3fd1910c99e1cd3fe910b01910
Title: SQLite program crash when show OpenFileDialog
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: None Resolution: External_Bug
Last Modified: 2016-08-29 18:02:28
Version Found In: 1.0.102.0
User Comments:
anonymous added on 2016-08-28 12:29:26:
I recently in a .NET WPF project using SQLite and spatialite found a problem, when I use the SQLite load extension many times, again using the OpenFileDialog, the program will crash. The cause of the crash is an exception to the COM component, the code for the 0x8007045A. I simplify the problem into the following test code:

            var b = new System.Data.SQLite.SQLiteConnectionStringBuilder();
            b.DataSource = @"C:\Users\jdire\Downloads\db.sqlite";
            for (int i = 0; i < 1500; i++)
            {
                var cnn = new System.Data.SQLite.SQLiteConnection(b.ConnectionString);
                cnn.Open();

                cnn.EnableExtensions(true);
                cnn.LoadExtension("mod_spatialite");



                cnn.Close();
                cnn.Dispose();

                cnn = null;

            }
            b = null;

            var dlg = new OpenFileDialog();
            dlg.ShowDialog(); // Crash at here



I use the .net version SQLite 1.0.102.0 , the Spatialite version is 4.3.0a. If I use 4.0.0 Spatialite, it won't be the problem. If I don't load extension, it won't be the problem. Do not know what is missing from my code, or where there is BUG, I hope you can help me.

Thank you very much.

mistachkin added on 2016-08-29 18:02:28:
From the sound of things, it really sounds like an issue with Spatialite.  Their
home page is:

https://www.gaia-gis.it/fossil/libspatialite/