public object SqlToScalar(string sql)
{
using (DbConnection conexion = factory.CreateConnection ()) {
conexion.ConnectionString = ConnectionString;
conexion.Open ();
using (DbCommand comando = factory.CreateCommand ()) {
comando.Connection = conexion;
comando.CommandType = CommandType.Text;
comando.CommandText = sql;
comando.CommandTimeout = CommandTimeOut;
return comando.ExecuteScalar ();
}
}
}