public OracleSnapshotQueryBuilder(OracleSnapshotSettings settings) { var schemaName = settings.SchemaName; var tableName = settings.TableName; _deleteSql = string.Format(@"DELETE FROM {0}.{1} WHERE PersistenceId = :PersistenceId ", schemaName, tableName); _insertSql = string.Format(@"INSERT INTO {0}.{1} (PersistenceId, SequenceNr, Timestamp, Manifest, Snapshot) VALUES (:PersistenceId, :SequenceNr, :Timestamp, :Manifest, :Snapshot)", schemaName, tableName); _selectSql = string.Format(@"SELECT PersistenceId, SequenceNr, Timestamp, Manifest, Snapshot FROM {0}.{1} WHERE PersistenceId = :PersistenceId",schemaName, tableName); }
public OracleSnapshotQueryBuilder(OracleSnapshotSettings settings) { var schemaName = settings.SchemaName; var tableName = settings.TableName; _deleteSql = string.Format(@"DELETE FROM {0}.{1} WHERE PersistenceId = :PersistenceId ", schemaName, tableName); _insertSql = string.Format(@"INSERT INTO {0}.{1} (PersistenceId, SequenceNr, Timestamp, Manifest, Snapshot) VALUES (:PersistenceId, :SequenceNr, :Timestamp, :Manifest, :Snapshot)", schemaName, tableName); _selectSql = string.Format(@"SELECT PersistenceId, SequenceNr, Timestamp, Manifest, Snapshot FROM {0}.{1} WHERE PersistenceId = :PersistenceId", schemaName, tableName); }