Microsoft Application Blocks

Db.ExecuateReader and TransactionScope Class

Jessmmy — Tue, 17 Nov 2009 03:26:43 GMT

Hi guys

I'm using Data Access Application Block 3.1.The code looks like below.

When it runs to Db.ExecuteReader(dbc2), it throws an exception "There is already an open DataReaderassociatd with this command which must be closed first"

Examples I saw so far is that ExecuateNonQuery method is used within tranasactionsocpe. Can I just ExecuteReader here? My workround is to use connection.BeginTransaction to wrap up all the commad. To do this, I have to pass transaction object everywhere.

   using (TransactionScope scope = new
                        TransactionScope(TransactionScopeOption.RequiresNew))
{
......
Db.ExecuteReader(dbc1);
Db.ExecuteReader(dbc2)
......
}

Validation on Nullable types

Sgro — Mon, 16 Nov 2009 10:19:43 GMT

Good day.

Having the following:

[NotNullValidator(MessageTemplate = "ExpectedOnMissing")]
        [DateTimeRangeValidator("2009-01-01T00:00:00", RangeBoundaryType.Inclusive, "", RangeBoundaryType.Ignore, MessageTemplate = "ExpectedOnFormat")]
        public DateTime? ExpectedOn { get; set; }

I am having the following behavior:

if I input a valid datetime, validation passes;

if I input a valid datetime outside the boundaries, validation returns the format error

if I input an invalid datetime, or leave the field NULL, a NullReferenceException is thrown.

In the latter test, if I remove the DateTimeRangeValidator, the NotNullValidator error is reported correctly.

It seems like the DateTimeRange validator is executed even if the value is null, thus throwing an exception.

I also tried putting on the ValidatorComposition attribute, both with "And" and "Or" logic, but I always get the exception.

How I am supposed to put the validators to get the intended behavior: missing error on null, format error on out of range datetime?

Thanks.

Writing to SQL database with Microsoft.Practices.EnterpriseLibrary.ExceptionHandling

firsttarf — Tue, 10 Nov 2009 15:31:53 GMT

Until now I have been using Microsoft.Practices.EnterpriseLibrary.ExceptionHandling version 4.1 to write to the Windows event log. Now I'd like to have each error write to a database. What do I do to write the exceptions to MS SQL?

I am looking at Microsoft.Practices.EnterpriseLibrary.Logging.Database, but I am not sure what to do with it. I have looked at the individual hands on labs but do not see how to have exception handling go anywhere o

Thanks,

Unity and DAAB

macfei — Mon, 09 Nov 2009 19:07:02 GMT

I followed David Hayden's tutorial on the Unity w/ DAAB. It appears to me that it doesn't work well w/ 4.1 version.

IUnityContainer container = new UnityContainer();

container.AddNewExtension<EnterpriseLibraryCoreExtension>();

container.AddNewExtension<DataAccessBlockExtension>();var database =

container.Resolve<DatabaseProxy>("connetion1");

For some reason, it only picks the default database instead of connection1. David is using 4.0 version of the block, and I'm not sure is it because of the different version.

Please help.

Thanks

Using Enterprise Library for first time

munish_ps — Sun, 08 Nov 2009 12:11:58 GMT

Hi,

I wan to use the enterprise library for the first time. Is there any samples, quick start guide or ebook is available for a quick start and learn the basics.

I have vs2008, so which version of EL should I use?

And if somebody can just brief about Enterprise Library. Because as per my understanding, is this a mixture of design patterns and some pre-made blocks of source code.

Thanks.

Using Enterprise Library in multiple apps

JohanNL — Fri, 06 Nov 2009 13:28:50 GMT

We have a lot op apps.

Is there a way to centralise all enterprise library config information?

Is it possible to store Enterprise library settings in the machine.config?

Separating config files without loosing Enterprise Library Configuration Editor options

JohanNL — Fri, 06 Nov 2009 13:10:57 GMT

You can split config files, so they stay small and easy to understand.

This option does have a major drawback, however. The Enterprise Library Configuration Editor will read the information appropriately, but will not save configuration changes to each file. Instead, it will save the configuration settings to the main App.config or Web.config and wipe out the pointers to the separate configuration files.

Is there a way to work around this? We want to spli the config files, but also want to keep the Enterprise Library Configuration Editor.

