The i-Technology Media!
Register | Log in
   
 
.NET  ·  AJAX  ·  CLOUD  ·  ECLIPSE  ·  FLEX  ·  OPEN WEB  ·  iPHONE  ·  JAVA  ·  LINUX  ·  OPEN SOURCE  ·  ORACLE  ·  PBDJ  ·  SEARCH  ·  SILVERLIGHT  ·  SOA  ·  VIRTUALIZATION  ·  WEB 2.0  ·  WIRELESS  ·  XML
Comments
Google Wave Invitation Giveaway
By Aditya Banerjee
Timo Hirvonen wrote: I would really appreciate an invitation. Been desperately trying to find one :) timo [dot] hirvonen [at] gmail [dot]com
Nov. 27, 2009 11:13 AM EST
Cloud Expo on Google News
Did you read today's front page stories & breaking news?


2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts

2009 East
GOLD SPONSORS:
CA
Get Your Transactions Under Control: SOA Performance Management
Software AG
Performance Driven Adoption: The Secret to Advancing SOA
Intel
The Evolving SOA Appliance: 3 Game-Changing Innovations
SILVER SPONSOR:
Denodo
Data Mashups: Deliver Your Project Faster with Virtualized Data Services Across Internal & External Sources
POWER PANELS:
The Business Value of Service Orientation
Driving Profitability Through User Experience
Click For 2008 West
Event Webcasts
Live Google News by SYS-CON!
Top Three Links You Must Click On


Book Review
.NET Book Review — Best Kept Secrets in .NET
Revealing the secrets to improve your productivity and code quality

By: Steven Mandel
May. 17, 2006 03:00 PM

Lately, it seems that every computer book that you find is a weighty tome of at least 500 or 600 pages. You groan just thinking about having to schlep another monster-size book around. It is so nice then to inform you that sometimes good things do come in small packages. This book, while only 200 pages, contains lots of nuggets that will appeal to all levels of developers.

Chapter one covers an exhaustive list of navigation short cuts that you will find in Visual Studio 2003. If you want to master getting around in Visual Studio, this is a great chapter to have nearby. I would urge Ms. Kurata to update this chapter to include Visual Studio 2005 shortcuts as well.

In chapter two's topics on Windows Forms is an important discussion on how to use the Windows Form's error provider to do proper validation in a Winform setting.

Chapter three has code tips. There are some terrific tables that outline the use of regular expressions that Apress should think about including in Nathan Good's otherwise terrific book on regular expressions Regular Expression Recipes for Windows Developers: A Problem-Solution Approach. Another interesting discussion Ms. Kurata has in this chapter is the way you can go about marking your code as obsolete by using the Obsolete Attribute in your code.

Chapter four covers various ADO.NET topics. There is an additional benefit that using a database project provides. It allows you to organize your stored procedures into meaningful folder names and to keep track of all your changes using Visual Source Safe. In this chapter, she also provides a very neat tip on viewing datasets as XML which is very handy especially when you are in the midst of debugging.

In the last chapter, Ms. Kurata discusses myriad tips and techniques to make your code more durable such as creating a general exception handler and ideas put forth by the advocates of extreme programming.

Is this book worth having? You bet ya and as Ms. Kurata notes, "Did you say 'I didn't know that!' at least one while reading this book. If so it met its object of revealing the best-kept secrets of .NET."

A Side Note
I would like to discuss an often overlooked aspect of application development that Ms. Kurata touches upon in her book. In general, we tend to view stored procedures, views, and user-defined functions as "second class" code that does not require proper tracking through source code control. It is true that SQL Server does not lend itself to placing these vital pieces of code under source code control. However, now that we have the ability to create database projects inside of Visual Studio and place them under source code control, there is no longer an excuse for not properly tracking changes made to "database" code that is just as vital to your application as your VB.NET or C# code.

Visual studio provides templates that you can use when creating new stored procedures, views, and udfs. These templates can be found in "C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\Templates\Database Project Items". If you decide to modify the templates ,you should rename them and leave them in the same directory. They will be included in the list of possible templates to select when adding a new stored procedure in the project.

