public Execute ( IEnumerable |
||
commands | IEnumerable |
|
return | int |
public virtual int Execute(IEnumerable<DbCommand> commands)
{
var result = 0;
using (var conn = OpenConnection()) {
using (var tx = conn.BeginTransaction()) {
foreach (var cmd in commands) {
cmd.Connection = conn;
cmd.Transaction = tx;
result += cmd.ExecuteNonQuery();
}
tx.Commit();
}
}
return result;
}
public static void InitDatabase() { DynamicModel dm = new DynamicModel("NietoYostenDb", "Albums", "ID"); dm.Execute("DELETE FROM Pictures"); dm.Execute("DELETE FROM Albums"); dm.Execute("DELETE FROM ApprovalRequests"); dm.Execute("DELETE FROM Users"); var users = new Users(); dynamic testUser = users.Register("*****@*****.**", TestUtil.DefaultUserPassword, TestUtil.DefaultUserPassword); TestUtil.TestUserId = (int)users.Scalar("SELECT ID FROM Users WHERE Email=@0", args:"*****@*****.**"); }