2

How can the SqlDatabaseSink store the payload in separate columns? It's mentioned in the documentation, but I haven't seen it done anywhere. When I've tried, the payload is always stored as a JSON string. Any ideas?

Source: Developing event sources using the .NET EventSource class

Under "Specifying the event and its payload" it states:

Some sinks will store payload items individually; for example, the SQL Database sink and the Azure Table Storage sink in the Semantic Logging Application Block store each payload item in a separate column.

Is the documentation wrong regarding the SqlDatabaseSink? I've heard DEVs claim that the Azure Sink works.

clarionprogrammer
  • 53
  • 6

2 Answers2

2

It turns out that the documentation is incorrect after all. It only works with the Azure Sink as explained here by an Enterprise Library Support Engineer.

clarionprogrammer
  • 53
  • 6
0

You can alter the source so the payload is stored in an XML column in Sql Server, that makes for easy querying. See this fork: https://github.com/DeHeerSoftware/semantic-logging

Peter Bons
  • 26,826
  • 4
  • 50
  • 74