Example sql for logging exceptions to database using exception handling application block

Question

Can anyone provide (or point me to) example sql code for logging exceptions using Enterprise Library Exception Handling Application Block (EHAB)? ie I'd like standard CREATE TABLE and CREATE PROCEDURE statements for the structures and procs to store logged exceptions in a SQL Server database.

Also, can anyone describe how the app block calls the procedures [WriteLogStoredProcedureName] and [AddCategoryStoredProcedureName] (e.g. what parameters should these have and how are they set) or where the documentation for this is?

(NB: I'm using Enterprise Library 3.1 - May 2007 as I'm using .net 2.0)

Harshad · Accepted Answer · 2009-12-23 12:27:19Z

1

Default value of [WriteLogStoredProcedureName] is "WriteLog". Default value of [addCategoryStoredProcName] is "AddCategory".

Install Enterprise Library and you will get script "C:\EntLib3Src\App Blocks\Src\Logging\TraceListeners\Database\Scripts\LoggingDatabase.sql". After executing this script, you will get "Logging" database ready with all required Stored procedures and tables.

answered Dec 23, 2009 at 12:27

Harshad

261 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Adrian K Over a year ago

For EntLibs 4.1 the location I have is: C:\EntLib41Src\Blocks\Logging\Src\DatabaseTraceListener\Scripts

Collectives™ on Stack Overflow

Example sql for logging exceptions to database using exception handling application block

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related