Register WCF in the database

Question

I want to write each xml request message to my WCF service project in a database. Please suggest me the best and preferred approach.

1) Using the idispatchmessageinspector interface

http://msdn.microsoft.com/en-us/library/system.servicemodel.dispatcher.idispatchmessageinspector(v=VS.90).aspx

OR

2) write a custom SQL database trace listener?

Answer 1

You will need to write a custom WCF trace listener.

: http://www.enusbaum.com/blog/2007/05/19/creating-a-custom-listener-for-your-wcf-application-in-c/ http://weblogs.thinktecture.com/cweyer/2009/06/custom-tracelistener-writing-trace-messages-to-the-net-services-service-bus.html

Answer 2

, , , , , WCF , .

SQL - SQL- ( SQL- SQL), WCF.

Answer 3

I think using the interface idispatchmessageinspectorand using ThreadPool.QueueUserWorkItem()to read the query and enter the database in the event AfterReceiveRequestwill be better compared to using tracing. I believe that tracing may have some overhead because it is intended for some diagonal purposes and does not want to include tracing in prod forever.

Are there any problems with using idispatchmessageinspectorand ThreadPool.QueueUserWorkItem()for registering the request message in the database?

Thank!

Bala