How can the SqlDatabaseSink store the payload in separate columns?

Topics: Logging Application Block
Nov 13, 2014 at 8:06 AM
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 stated:
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.
Nov 13, 2014 at 1:29 PM
Yes, that does seem like a bug in the documentation. Thanks for pointing it out. The Azure Sink has a dynamic schema so the payload values are available in separate columns.

~~
Randy Levy
entlib.support@live.com
Enterprise Library support engineer
Support How-to