Database column sizes to use with ExtraInformation Informnation Providers

Topics: General discussion, Logging Application Block
May 25, 2010 at 11:47 PM

Hello all,

I am looking at the ExtraInformation part of the LAB. There are 4 InformationProviders defined. I am trying to map them to a test logging database and am not sure what to use as column sizes in the database for the strings. I am planning to use nvarchar for all of them. Below are the keys returned from the dictionary processing. Thanks in advance for any ideas and/or suggestions!

    ApplicationId - presumed integer
    ActivityId - presumed integer
    DirectCallerAccountName - string
    OriginalCallerAccountName - string
    TransactionId - presumed integer

    StackTrace - presumed nvarchar(max) but not sure how to code with db.AddInParameter

    IdentityName - string
    AuthenticationType - string
    IsAuthenticated - boolean

    CurrentUser - string
    ProcessAccountName - string

May 26, 2010 at 2:53 AM

I suggest trying to use those classes and populate a dictionary to get an idea how long the values probably be.


Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc. 

May 26, 2010 at 2:20 PM

Hello Sarah,

Unfortunately, I do not have access to Com+ and Unamanged code resources with which to test. Thanks for responding.