internal RequestDebugInfo Transform(IEnumerable<LogStatistic> messages)
 {
     var selects = 0;
     var updates = 0;
     var deletes = 0;
     var inserts = 0;
     var batchCommands = 0;
     if (messages == null) return null;
     var info = new RequestDebugInfo
         {
             GlimpseKey = Guid.NewGuid()
         };
     foreach (var loggingEvent in messages)
     {
         if (!string.IsNullOrEmpty(loggingEvent.Sql)  && loggingEvent.Sql.Trim() != string.Empty)
         {
             var detail = loggingEvent.Sql.TrimStart(' ', '\n', '\r');
             if (detail.StartsWith("select", StringComparison.OrdinalIgnoreCase)) selects++;
             if (detail.StartsWith("update", StringComparison.OrdinalIgnoreCase)) updates++;
             if (detail.StartsWith("delete", StringComparison.OrdinalIgnoreCase)) deletes++;
             if (detail.StartsWith("insert", StringComparison.OrdinalIgnoreCase)) inserts++;
             if (detail.StartsWith("batch commands:", StringComparison.OrdinalIgnoreCase)) batchCommands++;
         }
     }
     info.Selects = selects;
     info.Inserts = inserts;
     info.Updates = updates;
     info.Deletes = deletes;
     info.Batch = batchCommands;
     return info;
 }
        internal RequestDebugInfo Transform(IEnumerable <LogStatistic> messages)
        {
            var selects       = 0;
            var updates       = 0;
            var deletes       = 0;
            var inserts       = 0;
            var batchCommands = 0;

            if (messages == null)
            {
                return(null);
            }
            var info = new RequestDebugInfo
            {
                GlimpseKey = Guid.NewGuid()
            };

            foreach (var loggingEvent in messages)
            {
                if (!string.IsNullOrEmpty(loggingEvent.Sql) && loggingEvent.Sql.Trim() != string.Empty)
                {
                    var detail = loggingEvent.Sql.TrimStart(' ', '\n', '\r');
                    if (detail.StartsWith("select", StringComparison.OrdinalIgnoreCase))
                    {
                        selects++;
                    }
                    if (detail.StartsWith("update", StringComparison.OrdinalIgnoreCase))
                    {
                        updates++;
                    }
                    if (detail.StartsWith("delete", StringComparison.OrdinalIgnoreCase))
                    {
                        deletes++;
                    }
                    if (detail.StartsWith("insert", StringComparison.OrdinalIgnoreCase))
                    {
                        inserts++;
                    }
                    if (detail.StartsWith("batch commands:", StringComparison.OrdinalIgnoreCase))
                    {
                        batchCommands++;
                    }
                }
            }
            info.Selects = selects;
            info.Inserts = inserts;
            info.Updates = updates;
            info.Deletes = deletes;
            info.Batch   = batchCommands;
            return(info);
        }