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();
}