Data Access - The SqlDataSource Part 2.5
Ok so I made a mistake when I kicked off this series...I picked Sql Server Express as our database for all the logical reasons...however I failed to remember that Sql Server Express doesn't do Sql Cache Dependency...so instead of retro fitting my series to use Sql Server 2005 I'll punt and just say (for now) that the Sql Data Source can cache the results of your queries to improve performance and can even take advantage of cache dependencies (provided you are using Sql Server 2005).
So I am going to leave caching out of the series for the moment. I will come back to it at the end of the series and show it in action.
Please be gentle with me...I'm not a professional blogger. :-)
Ryan