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