Tuesday, January 29, 2008

What A Rough Day!!

That was yesterday!! It was a very bad one in terms of productivity. We literally spent the whole day trying to access one instance of SQL Server from other system on the network. But in vain. Microsoft does provide a Knowledge Article on what changes to make to enable remote access but even after that we were left high and dry!

My aim was to understand how data flows in a 3-Tier architecture. But without database connectivity, building the DAL itself was impossible. In the end we decided to proceed with local databases instead of Remote access and try and meet some of the fast approaching deadlines.

Today, was a fruitful one! Referring to msdn and my MCTS prep book I was trying to build one small module and that too with the proper architecture. Some of my team-mates were initially averse in building separate layers for Business Logic and Data Access but I pressed and convinced them. For the time being at least.

The best part was after a days work, of the three Unit Test Cases I had written for this module, I was successful in 2 of them at the first shot. And the third case which failed was debugged in no time, thanks to the proper segregation of business logic and data access from the presentation.

The coming days are going to be more exciting as I hope to learn more about Disconnected classes for data access in ADO.NET. Will surely post a few useful tips around the weekend!! Hopefully!

Till then, Happy Programming!

No comments:

Post a Comment