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