public QueryBuilder(SqliteSnapshotSettings settings) { _deleteSql = string.Format(@"DELETE FROM {0} WHERE persistence_id = ? ", settings.TableName); _insertSql = string.Format(@"INSERT INTO {0} (persistence_id, sequence_nr, created_at, manifest, snapshot) VALUES (@PersistenceId, @SequenceNr, @Timestamp, @Manifest, @Snapshot)", settings.TableName); _selectSql = string.Format(@"SELECT persistence_id, sequence_nr, created_at, manifest, snapshot FROM {0} WHERE persistence_id = ? ", settings.TableName); }
public QueryBuilder(SqliteSnapshotSettings settings) { _deleteSql = string.Format(@"DELETE FROM {0} WHERE persistence_id = ? ", settings.TableName); _insertSql = string.Format(@"INSERT INTO {0} (persistence_id, sequence_nr, created_at, manifest, snapshot) VALUES (@PersistenceId, @SequenceNr, @Timestamp, @Manifest, @Snapshot)", settings.TableName); _selectSql = string.Format(@"SELECT persistence_id, sequence_nr, created_at, manifest, snapshot FROM {0} WHERE persistence_id = ? ", settings.TableName); }