Enterprise Library 4.1 - Logging and connectionstring

JohanNL — Thu, 05 Mar 2009 12:52:33 GMT

How do I configure the connectionstring for a SQL Log database for the Logging Application block of Ent Lib 4.1?

Interesting problem with getting OUTPUT parameters from SQL Server using C#

gilberk — Mon, 21 Jan 2008 11:46:03 GMT

I have the following SP:

Create procedure dbo.example

(

@test INT OUTPUT

)

BEGIN

SET @test = 5

SELECT * from Users

END

and when I try calling it from C# using an SqlCommand with adding an output parameter and getting it's value, I get that the value is NULL. (I should mention that I use ExecuteReader)

However, if I alter the SP and remove the select line, the c# code works and returns the value 5.

Unable to add reference of Microsoft.ApplicationBlocks.Data.Dll to my webapplication

guyind — Fri, 30 Oct 2009 17:13:46 GMT

Sorry I am new to Microsoft ApplicationBlocks and Enterprise Librabry in .Net.I am using Vs2008 and I need to add the Microsoft. ApplicationBlocks.data

dll to my webproject. I have installed the DataAccessApplicationBlock.msi and Enterprise Librabry 4.1-October 2008. But I am still unable to add the reference. Can anyone explain please?Also what is the difference between the two and in which situations we use?Pls explain with example.

thanks

guyind

urgent: Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0

nisarkhan — Tue, 15 Jul 2008 15:18:28 GMT

i spent lot of my time trying to figure out what cause this error and still cluless

i have web project and dal project and i have reference in both dal and web project the following dlls and the dll is physicall in the bin folder.

Microsoft.Practices.EnterpriseLibrary.Caching.dll
Microsoft.Practices.EnterpriseLibrary.Caching.xml
Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Data.dll
Microsoft.Practices.EnterpriseLibrary.Data.xml
Microsoft.Practices.ObjectBuilder.dll
Microsoft.Practices.ObjectBuilder.xml

Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.

Error Information

Name	Value
Build	Version 3.00.00 Build 1
Server
UserID
Source	daab
Exception Type	System.IO.FileLoadException
Message	Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.
StackTrace	at daab.LoginUserInfo_DA.GetLoginUserInfo(String userId) at Model.LoginUserInfo.GetLoginUserInfo(String UserId) at Global.Session_Start(Object sender, EventArgs e) at System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) at System.Web.SessionState.SessionStateModule.CompleteAcquireState() at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) at System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
TargetSite	System.Data.IDataReader GetLoginUserInfo(System.String)

helper for EntLibrary Data Block (ver 4.1)

alhambraeidos — Tue, 20 Oct 2009 09:29:20 GMT

Hi all,

any helper class for reduce code lines using ent Library:

            Database db = DatabaseFactory.CreateDatabase("ConnectionStrings.Oracle.D04PES01");
            using (DbCommand cm = db.GetStoredProcCommand("TBL_POC_TEST_TIPOS.TBL_POC_TEST_TIPOS_FBY_PK"))
            {
                db.AddInParameter(cm, "P_ID_TEST_TIPOS", DbType.String, id);
                cm.Parameters.Add(CreateCursorParameter("P_REFCURSOR"));

                // Using "using" will cause both the DataReader and connection to be 
                // closed. (ExecuteReader will close the connection when the 
                // DataReader is closed.)
                using (IDataReader dataReader = db.ExecuteReader(cm))
                {
                    if (dataReader.Read())
                    {
                        factory.Add(dataReader);
                    }
                    //while (dataReader.Read())
                    //{
                    //    factory.Add(dataReader);
                    //    break;
                    //}
                    return factory.Entity;
                }
            }

thanks in advance...

Constructor on type 'USStateValidator" not found.

Sunoneko — Fri, 16 Oct 2009 17:13:39 GMT

I downloaded the Validation Application Block and I am attempting to use the already written USStateValidator that is provided with the ValidationAspNetQuickStart.

I added the following to the ValidationQuickStart.BusinessEntities.dll.config file under "Address", "RuleSetB".

<property name="State">
            <validator messageTemplate="Site State: Must be a valid two-digit US state designation." messageTemplateResourceName=""
              messageTemplateResourceType="" tag="" type="ValidationQuickStart.CustomValidators.USStateValidator, ValidationQuickStart.CustomValidators, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
              name="USStateValidator" />
          </property>

