public void ScalarMySql() { var user = new User() { UserName = "******", Password = "******" }; var query = "insert into useraccount(username,password) values(@UserName, @Password);" + " select username from testdb.useraccount where username = @Username"; var username = (string)sql.AlterDataQueryScalar(query, user); Assert.AreEqual("NasarScalar", username); }