public static void MakeQuery(string query)
{
var dbCon = DBConnection.Instance();
MySqlConfig config = FileIO.ReadConfigJson(new MySqlConfig());
dbCon.databaseName = config.databaseName;
dbCon.login = config.login;
dbCon.password = config.password;
List <string> result = new List <string>();
if (dbCon.IsConnect())
{
try
{
//suppose col0 and col1 are defined as VARCHAR in the DB
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
if (e.Message.Contains("already exists"))
{
}
else
{
Log.Exception(e);
}
}
}
dbCon.Close();
}
public static List <string> MakeQuery(string query, string column)
{
var dbCon = DBConnection.Instance();
MySqlConfig config = FileIO.ReadConfigJson(new MySqlConfig());
dbCon.databaseName = config.databaseName;
dbCon.login = config.login;
dbCon.password = config.password;
List <string> result = new List <string>();
if (dbCon.IsConnect())
{
try
{
//suppose col0 and col1 are defined as VARCHAR in the DB
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
result.Add(reader.GetString(column));
}
}
catch (Exception e)
{
Log.Exception(e);
}
}
dbCon.Close();
return(result);
}