c# - LogParser 在 C# 中崩溃且没有错误

Question

我正在尝试在 C# 应用程序中实现 MS LogParser。这编译得很好，但在 logQuery.ExecuteBatch() 方法上莫名其妙地崩溃了。 try/catch block 不会捕获它，除非我专门对 szQuery 进行了错误处理，这表明一切都正常工作，我只是没有得到任何输出。

关于为什么它可能崩溃或者我可以在哪里找到一些日志记录有什么想法吗？

using System;using System.Collections.Generic;using System.Linq;using System.Text;using FolderLoggingLib;using MSUtil;
namespace ConsoleApplication20{    class Program     {        static void Main(string[] args)        {            //refLog = new BinaryInputFormat();            LogQueryClass logQuery = new LogQueryClass();            ICOMCSVOutputContext output = new COMCSVOutputContextClass();            ILogParserInputContext parse = new BinaryInputFormat();
        string szFileName = @"E:\Programming\FolderLogging\2012-05-13.fbl";
        string szQuery = "SELECT Folder, User, Record, DB, TO_LOCALTIME(Timestamp) AS DateTime, Operation, Checked FROM " + szFileName + " ORDER BY DateTime DESC";
        try
        {
            logQuery.ExecuteBatch(szQuery, parse, output);
        }
        catch
        {
        };           
    }
}

}

Answer 1

使用 Execute 而不是 ExecuteBatch:

MSUtil.ILogRecordset RecordSet = logQuery.Execute(query, oInputFormat)

如果您想在示例代码中导出为 CSV，您需要通过添加 INTO output_file_name 来更改查询并运行 ExecuteBatch:

string szQuery = "SELECT Folder, User, Record, DB, TO_LOCALTIME(Timestamp) AS DateTime, Operation,  Checked **INTO c:\out\out.csv** FROM " + szFileName + " ORDER BY DateTime DESC";