public MysqlResults Query(string query, params MySqlParameter[] mySqlParameters)
{
insertId = 0;
exception = null;
try
{
using (var command = new MySqlCommand(query, Connection))
{
if (mySqlParameters != null && mySqlParameters.Length > 0)
{
command.Parameters.AddRange(mySqlParameters);
}
using (var reader = command.ExecuteReader())
{
insertId = command.LastInsertedId;
return(MysqlResults.LoadFromDataReader(reader));
}
}
}
catch (Exception ex)
{
exception = ex;
return(null);
}
}
public static MysqlResults LoadFromDataReader(MySqlDataReader reader)
{
var mr = new MysqlResults();
for (int i = 0; i < reader.FieldCount; i++)
{
mr.NameIndex.Add(reader.GetName(i), i);
}
if (reader.HasRows)
{
int colCount = reader.FieldCount;
while (reader.Read())
{
var mro = new MysqlRow();
object[] data = new object[colCount];
reader.GetValues(data);
mr.mysqlRows.AddLast(new MysqlRow()
{
Data = data, parent = mr
});
}
mr.NumberRows = mr.mysqlRows.Count;
mr.currentRow = mr.mysqlRows.First;
}
return(mr);
}
public static MysqlRow FetchAssoc(MysqlResults results)
{
if (results == null)
{
return(null);
}
return(results.FetchAssoc());
}
public static long NumberRows(MysqlResults results)
{
if (results == null)
{
return(0);
}
return(results.NumberRows);
}
