需要帮助将System.Data.OracleClient.OracleCommand序列化为XML吗？

Question

尝试将oracle命令列表写入XML，但一直收到此错误。我都快疯了。提前谢谢。

“反映类型‘System.Data.OracleClient.OracleCommand’时出错。”

Friend Sub WriteDataToFile(ByVal Commands As List(Of System.Data.OracleClient.OracleCommand))
    Try

        Dim PathName As String = OffloaderDataPath() & "Commands " & Now.ToLocalTime.Ticks.ToString & ".XML"


        Dim writer As New System.Xml.Serialization.XmlSerializer(GetType(System.Data.OracleClient.OracleCommand))
        Dim file As New System.IO.StreamWriter(PathName)
        writer.Serialize(file, Commands)
        file.Close()

        If BackgroundWorkerDatabase.DataBaseInsertsIsCancelled = True Then
            BackgroundWorkerDatabase.Run()
        End If

    Catch ex As Exception
        WriteToLog("CollectorFacility.WriteDAtaToFile: " & ex.Message)
    End Try


End Sub

Answer 1

也许您需要一个纪念品，或者可以从OracleCommand中提取状态的东西，比如CommandText、CommandType、Timeout等等。

序列化Parameters属性可能没有意义。