MySQL ExecuteScalar .Net

Образец выборки MySQL с использованием SELECT COUNT и  SELECT SUM для подсчета количества записей при условии.

try

{

MySqlCommand ^aCommand = gcnew MySqlCommand(“SELECT SUM(rezOne) FROM (SELECT COUNT(StatusOrder) AS rezOne  FROM OrdersLimit WHERE  StatusOrder = 5 UNION ALL SELECT COUNT(StatusOrder) AS rezOne FROM OrdersStop WHERE  StatusOrder = 5 )AS tmp“, con);//

int rez = System::Convert::ToUInt32(aCommand->ExecuteScalar());

return rez;

}//End Try

catch (Exception ^ex)

{

Console::WriteLine(ex->Message);

    return -1;

}