public void InsertToDBMySql()
{
var user = new User()
{
UserName = "******",
Password = "******"
};
sql.AlterDataQuery("insert into useraccount(username,password) values(@UserName, @Password)", user);
var emptyUser = new
{
UserName = "******"
};
var data = sql.SelectQuery("select * from testdb.useraccount where username = @UserName", emptyUser);
var selectedUser = data.Rows[0][0];
Assert.AreEqual("Nasar", selectedUser);
}