Massive.DynamicModel.Execute C# (CSharp) Method

Execute() public method

Executes a series of DBCommands in a transaction
public Execute ( IEnumerable commands ) : int
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;
        }

Same methods

DynamicModel::Execute ( DbCommand command ) : int
DynamicModel::Execute ( string sql ) : int

Usage Example

Example #1
0
        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:"*****@*****.**");
        }