471,337 Members | 825 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Exception Handling using Enterprise Library 3.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
0 1967

Post your reply

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

Similar topics

6 posts views Thread by Daniel Wilson | last post: by
1 post views Thread by Ray5531 | last post: by
16 posts views Thread by Chuck Cobb | last post: by
3 posts views Thread by Bruce One | last post: by
reply views Thread by =?Utf-8?B?UG9sbHkgQW5uYQ==?= | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.