CREATE TABLE `player` (
 `id` int unsigned NOT NULL AUTO_INCREMENT,
 `code` varchar(10),
 `name` varchar(300),
 `date_register` datetime,
 `tel` varchar(100),
 `email` varchar(100),
 `status` int unsigned,
 PRIMARY KEY (`id`));

public class obPlayer
{
 int id = 0;
 string code = "";
 string name = "";
 DateTime date_register = DateTime.MinValue;
 string tel = "";
 string email = "";
 int status = 0;
 public int Id { get { return id; } set { id = value; }
 public string Code { get { return code; } set { code = value; }
 public string Name { get { return name; } set { name = value; }
 public DateTime DateRegister { get { return date_register; } set { date_register = value; }
 public string Tel { get { return tel; } set { tel = value; }
 public string Email { get { return email; } set { email = value; }
 public int Status { get { return status; } set { status = value; }
}

int id = 1;
// declare the object
obPlayer p = null;
using (MySqlConnection conn = new MySqlConnection(config.ConnString))
{
 using (MySqlCommand cmd = new MySqlCommand())
 {
 cmd.Connection = conn;
 conn.Open();
 MySqlExpress m = new MySqlExpress(cmd);
 // parameterize the values
 Dictionary<string, object> dicParam = new Dictionary<string, object>();
 dicParam["@vid"] = id;
 p = m.GetObject<obPlayer>($"select * from player where id=@vid;", dicParam);
 conn.Close();
 }
}

// declare the object list
List<obPlayer> lst = null;
using (MySqlConnection conn = new MySqlConnection(config.ConnString))
{
 using (MySqlCommand cmd = new MySqlCommand())
 {
 cmd.Connection = conn;
 conn.Open();
 MySqlExpress m = new MySqlExpress(cmd);
 // parameterize the values
 Dictionary<string, object> dicParam = new Dictionary<string, object>();
 dicParam["@vname"] = "%adam%";
 lst = m.GetObjectList<obPlayer>($"select * from player where name like @vname;", dicParam);
 conn.Close();
 }
}