When I attempt to validate the form in the test application using "RulesetB", it gives me the followin error: "Constructor on type "ValidationQuickStart.CustomValidators.USStateValidator" not found."

Here is the code for the validator as provided by Microsoft (I have made no changes to it):

namespace ValidationQuickStart.CustomValidators
{
    [ConfigurationElementType(typeof(CustomValidatorData))]
    public class USStateValidator : DomainValidator<string>
    {
        private static List<string> stateCodes = new List<string>(new string[] {
            "AL", "AK", "AS", "AZ", "AR", "CA", "CO", "CT", "DE", "DC", "FM", "FL",
            "GA", "GU", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MH",
            "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM",
            "NY", "NC", "ND", "MP", "OH", "OK", "OR", "PW", "PA", "PR", "RI", "SC",
            "SD", "TN", "TX", "UT", "VT", "VI", "VA", "WA", "WV", "WI", "WY"});

        public USStateValidator()
            : base(stateCodes)
        {
        }

        protected override string DefaultNonNegatedMessageTemplate
        {
            get { return "The supplied code does not represent a valid US State"; }
        }

    }
}

The USStateValidator appears to work normally when using "RulesetA" which uses only attributes on the BusinessEntity class.

Here is the example from the business entity class that works just fine:

[USStateValidator(Ruleset = "RuleSetA")] 
        public string State
        {
            get { return state; }
            set { state = value; }
        }

Does anyone know what is wrong with this? I need to get this validator working using the xml file instead of declaring on the actual class itself.

Stack overflow on validation

Sgro — Thu, 08 Oct 2009 14:55:14 GMT

I am using validators on my POCO classes for business validation.

When validating a class that references another class, or a collection of other classes (I apply objectvalidator or objectcollectionvalidator accordingly), I always get a stack overflow exception.

It seems like that each class keeps calling all referenced classes, including the calling one, and this leads to an infinite loop.

How can I avoid this?

Thanks.

Validate duplicate keys, is it possible?

Sgro — Wed, 07 Oct 2009 18:38:20 GMT

I was trying to create a custom validator for validation blocks, to validate a value against values contained in the data store.

My idea was somehow passing my IQueryable to the validator, and it would internally use it to see if the repository already has an item with the same key.

I can't seem to find the right approach to make it, so I was wondering if the Validation Blocks architecture can support a scenario like this.

Anyone has tried to make it, or maybe succeeded? It seems like a very common scenario to me.

Thanks.

Two errors - 'Sqlhelper not declared' and 'referenced component Microsoft.ApplicationBlocks.Data not found

bootzilla — Fri, 25 Sep 2009 20:10:38 GMT

I received these two errors: 'Sqlhelper not declared' and 'referenced component Microsoft.ApplicationBlocks.Data not found' for the code below. What do I need to correct these errors.

Imports Microsoft.ApplicationBlocks.Data
Imports System.Configuration.ConfigurationSettings

Namespace AFA.Data
    Public Class Sql
        Public Shared Function GetMemberByUsernamePassword(ByVal username As String, ByVal password As String)
            Return SqlHelper.ExecuteScalar(AppSettings("Connection"), CommandType.StoredProcedure, "GetMemberByUsernamePassword", username, password)
        End Function
        Public Shared Function GetContentByContentId(ByVal contentId As Integer) As SqlClient.SqlDataReader
            Return SqlHelper.ExecuteReader(AppSettings("Connection"), "PCMS_GetContentById", contentId)
        End Function
        Public Shared Function PerformSearch(ByVal search As String) As DataSet

            Return SqlHelper.ExecuteDataset(AppSettings("Connection"), "PCMS_FreeText", search)
        End Function
    End Class
    Public Class Forms

    End Class
End Namespace

ExceptionHandlingBlock error

Deidn — Fri, 18 Sep 2009 13:38:06 GMT

In my project I use exception handling block from enterprise services. There it seems like the policy I created would not be found. But please have a look first:

Here you can find the error message and an overview over the project.

