all groups > visual studio .net enterprise tools > september 2005 >
You're in the

visual studio .net enterprise tools

group:

enterprise libary database sink documentation and/or example



enterprise libary database sink documentation and/or example ptass
9/28/2005 7:59:01 PM
visual studio .net enterprise tools: Hi

Does anyone know where i can get good documentation and/or examples on
creating a database sink for the enterprise library logging application block.

I know its possible, but i can't find any information on how to set one up.

Some questions i need answering...

What the format of the databaseInstance property should be for the new
database sink when setting through Enterprise Library Configuration manager.
How to call the stored proc from code.
Sample stored procedure.
Sample table.

Thanks for any help
RE: enterprise libary database sink documentation and/or example v-garych NO[at]SPAM online.microsoft.com (
9/29/2005 8:03:51 AM
Hi,

[quoted text, click to view]

I suggest you refer to the documentation and sample source code of the
latest Release--Enterprise Library(June 2005), you can find the related
database sink sample code in the following path:
...\Microsoft Enterprise Library June 2005\src\Logging\Sinks\Database

patterns & practices Enterprise Library - June 2005
http://www.microsoft.com/downloads/details.aspx?FamilyId=A7D2A109-660E-444E-
945A-6B32AF1581B3&displaylang=en

The codeproject website also has a good article about Logging applcation
block, which provided the description of how to complete the general
logging tasks, it may be useful:

Get Logging with the Enterprise Library
http://www.codeproject.com/dotnet/GetLoggingWithEntLib.asp


[quoted text, click to view]

Do you mean when you add a new Database sink in the Enterprise Library
Configuration console, how to specify the entry in the new sink's
"DatabaseInstance" property? If so, the entry which you can select from its
dropdown listbox is corresponding to the database instance that you
configured in the "Data Access Application Block"\"Database Instances".


[quoted text, click to view]
Please refer to the ExecuteStoredProcedure function of the DatabaseSink.cs
source file of the sample project I figured above.


Thanks!

Best regards,

Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button