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 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);
}
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);
}