And here's my (full) app.config file:

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="loggingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
    <section name="exceptionHandling" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Configuration.ExceptionHandlingSettings, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" />
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    <section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    <section name="openaccess" type="Telerik.OpenAccess.Config.ConfigSectionHandler, Telerik.OpenAccess.Config, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342" requirePermission="false" />
  </configSections>
  <loggingConfiguration name="Logging Application Block" tracingEnabled="true"
    defaultCategory="General" logWarningsWhenNoCategoriesMatch="true">
    <listeners>
      <add databaseInstanceName="XIS" writeLogStoredProcName="WriteLog"
        addCategoryStoredProcName="AddCategory" formatter="database formatter"
        listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Database.Configuration.FormattedDatabaseTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging.Database, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        traceOutputOptions="None" filter="All" type="Microsoft.Practices.EnterpriseLibrary.Logging.Database.FormattedDatabaseTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging.Database, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        name="Database Trace Listener" />
      <add fileName="C:\Temp\XIS.log" header="----------------------------------------"
        footer="----------------------------------------" formatter="Text Formatter"
        listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.FlatFileTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        traceOutputOptions="None" filter="All" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.FlatFileTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        name="FlatFile XIS TraceListener" />
    </listeners>
    <formatters>
      <add template="Timestamp: {timestamp}

Message: {message}

Category: {category}

Priority: {priority}

EventId: {eventid}

Severity: {severity}

Title:{title}

Machine: {machine}

Application Domain: {appDomain}

Process Id: {processId}

Process Name: {processName}

Win32 Thread Id: {win32ThreadId}

Thread Name: {threadName}

Extended Properties: {dictionary({key} - {value}

)}"
        type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        name="Text Formatter" />
      <add template="Timestamp: {timestamp}

Message: {message}

Category: {category}

Priority: {priority}

EventId: {eventid}

Severity: {severity}

Title:{title}

Machine: {machine}

Application Domain: {appDomain}

Process Id: {processId}

Process Name: {processName}

Win32 Thread Id: {win32ThreadId}

Thread Name: {threadName}

Extended Properties: {dictionary({key} - {value}

)}"
        type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        name="database formatter" />
    </formatters>
    <categorySources>
      <add switchValue="All" name="General">
        <listeners>
          <add name="Database Trace Listener" />
        </listeners>
      </add>
    </categorySources>
    <specialSources>
      <allEvents switchValue="All" name="All Events">
        <listeners>
          <add name="Database Trace Listener" />
        </listeners>
      </allEvents>
      <notProcessed switchValue="All" name="Unprocessed Category">
        <listeners>
          <add name="Database Trace Listener" />
        </listeners>
      </notProcessed>
      <errors switchValue="All" name="Logging Errors & Warnings">
        <listeners>
          <add name="Database Trace Listener" />
        </listeners>
      </errors>
    </specialSources>
  </loggingConfiguration>
  <exceptionHandling>
    <exceptionPolicies>
      <add name="General">
        <exceptionTypes>
          <add type="System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
            postHandlingAction="None" name="Exception">
            <exceptionHandlers>
              <add logCategory="General" eventId="100" severity="Error" title="General"
                formatterType="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.XmlExceptionFormatter, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
                priority="0" useDefaultLogger="true" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
                name="General" />
            </exceptionHandlers>
          </add>
        </exceptionTypes>
      </add>
      <add name="XIS Exception Policy">
        <exceptionTypes>
          <add type="System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
            postHandlingAction="None" name="Exception">
            <exceptionHandlers>
              <add logCategory="General" eventId="100" severity="Error" title="XIS Ex Handler"
                formatterType="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.TextExceptionFormatter, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
                priority="0" useDefaultLogger="true" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.LoggingExceptionHandler, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
                name="XISLogging Handler" />
            </exceptionHandlers>
          </add>
        </exceptionTypes>
      </add>
    </exceptionPolicies>
  </exceptionHandling>
  <dataConfiguration defaultDatabase="XIS" />
  <connectionStrings>
    <add name="XIS" connectionString="data source=ROB\ROB;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
  <enterpriseLibrary.ConfigurationSource selectedSource="System Configuration Source">
    <sources>
      <add name="System Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </sources>
  </enterpriseLibrary.ConfigurationSource>
  <openaccess xmlns="http://www.vanatec.com/OpenAccess">
    <references>
      <reference assemblyname="XSite.XIS.DataModel" configrequired="True" />
    </references>
    <connections>
      <connection id="XISConnection">
        <databasename>XIS</databasename>
        <servername>ROB\ROB</servername>
        <integratedSecurity>True</integratedSecurity>
        <backendconfigurationname>mssqlConfiguration</backendconfigurationname>
      </connection>
    </connections>
    <backendconfigurations>
      <backendconfiguration id="mssqlConfiguration" backend="mssql">
        <mappingname>mssqlMapping</mappingname>
      </backendconfiguration>
    </backendconfigurations>
    <mappings current="mssqlMapping">
      <mapping id="mssqlMapping" />
    </mappings>
  </openaccess>
