Scott on Writing

Musings on technical writing...

Working with Data in ASP.NET 2.0 - Complete!

Over the past year or so I've been creating a series of ASP.NET 2.0 tutorials for Microsoft that focus on working with data. These tutorials have been published on www.asp.net and on the MSDN website with the first batch published in June 2006. The Working with Data in ASP.NET 2.0 tutorials were modeled after the tutorial series started by Scott Guthrie and aimed to provide step-by-step instructions (with lots of screen shots) on how to perform common data-related patterns. I use the past tense here because, this past weekend, I wrapped up the final milestone for the data tutorials, turning in the final VB and C# versions of the 75th tutorial!!

At the time of this writing the most recent tutorials to be published were the Working with Binary Files tutorials (#54-#57). The upcoming tutorials examine:

  • Caching (four tutorials)
  • Data and the Site Map Provider (one tutorial)
  • Working with Batched Data (looks at using transactions; four tutorials)
  • Advanced Data Access Layer Scenarios (nine tutorials)

Writing these tutorials was very similar in process to writing a book. I'd wager that the average tutorial is about 10 printed pages in length, so the series is equivalent to authoring a 750 page book. It should come as no surprise, then, that I feel as spent as when sending off the final author review to a publisher. And, like after authoring a book, I am more than ready for a break from this time-intensive writing.

There are plenty of differences between writing a book and writing a book-length online tutorial series, of course. With a book you don't see a physical manifestation of the hard work until many months after the book has been written and reviewed. Online work, however, allows for incremental and quicker publication schedule, which.helps keep me motivated. And while well-publicized technical online material is more accessible and read by more people than a book, there's still something alluring about books... about being able to see a physical manifestation of your work in a bookstore. To see someone thumbing through your book. To hold it in your hands, to skim the table of contents, to turn to a random page and cast your mind back to the days you spent writing that chapter. These sensory delights are nice, but come at a cost, as writing computer trade books very often has a terrible ROI - see The Economics of Writing a Computer Trade Book for a more detailed breakdown of why writing computer trade books is not the way to riches.

Many thanks to those who helped review the tutorials or who have provided feedback or pointed out typos or other issues since their publication. One of the nice things about having an “online book” is that it is much easier to fix typos and update code, if necessary, so keep sending in corrections.

posted on Tuesday, April 03, 2007 12:03 PM

Feedback

# re: Working with Data in ASP.NET 2.0 - Complete! 4/3/2007 1:00 PM scottgu

Absolutely fantastic job Scott!

Thank you so much for all your hard work with these tutorials - developers all over the world really appreciate it!

# re: Working with Data in ASP.NET 2.0 - Complete! 4/3/2007 1:06 PM Mike

The ones I have read have been great. Have you thought about combineing them and making a book or at least an ebook?

# re: Working with Data in ASP.NET 2.0 - Complete! 4/3/2007 2:08 PM Alper

Congratulations.. Thanks for your time and effort.

# re: Working with Data in ASP.NET 2.0 - Complete! 4/3/2007 2:12 PM Andy

I've been reading these since Scott Gu started them. They are great and I have applications built and in use using many of the principles.

They are like a book to me - I have them all printed and regularly refer to them.

Thanks Scott for all your hard work.

# re: Working with Data in ASP.NET 2.0 - Complete! 4/3/2007 9:44 PM Sunita

good book

# Topic Suggestion: Maintaining your DAL 4/4/2007 5:38 AM flipdoubt

I do like these tutorials, but I often run into problems maintaining the DAL generated by VS.NET. Let's say I widen a varchar field in a table, which necessitates changing the length of varchar parameters to stored procedures. Finding all the places where I need to update the parameters can be a chore, as there are many different file types involved in the code generated by VS.NET.

I would really appreciate a tutorial on maintaining your DAL in the face of database changes, ASP.NET GUI changes, requirement changes, etc.

# re: Working with Data in ASP.NET 2.0 - Complete! 4/6/2007 2:26 AM Corne

I only discovered these tutorials earlier this week and have been working through them (I'm up to 17 now). They've been a great help to me and I'm changing my entire approach to be more in line with the way you're doing it here.

Thanx a lot!

# re: Working with Data in ASP.NET 2.0 - Complete! 4/7/2007 12:43 AM daybug

I read nearlly all of the articles and i learnt a lot!
Thanks!

# re: Working with Data in ASP.NET 2.0 - Complete! 4/9/2007 11:52 AM David

Any ideas when the new content will be live on the site?

# re: Working with Data in ASP.NET 2.0 - Complete! 4/9/2007 12:32 PM Scott Mitchell

David, content is usually put out once every other week. I always blog about it here on ScottOnWriting.NET once new content is available.

Thanks

# re: Working with Data in ASP.NET 2.0 - Complete! 4/12/2007 12:28 PM Fishball

Thank you very much! I've learned so much from your tutorials that I didn't learned from any other books. Keep-up the good work :)

http://webdevelopmentbooks.blogspot.com/

# Working with Data in ASP.NET 2.0 4/14/2007 11:09 AM ScottGu's Blog

A ton of great articles and tutorials on working with data in ASP.NET 2.0 applications has been published

# Working with Data in ASP.NET 2.0 4/14/2007 12:11 PM ASP.NET

A ton of great articles and tutorials on working with data in ASP.NET 2.0 applications has been published

# Working with Data in ASP.NET 2.0 4/14/2007 12:17 PM BusinessRx Reading List

A ton of great articles and tutorials on working with data in ASP.NET 2.0 applications has been published

# 本周ASP.NET英文技术文章推荐[04/15 - 04/21] 4/20/2007 5:35 PM Dflying Chen

??????9???:?ASP.NET2.0?????UpdateControls1.1:????????UpdateAction?EnterpriseLibrary3Valid...

# re: Working with Data in ASP.NET 2.0 - Complete! 4/23/2007 4:00 AM PJ

Hi Scott,
Great to see you finally finished the tutorials, they've been a great help to me in understanding DAL's etc...
I'd just like to second flipdoubt's suggestion above, it would be great to see some suggestions as to how to deal with changes in the DAL when changes to the underlying database are necessary. How to regenerate the DAL and maybe how to propogate the changes through the code...if possibile...
Thanks again for a great resource...
PJ

# 【收藏】本周ASP.NET英文技术文章推荐[04/15 - 04/21] 11/29/2007 1:12 AM Jacky_xu

?? ????9???: ?ASP.NET2.0????? UpdateControls1.1:????????UpdateAction ?EnterpriseLibrary...

Title:  
Name:  
Url:
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments   

Add To Your Reader

My Links

Archives

Post Categories

 

I am a Microsoft MVP for ASP.NET.
I am an ASPInsider.
<May 2008>
SMTWTFS
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

Comment Stats

DayTotal% of Total
Sunday 1866.8%
Monday 37913.9%
Tuesday 45316.7%
Wednesday 50418.5%
Thursday 53519.7%
Friday 49418.2%
Saturday 1666.1%
Total 2717100.0%

Hour1Total% of Total
12:00 AM 652.4%
1:00 AM 682.5%
2:00 AM 622.3%
3:00 AM 742.7%
4:00 AM 572.1%
5:00 AM 1033.8%
6:00 AM 1084.0%
7:00 AM 1585.8%
8:00 AM 1716.3%
9:00 AM 1475.4%
10:00 AM 1716.3%
11:00 AM 1816.7%
12:00 PM 1886.9%
1:00 PM 1696.2%
2:00 PM 1605.9%
3:00 PM 1324.9%
4:00 PM 1073.9%
5:00 PM 923.4%
6:00 PM 913.3%
7:00 PM 963.5%
8:00 PM 833.1%
9:00 PM 782.9%
10:00 PM 792.9%
11:00 PM 772.8%
Total 2717100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 5.54144
Monday 5.22339
Tuesday 4.28419
Wednesday 7.67637
Thursday 6.90607
Friday 5.48411
Saturday 5.33160
Total 5.842717

Hour1 Entry MadeAvg.Total
12:00 AM 5.0035
1:00 AM 1.002
5:00 AM 0.000
7:00 AM 7.0035
8:00 AM 5.35107
9:00 AM 6.32278
10:00 AM 6.47246
11:00 AM 4.41181
12:00 PM 6.88330
1:00 PM 3.00111
2:00 PM 5.41222
3:00 PM 8.64285
4:00 PM 4.0589
5:00 PM 5.92154
6:00 PM 4.52113
7:00 PM 9.67174
8:00 PM 9.80147
9:00 PM 5.05111
10:00 PM 5.4265
11:00 PM 4.5732
Total 5.842717

Learn More About Comment Stats
1 - All times GMT -8...


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles