Browse by Tags
All Tags »
Data Layer Focus (
RSS)
Rob posted the fixes and it seems like it could be helpful when working with Oracle packages and store procedures. I will need to check it out.
I've just notice that Microsoft Oracle Provider Download file include V2 but entLib is using the previous version - I hope we don't missing something from the latest & greatest version.
Within the Dal layer we could catch SqlException and then format the Exception Message to a more user friendly message using the application localization language and by reading the message from a resource file. Then we can and should create our application...
I like this recommendation text I attached, about the way we should consider to handle our Dal exception/s because its very clear, simple and convincing. The following attach text is from a one of the architecture guide within the Microsoft architecture...
Here is a the store procedure implementation from "Custom Data Paging in ASP_NET - ASP_NET" article which located on CodeProject Similar code were added to one of the articles I 've just read in MSDN May Magazine. We can use it with a DataGrid custom...
This post include IDispose implementation for wrapping a Transaction instance (same datasource). On this snippet I'm using entLib for creating my Transaction instance. I also attached the DAL caller code snipped and the DAL method that is using the Transaction...
I enjoyed to be involved in projects when we had to use Oracle RDBMS. I found that pl/sql is highly enhance and gives developers a rich pl/sql language to solve extremely complex problems in a simple and intuitive way. What I didn't like and a lot of...
The article Kiss the Middle-tier Goodbye with SQL Server Yukon which claim: Yukon's new XML support features cut out the middleman and allow you to deal with your data directly on the database tier. Learn how to use these features to improve your database...
[ CORRECTION : The fields actually expose as properties using the DB Table original name/s but the internal strong typed table Type is as I specified. The point is , it would be nice if we could configure the naming convention we would like to use and...
More Posts
Next page »