public void ReturnTrueIfUpdateStatementIsCorrect()
        {
            UserModel UserModel = new UserModel()
            {
                ID           = 1,
                UID          = "Testert1",
                FirstName    = "Test",
                LastName     = "Tester",
                EmailAddress = "*****@*****.**"
            };

            string UserUpdateStatement = MySQLDBStateless.GenerateStandardUpdateStatement(UserModel, nameof(UserModel.ID), UserModel.ID);

            Assert.AreEqual($"UPDATE {UserModel.TableName()} SET usrUID = 'Testert1', usrFirstName = 'Test', usrLastName = 'Tester', usrEmailAddress = '*****@*****.**' WHERE usrID = 1",
                            UserUpdateStatement);
        }
Example #2
0
 private void Update()
 {
     _MySQLDBStateless.ExecNonQuery(MySQLDBStateless.GenerateStandardUpdateStatement(this, nameof(this.ID), this.ID));
 }