By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,865 Members | 1,365 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,865 IT Pros & Developers. It's quick & easy.

Exception Handling using Enterprise Library 3.1

P: 1
Hi All:

I am trying to implement Exception Handling using Enterprise Library 3.1's Exception Handling Application Block as well as Logging Blocks.

I have a windows application developed in VB.Net (Visual Studio 2005) which have three tiers:

User Interface
Business Logic
Data Layer

I created Three Policies for each tier using Enterprise Library Configuration Utility. Where i am logging all exceptions to a Rolling Flat File, but i am lost at one certain functionality.

When exception occured in Data Layer iam unable to log Line Number of the error occured, for example:

I have a query class in which there will be number of queries placed in functions. I willfully modified one query which will results as Exception.

Erroneus Query:
Select Name, Age from Profiles where MyLower(Name) = 'bill gates'

Ps : MyLower is not a valid Scalar Function

Above query results System.Data.OledbException, infact Exception Handling Logging Block is able to log the same exception to Flat file as follows:

Scalar function not found: MyLower Select Name, Age from Profiles where MyLower(Name) = 'bill gates'

But it is unable to log which function and which class file the exception occured.

Please suggest me how to achieve the same. Please mail me back if you need further clarfication for my question.

Aug 12 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.