While it may take a bit of time, I would highly recommend placing all of your existing stored procedures in database projects. You will have to manually add some of the features that the template provides but it will be worth it. Also, the flow of your development will always begin and end with the database project. You will check out the database "code" when you need to modify it and you will check it back in with your modifications after you have revised it.

SIDEBAR

Title: Best Kept Secrets in .NET
Author: Deborah Kurata
Publisher: Apress
ISBN #: 1-59059-426-6
Price: US $29.99

Published May. 17, 2006— Reads 13,471
Copyright © 2006 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
About Steven Mandel
Steven Mandel has worked in the IT industry for over 15 years designing databases using Microsoft Access and SQL Server. He has developed Web and Windows applications using VB.NET and has written numerous articles and reviews about ASP.NET and VB.NET.

Add Your Feedback

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021

SYS-CON Featured Whitepapers

ADS BY GOOGLE

Breaking Java News
Killdeer Minerals Announces Financing With MineralFields Group
West Street Announces Third Quarter Results
Homeland Uranium Inc. Reprices Options
South American Silver Corp. Completes $2.78 Million Financing
Stone Resources Limited Announces Resignation of Directors
L.A.'s West 3rd Street to Launch Public Valet Service Tomorrow
Lorus Therapeutics Raises $2.46 Million in Equity Financing
Cagim Announces Increase in Results for Second Quarter of Fiscal Year 2009
Chai-Na-Ta Corp. Reports 2009 Third Quarter Results

ADVERTISE   |   MAGAZINE SUBSCRIPTIONS   |   FREE BREAKING-NEWSLETTERS!   |   SYS-CON.TV   |   BLOG-N-PLAY!   |   WEBCAST   |   EDUCATION   |   RESEARCH

.NET Developer's Journal - .NETDJ   |   ColdFusion Developer's Journal - CFDJ   |   Eclipse Developer's Journal - EDJ   |   Enterprise Open Source Magazine - EOS
Open Web Developer's Journal - OPENWEB   |   iPhone Developer's Journal - iPHONE   |   Virtualization - Virtualization   |   Java Developer's Journal - JDJ   |   Linux.SYS-CON.com
PowerBuilder Developer's Journal - PBDJ   |   SEO / SEM Journal - SJ   |   SOAWorld Magazine - SOAWM   |   IT Solutions Guide - ITSG   |   Symbian Developer's Journal - SDJ
WebLogic Developer's Journal - WLDJ   |   WebSphere Journal - WJ   |   Wireless Business & Technology - WBT   |   XML-Journal - XMLJ   |   Internet Video - iTV
Flex Developer's Journal - Flex   |   AJAXWorld Magazine - AWM   |   Silverlight Developer's Journal - SLDJ   |   PHP.SYS-CON.com   |   Web 2.0 Journal - WEB2
Apache   |   CMS   |   CRM   |   HP   |   Oracle Journal   |   Perl   |   Python   |   Red Hat   |   Ruby on Rails   |   SAP   |   SaaS

SYS-CON MEDIA:   ABOUT US   |   CONTACT US   |   COMPANY NEWS   |   CAREERS   |   SITE MAP
SYS-CON EVENTS:   |  AJAXWorld Conference & Expo  |  iPhone Developer Summit  |  Cloud Computing Conference & Expo  |  SOA World Conference & Expo  |  Virtualization Conference & Expo
INTERNATIONAL SITES:   India  |  U.K.  |  Canada  |  Germany  |  France  |  Australia  |  Italy  |  Spain  |  Netherlands  |  Brazil  |  Belgium
 Terms of Use & Our Privacy Statement     About Newsfeeds / Video Feeds
Copyright ©1994-2008 SYS-CON Publications, Inc. All Rights Reserved. All marks are trademarks of SYS-CON Media.
Reproduction in whole or in part in any form or medium without express written permission of SYS-CON Publications, Inc. is prohibited.
 
close this window