Exemplo n.º 1
0
        public virtual Message Query(QueryXmlRequest query)
        {
            _log.DebugFormat("Query: {0}", query.query);
            if (_log.IsDebugEnabled && query.parameters.Count > 0)
            {
                _log.Debug("Parameters: ");
                foreach (var parameter in query.parameters)
                {
                    _log.DebugFormat("\t{0}={1}", parameter.Key, parameter.Value);
                }
            }
            var stopwatch = new Stopwatch();

            try
            {
                if (_infoService == null)
                {
                    Open();
                }
                stopwatch.Start();
                return(_infoService.Query(query));
            }
            catch (FaultException <InfoServiceFaultContract> ex)
            {
                _log.Error("Error executing query: " + ex.Detail.Message + Environment.NewLine + query.query);
                throw;
            }
            catch (Exception ex)
            {
                _log.ErrorFormat("Error executing query: {0} {1} {2}", ex, Environment.NewLine, query.query);
                foreach (var parameter in query.parameters)
                {
                    _log.ErrorFormat("\t{0}={1}", parameter.Key, parameter.Value);
                }
                throw;
            }
            finally
            {
                stopwatch.Stop();
                if (stopwatch.Elapsed > longRunningQueryTime)
                {
                    _log.WarnFormat("Support! -- LONG RUNNING QUERY: {0} ms: {1}", stopwatch.Elapsed.TotalMilliseconds, query.query);
                }
            }
        }
Exemplo n.º 2
0
        public XmlReader Execute(bool hierarchical)
        {
            string returnClause = hierarchical ? " RETURN XML AUTO" : " RETURN XML RAW";

            QueryXmlRequest request = new QueryXmlRequest(queryString + returnClause, parameters);

            Message response = context.Service.Query(request);

            log.Debug(response);

            if (response.IsFault)
            {
                CreateFaultException(response);
            }

            XmlDictionaryReader reader = response.GetReaderAtBodyContents();

            return(reader);
        }
Exemplo n.º 3
0
        public XmlReader Execute(bool hierarchical)
        {
            string returnClause = hierarchical ? " RETURN XML AUTO" : " RETURN XML RAW";

            QueryXmlRequest request = new QueryXmlRequest(this.queryString + returnClause, parameters);

            Message response = this.context.Service.Query(request);

            log.Debug(response);

            if (response.IsFault)
            {
                CreateFaultException(response);
            }

            XmlDictionaryReader reader = response.GetReaderAtBodyContents();

            return reader;
        }
        public XmlDictionaryReader GetXmlData(string statement, PropertyBag parameters)
        {
            QueryXmlRequest queryRequest = new QueryXmlRequest(statement, parameters);

            Message message = null;

            using (new SwisSettingsContext {DataProviderTimeout = TimeSpan.FromSeconds(commandTimeout), ApplicationTag = ApplicationTag})
            {
                message = this.connection.Service.Query(queryRequest);
            }

            if (message != null)
            {
                if (message.IsFault)
                    CreateFaultException(message);

                return message.GetReaderAtBodyContents();
            }
            return null;
        }
        public new InformationServiceDataReader ExecuteReader(CommandBehavior behavior)
        {
            //TODO: Check if the statement contains a RETURN clause
            string query = statement + " RETURN XML RAW";

            var bag = new PropertyBag();
            foreach (InformationServiceParameter parameter in parameters)
                bag.Add(parameter.ParameterName, parameter.Value);

            QueryXmlRequest queryRequest = new QueryXmlRequest(query, bag);

            Message message = null;

            using (new SwisSettingsContext { DataProviderTimeout = TimeSpan.FromSeconds(commandTimeout), ApplicationTag = ApplicationTag, AppendErrors = true})
            {
                message = this.connection.Service.Query(queryRequest);
            }

            if (message != null)
            {
                if (message.IsFault)
                    CreateFaultException(message);

                return new InformationServiceDataReader(this, message.GetReaderAtBodyContents());
            }
            return null;
        }
Exemplo n.º 6
0
 public virtual Message Query(QueryXmlRequest query)
 {
     _log.DebugFormat("Query: {0}", query.query);
     if (_log.IsDebugEnabled && query.parameters.Count > 0)
     {
         _log.Debug("Parameters: ");
         foreach (var parameter in query.parameters)
             _log.DebugFormat("\t{0}={1}", parameter.Key, parameter.Value);
     }
     var stopwatch = new Stopwatch();
     try
     {
         if (_infoService == null)
         {
             Open();
         }
         stopwatch.Start();
         return _infoService.Query(query);
     }
     catch (FaultException<InfoServiceFaultContract> ex)
     {
         _log.Error("Error executing query: " + ex.Detail.Message + Environment.NewLine + query.query);
         throw;
     }
     catch (Exception ex)
     {
         _log.ErrorFormat("Error executing query: {0} {1} {2}", ex, Environment.NewLine, query.query);
         foreach (var parameter in query.parameters)
             _log.ErrorFormat("\t{0}={1}", parameter.Key, parameter.Value);
         throw;
     }
     finally
     {
         stopwatch.Stop();
         if (stopwatch.Elapsed > longRunningQueryTime)
         {
             _log.WarnFormat("Support! -- LONG RUNNING QUERY: {0} ms: {1}", stopwatch.Elapsed.TotalMilliseconds, query.query);
         }
     }
 }