public void Does_use_and_return_Sequence_on_Insert()
{
using (var db = OpenDbConnection())
{
db.DropAndCreateTable <UserSequence>();
var user = new UserSequence {
Name = "me", Email = "*****@*****.**"
};
user.UserName = user.Email;
db.Insert(user);
Assert.That(user.Id, Is.GreaterThan(0), "normal Insert");
}
}
public void Does_generate_Sql_with_Sequence()
{
using (var db = OpenDbConnection())
{
db.DropAndCreateTable <UserSequence>();
var user = new UserSequence {
Name = "me", Email = "*****@*****.**"
};
user.UserName = user.Email;
var id = db.Insert(user);
var sql = db.GetLastSql();
Assert.That(sql, Is.EqualTo("INSERT INTO \"UserSequence\" (\"Id\",\"Name\",\"UserName\",\"Email\") OUTPUT INSERTED.\"Id\" VALUES (NEXT VALUE FOR \"Gen_UserSequence_Id\",@Name,@UserName,@Email)"), "normal Insert");
}
}