</configuration>

Now, the problem is the error messages you see in one of the pictures. What I tried so far is all kinds of changes to the App.config file and I also created a Web.config file for the non-web-project in despair it would only recognize a Web.config file..

I'd be very grateful for tipps!

Please be patient with me answering, I'm away until Wednesday.

Thanks in advance!
Best
Deidn

Need help using ExecuteReader(storedProcName As String, ParamArray paramValues() as Object)

xaeryan — Thu, 17 Sep 2009 16:56:49 GMT

This is from the Microsoft enterprise library. You can see the definition here: http://msdn.microsoft.com/en-us/library/bb748706(BTS.10).aspx

I'm trying to do something like this to no avail:

Dim myParams() As Object = {"Val1", "Val2"}
        Dim myReader As SqlDataReader = DatabaseFactory.CreateDatabase().ExecuteReader("usp_Test", myParams)

It gives me a runtime error saying the number of parameters does not match. My stored proc takes two varchar(10) parameters.

Anyone know what I'm doing wrong?

EnterpriseLibrary.Logging.xml file

mkrok — Tue, 01 Sep 2009 13:48:05 GMT

Using EntLib 4.1 used in ASP.NET web app and a refrenced library. The solution contains 4 projects, 2 refrenced libraries, the web application, and a web setup project.

Build works just fine, even the setup project. Problems occur when I rebuild, there is an EnterpriseLibray.Logging.xml file that is supposed to be in the \bin folder (along with the .dll) but it never shows up. I know rebuiold cleans the output folder first, then builds the refrenced apps, then the web app, then the web setup application.

First off - what is EnterpriseLibrary.logging.xml used for? Can't seem to find it any information about it. I followed Scott Hanslemans post about this problem with Web Setup projects (http://www.hanselman.com/blog/VisualStudioMSIProblemsUnableToBuildProjectOutputGroupContentFilesFromSOMEWEBActive.aspx)

however I don't think this is a problem with the WebSetup project, I think the EnterpriseLibrary.Logging.xml file should be in the bin folder whne the Web Project is built (or rebuilt)

Thanks in advance

Michael Krok

The current build operation failed: Access is denied.

daemae — Tue, 04 Aug 2009 16:22:49 GMT

Hi,

I am using the caching feature of Enterprise Library 4. It's working on my local machine but after I have published the web app to the staging server, I have received the error below:

"The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Caching.ICacheManager, Cache]) failed: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (Strategy type Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy, index 2)" string "

I have given the aspnet and network service the full permission but the error still exists. The ff. dlls are also present in the BIN:

Microsoft.Practices.EnterpriseLibrary.Caching.dll
Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.ObjectBuilder2
Microsoft.Practices.Unity.dll

Please help me as I am new in using the Enterprise Library.

Thank you so much!

Sql Helper

ncsubbu — Sat, 29 Aug 2009 10:12:04 GMT

I am using sql Helper for Data Access.I am implemented the connection pooling in web.config. I have 10000 records.I am using view to retrive the record from different tables from sqlserver. I got the Error is below while access from application.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Please give me the any solution for this problem.

Enterprise Library 4.1 Logging Application Block Archive Log files.

sudipta — Mon, 10 Aug 2009 10:46:34 GMT

I am using Enterprise Library 4.1 Logging application block. Using a rolling flat file trace listener to save thelog file into the Application Root/Log directory. The listener is configured as:

<listeners>
      <add fileName="Log\RMSLog.log" footer="----------------------------------------"
        formatter="Text Formatter" header="----------------------------------------"
        rollFileExistsBehavior="Overwrite" rollInterval="Day" rollSizeKB="0"
        timeStampPattern="yyyy-MM-dd" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.RollingFlatFileTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        traceOutputOptions="None" filter="All" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.RollingFlatFileTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        name="Rolling Flat File Trace Listener" />
