public DbCommand InsertSnapshot(SnapshotEntry entry) { var sqlCommand = new SqlCommand(_insertSql) { Parameters = { new SqlParameter("@PersistenceId", SqlDbType.NVarChar, entry.PersistenceId.Length) { Value = entry.PersistenceId }, new SqlParameter("@SequenceNr", SqlDbType.BigInt) { Value = entry.SequenceNr }, new SqlParameter("@Timestamp", SqlDbType.DateTime2) { Value = entry.Timestamp }, new SqlParameter("@SnapshotType", SqlDbType.NVarChar, entry.SnapshotType.Length) { Value = entry.SnapshotType }, new SqlParameter("@Snapshot", SqlDbType.VarBinary, entry.Snapshot.Length) { Value = entry.Snapshot } } }; return sqlCommand; }
public DbCommand InsertSnapshot(SnapshotEntry entry) { var sqlCommand = new SQLiteCommand(_insertSql) { Parameters = { new SQLiteParameter("@PersistenceId", DbType.String, entry.PersistenceId.Length) { Value = entry.PersistenceId }, new SQLiteParameter("@SequenceNr", DbType.Int64) { Value = entry.SequenceNr }, new SQLiteParameter("@Timestamp", DbType.Int64) { Value = entry.Timestamp.Ticks }, new SQLiteParameter("@Manifest", DbType.String, entry.SnapshotType.Length) { Value = entry.SnapshotType }, new SQLiteParameter("@Snapshot", DbType.Binary, entry.Snapshot.Length) { Value = entry.Snapshot } } }; return sqlCommand; }
public DbCommand InsertSnapshot(SnapshotEntry entry) { var oracleCommand = new OracleCommand(_insertSql) { Parameters = { new OracleParameter(":PersistenceId", OracleDbType.NVarchar2, entry.PersistenceId.Length) { Value = entry.PersistenceId }, new OracleParameter(":SequenceNr", OracleDbType.Decimal) { Value = entry.SequenceNr }, new OracleParameter(":Timestamp", OracleDbType.TimeStampTZ) { Value = entry.Timestamp }, new OracleParameter(":Manifest", OracleDbType.NVarchar2, entry.SnapshotType.Length) { Value = entry.SnapshotType }, new OracleParameter(":Snapshot", OracleDbType.LongRaw, entry.Snapshot.Length) { Value = entry.Snapshot } } }; return oracleCommand; }
public DbCommand InsertSnapshot(SnapshotEntry entry) { var sqlCommand = new NpgsqlCommand(_insertSql) { Parameters = { new NpgsqlParameter(":persistence_id", NpgsqlDbType.Varchar, entry.PersistenceId.Length) { Value = entry.PersistenceId }, new NpgsqlParameter(":sequence_nr", NpgsqlDbType.Bigint) { Value = entry.SequenceNr }, new NpgsqlParameter(":created_at", NpgsqlDbType.Timestamp) { Value = GetMaxPrecisionTicks(entry.Timestamp) }, new NpgsqlParameter(":created_at_ticks", NpgsqlDbType.Smallint) { Value = GetExtraTicks(entry.Timestamp) }, new NpgsqlParameter(":manifest", NpgsqlDbType.Varchar, entry.SnapshotType.Length) { Value = entry.SnapshotType }, new NpgsqlParameter(":snapshot", NpgsqlDbType.Bytea, entry.Snapshot.Length) { Value = entry.Snapshot } } }; return sqlCommand; }