C# (CSharp) System.Data.SQLite SQLiteConnection.PrepareCommand Examples

Example #1

File: ClrDumpCache.cs Project: fremag/MemoScope.Net

        private void Open(string dbPath)
        {
            string cxionString = $"Data Source={dbPath};Version=3;Page Size=65536;journal_mode=OFF;synchronous=OFF;count_changes=OFF;temp_store=MEMORY";
            cxion = new SQLiteConnection(cxionString);
            cxion.Open();

            cmdCountReferences = cxion.PrepareCommand("SELECT count(*) FROM InstanceReferences WHERE InstanceAddress= @instanceAddress");
            paramInstanceAddress_CountReferences = cmdCountReferences.CreateParameter("@instanceAddress");
        }