</listeners>

Now, I want to save the archived files(archiving set to daily basis) into a different directory like "Archive". How to do that?

How to customize logging ? Need help

sarathmn — Wed, 12 Aug 2009 05:35:43 GMT

Hi,

I have planned logging application block to log exceptions to database. Now i need to customize the logging. I need only one table.(i dont want the category table). Also I need the table to have only 3-4 columns(not all the columns). Also I need custom name for the table and the stored procedure. What modifications or code changes I have to made in the config/ code files to achieve these?

Thanks

Sarath

EnterpriseLibrary - Help

arunveerappan — Fri, 10 Apr 2009 13:53:20 GMT

Hi Members,

When i run my application in 2.0 FrameWork I get the below message. This is bugging mr for past one week. Kindly, help me if you'd confronted this error in your project.

Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings' to type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code

Exception Details: System.InvalidCastException: Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings' to type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings'.

Line 36: 							throw new Exception("Erorr creating IMapperRegistry from configuration file. Check the configuration key "+iMapperRegistryConfigKey);
Line 37: 						}
Line 38: 						Logger.Write("MapperRegistryAccessor:Successfully created registry from config key "+iMapperRegistryConfigKey,"Domain",1,0,Severity.Information);
Line 39: 					}
Line 40: 			///	}


Source File: D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\Mappers\MapperRegistryAccessor.cs    Line: 38

Stack trace:

[InvalidCastException: Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings' to type 'Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings'.]
   Microsoft.Practices.EnterpriseLibrary.Logging.LoggingConfigurationView.GetLoggingSettings() in c:\EnterpriseLibrary\EnterpriseLibrary\Logging\LoggingConfigurationView.cs:65
   Microsoft.Practices.EnterpriseLibrary.Logging.LogWriter.Write(LogEntry log) in c:\EnterpriseLibrary\EnterpriseLibrary\Logging\LogWriter.cs:83
   Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(Object message, String category, Int32 priority, Int32 eventId, Severity severity, String title, IDictionary properties) in c:\EnterpriseLibrary\EnterpriseLibrary\Logging\Logger.cs:201
   Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(Object message, String category, Int32 priority, Int32 eventId, Severity severity) in c:\EnterpriseLibrary\EnterpriseLibrary\Logging\Logger.cs:119
   Qwest.Infrastructure.Common.Domain.Mappers.MapperRegistryAccessor.get_MapperRegistry() in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\Mappers\MapperRegistryAccessor.cs:38
   Qwest.Infrastructure.Common.Domain.DomainObject.GetMapper(Type entityType) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\DomainObject.cs:292
   Qwest.Infrastructure.Common.Domain.DomainObject.Find(String entityName, String description, Type entityType) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\DomainObject.cs:264
   Qwest.Infrastructure.Common.Domain.Contacts.Contact.FindContact(String login) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\Contacts\Contact.cs:350
   Qwest.Infrastructure.Common.Domain.Contacts.Contact.FindContactByExactCUID(String cuid) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.Infrastructure\Qwest.Infrastructure.Common\Domain\Contacts\Contact.cs:355
   Qwest.BAHD.BL.Contacts.BAHDContact.FindContactByExactCUID(String cuid) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.BAHD\SRC\Qwest.BAHD.BL\Contacts\BAHDContact.cs:99
   Qwest.BAHD.BL.Contacts.BAHDContact.set_CurrentContact(BAHDContact value) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.BAHD\SRC\Qwest.BAHD.BL\Contacts\BAHDContact.cs:47
   Qwest.BAHD.UI.Global.Application_AcquireRequestState(Object sender, EventArgs e) in D:\Josh BAHD Copy on_02222009\Qwest\Qwest.BAHD\SRC\Qwest.BAHD.UI\Global.asax.cs:305
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

I've Copied my browser text for your reference. Please help.

Arun

what is sqlhelper

prk — Wed, 30 Nov 2005 20:55:37 GMT

Hi friends
whats sqlhelper ? these days am keep reading abt this class .looks like its a class related to DAAB.
am using patterns & practices june edition application block but i did not see any sqlhelper class in it !!
this sqlhelper class is in old version of DAAB ,is it?
Thanks for your input