System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Overview

Artifact ID: fc6494b74f798dcf78e13f0a5b3d914a25972735
Ticket: 9540461a6c0da6fb0d86df4685b66c2f1ce1c187
Creating a changeset is not working
User & Date: anonymous 2018-08-07 13:31:03
Changes

  1. foundin changed to: "1.0.108"
  2. icomment:
    I'm currently writing on my bachelor thesis and wanted to use the session extension in .NET to track changes made on the database. I wrote this code to generate a changeset (the documentation on this for .NET is quite poor):
    
    var connection = new SQLiteConnection("Data Source=test.sqlite");
    connection.Open();
    var session = connection.CreateSession("main");
    session.AttachTable("Test");
    connection.ExecuteSqlCommand("INSERT INTO Test (Id, Description) VALUES (?, ?)", 0, "testbeschreibung"); //my extension method which creates a SQLiteCommand with Parameters and executes it
    byte[] rawChanges = new byte[0];
    session.CreateChangeSet(ref rawChanges);
    
    The database consists only of the table "Test" with columns "Id" (int, Primary Key) and "Description" (text). The data insertion is working fine, but rawChanges does not contain anything. I also tried .CreateChangeSet() with a stream instead of a byte array, but it did not change anything. Am I missing an important step or is it just not working?
    
    Thanks in advance,
    Patrick Seiter
    
  3. login: "anonymous"
  4. mimetype: "text/x-fossil-plain"
  5. private_contact changed to: "3743753d6b27d6ae21152589c8f6ca74f28b4b62"
  6. severity changed to: "Important"
  7. status changed to: "Open"
  8. title changed to: "Creating a changeset is not working"
  9. type changed to: "Incident"