public void Delete_Blob(FilePathsDBModel model) { using IDbConnection cnn = new SQLiteConnection(_connectionString); string query = "DELETE FROM Blobs " + "WHERE FK_FilePathID = @FilePathID;"; cnn.Execute(query, model); IncrementDatabaseRevision(); }
public void Insert_FilePath(FilePathsDBModel model) { using IDbConnection cnn = new SQLiteConnection(_connectionString); string query = "INSERT INTO FilePaths (FilePath, LastWriteTimeUtc, HashAlgorithm, FileHash) " + "VALUES (@FilePath, @LastWriteTimeUtc, @HashAlgorithm, @FileHash);"; cnn.Execute(query, model); IncrementDatabaseRevision(); }
public void Update_LastWriteTimeUtc(FilePathsDBModel model) { using IDbConnection cnn = new SQLiteConnection(_connectionString); string query = "UPDATE FilePaths " + "SET LastWriteTimeUtc = @LastWriteTimeUtc " + "WHERE FilePathID = @FilePathID;"; cnn.Execute(query, model); IncrementDatabaseRevision(); }
public byte[] Select_Blob(FilePathsDBModel model) { using IDbConnection cnn = new SQLiteConnection(_connectionString); string query = "SELECT BlobData " + "FROM Blobs " + "WHERE FK_FilePathID = @FilePathID;"; var output = cnn.QuerySingle <byte[]>(query, model); return(output); }
public int Select_FilePathID(FilePathsDBModel model) { using IDbConnection cnn = new SQLiteConnection(_connectionString); string query = "SELECT FilePathID " + "FROM FilePaths " + "WHERE FilePath = @FilePath;"; int output = cnn.ExecuteScalar <int>(query, model); return(output); }