嗨,这是一个关于C语言如何处理COM互操作资源管理的示例。orginal source

Excel.Application app = null;
Excel.Workbooks books = null;
Excel.Workbook book = null;
Excel.Sheets sheets = null;
Excel.Worksheet sheet = null;
Excel.Range range = null;

try
{
    app = new Excel.Application();
    books = app.Workbooks;
    book = books.Add();
    sheets = book.Sheets;
    sheet = sheets.Add();
    range = sheet.Range["A1"];
    range.Value = "Lorem Ipsum";
    book.SaveAs(@"C:\Temp\ExcelBook" + DateTime.Now.Millisecond + ".xlsx");
    book.Close();
    app.Quit();
}
finally
{
    if (range != null) Marshal.ReleaseComObject(range);
    if (sheet != null) Marshal.ReleaseComObject(sheet);
    if (sheets != null) Marshal.ReleaseComObject(sheets);
    if (book != null) Marshal.ReleaseComObject(book);
    if (books != null) Marshal.ReleaseComObject(books);
    if (app != null) Marshal.ReleaseComObject(app);
}

就我个人而言,我认为上述规定是合理和必要的。但它不是功能性的,也不是F型的。我最终在嵌套的try的不同级别定义了所有这些com变量…最后,尝试和…因为变量必须在尝试阻止之前定义,在最后和块中都存在清理代码。很乱。
我怎样才能在f中正确地实现同样的功能呢?有点讽刺的是,互联网上有很多例子解释了如何将f与interop结合使用,以此来展示f的威力。但是,它们都无法转换如何管理COM资源清理。
任何关于好的模式的建议都会得到评价。

最佳答案

您可以创建一个计算表达式,调用try/catch中的每个步骤,并在finally中释放。我们可以为create/finalize创建一个带有插件函数的生成器,这样我们就可以看到发生了什么。

type FinalizationBuilder(oncreate, onfinal) =
  member __.Bind(m, f) =
    oncreate(box m)
    try
      try
        f m
      with ex ->
        Choice2Of2 ex.Message
    finally
      onfinal(box m)
  member __.Return(m) = Choice1Of2 m
  member __.Zero() = Choice1Of2()

然后,您需要一个COM工作流,它只在COM组件完成时释放它。
let com = new FinalizationBuilder(ignore, System.Runtime.InteropServices.Marshal.ReleaseComObject >> ignore)

你这样使用它:
[<EntryPoint>]
let main _ =
  com {
    let! app = new Excel.Application()
    let! books = app.Workbooks
    let! book = books.Add()
    // ...
    app.Quit()
  } |> ignore
  0

我没有安装excel,但我可以模拟它的异常和printfn。
let demo = new FinalizationBuilder(printfn "Created %A", printfn "Released %A")

[<EntryPoint>]
let main _ =
  demo {
    let! x = 1
    let! y = 2
    let! z = 3
    return x + y + z
  } |> printfn "Result: %A"
  0

// Created 1
// Created 2
// Created 3
// Released 3
// Released 2
// Released 1
// Result: Choice1Of2 6

或例外情况:
[<EntryPoint>]
let main _ =
  demo {
    let! x = 1
    let! y = 2
    let! z = failwith "boom"
    return x + y + z
  } |> printfn "Result: %A"
  0

// Created 1
// Created 2
// Released 2
// Released 1
// Result: Choice2Of2 "boom"

尽管如此,看起来这些都不是必要的。一个简单的GC.Collect(); GC.WaitForPendingFinalizers()可以解决这个问题,而不需要这些:https://stackoverflow.com/a/25135685/171121

10-06 16:14
查看更多