public void Insert_Blob(BlobsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "INSERT INTO Blobs (FK_FilePathID, BlobData) " +
"VALUES (@FK_FilePathID, @BlobData);";
cnn.Execute(query, model);
IncrementDatabaseRevision();
}
public void Update_Blob(BlobsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "UPDATE Blobs " +
"SET BlobData = @BlobData " +
"WHERE FK_FilePathID = @FK_FilePathID;";
cnn.Execute(query, model);
IncrementDatabaseRevision();
}
