SQL Data works in debug but fails in release

Topics: Data Access Application Block
Jan 7, 2012 at 12:01 AM
Edited Jan 7, 2012 at 12:57 AM

I just joined a group which is using Enterprise LIbrary 3.1
They have implemented logging in a SQL database using the Data component  works fine in debug code but writes nothing to the database in release once the pdb files are removed.

Does anyone have any suggestions?

Jan 8, 2012 at 7:55 AM

Do you have the Errors Special Source configured to log to a flat file or Event Log or have you written your own logging using DAAB?  If there is an exception in the block it would be logged to the destination specified in the Errors Special Source.  

Based on this thread I would say to attempt to create a small project that reproduces the issue.

Randy Levy
Enterprise Library support engineer

Jan 11, 2012 at 2:01 AM

I tracked this down to a contraint violation involving a NULL value which was causing the database to reject the insert.