private void LogSqlStatement(SqlParts sqlParts) { if (_log != null && _log.IsDebugEnabled == true) { var logMessage = new StringBuilder(); logMessage.AppendFormat("{0};", sqlParts.ToString()); for (var i = 0; i < sqlParts.Parameters.Count(); i++) { var paramValue = sqlParts.Parameters.ElementAt(i).Value.ToString(); var paramMessage = string.Format(" p{0} = '{1}';", i, sqlParts.Parameters.ElementAt(i).Value.ToString()); if (paramValue.IsNumber()) { paramMessage = paramMessage.Replace("'", ""); } logMessage.Append(paramMessage); } if (_logManagerFactory != null) { var sqlLog = _logManagerFactory.GetLogger("LinqToExcel.SQL"); sqlLog.Debug(logMessage.ToString()); } } }
/// <param name="fileName">Full path to the Excel spreadsheet</param> /// <param name="logManagerFactory"> /// Factory that facilitates the creation of an external log manager (i.e. log4net) to /// allow internal methods of LinqToExcel to perform diagnostic logging. /// </param> public ExcelQueryFactory(string fileName, ILogManagerFactory logManagerFactory) { FileName = fileName; if (logManagerFactory != null) { _logManagerFactory = logManagerFactory; _log = _logManagerFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); } }
/// <param name="fileName">Full path to the Excel spreadsheet</param> /// <param name="logManagerFactory"> /// Factory that facilitates the creation of an external log manager (i.e. log4net) to /// allow internal methods of LinqToExcel to perform diagnostic logging. /// </param> public ExcelQueryFactory(string fileName, ILogManagerFactory logManagerFactory) { FileName = fileName; DatabaseEngine = ExcelUtilities.DefaultDatabaseEngine(); if (logManagerFactory != null) { _logManagerFactory = logManagerFactory; _log = _logManagerFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); } }
internal ExcelQueryExecutor(ExcelQueryArgs args, ILogManagerFactory logManagerFactory) { ValidateArgs(args); _args = args; if (logManagerFactory != null) { _logManagerFactory = logManagerFactory; _log = _logManagerFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); } if (_log != null && _log.IsDebugEnabled == true) { _log.DebugFormat("Connection String: {0}", ExcelUtilities.GetConnection(args).ConnectionString); } GetWorksheetName(); }