public void CreateWithDefaultValues() { var seqName = ObjectName.Parse("APP.test_seq1"); var statement = new CreateSequenceStatement(seqName); statement.Execute(Query); var exists = Query.ObjectExists(DbObjectType.Sequence, seqName); Assert.IsTrue(exists); }
public void CreateWithStartValue() { var seqName = ObjectName.Parse("APP.test_seq1"); var statement = new CreateSequenceStatement(seqName) { StartWith = SqlExpression.Constant(2) }; statement.Execute(Query); var exists = Query.ObjectExists(DbObjectType.Sequence, seqName); Assert.IsTrue(exists); }