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