Visual Studio 2008, SubSonic

I finally have Visual Studio 2008 installed on my home computer. I have not used it much except for compiling the Video.Show open source video sharing site. However you can use Visual Studio 2008 to work on an ASP.NET 2.0 project and I did recently convert one of my major client sites to ASP.NET 2.0.

Today I installed SubSonic and learned how to use it. SubSonic can be used to generate the Data Access Layer for your .NET applications. It can create the entire database administration section for your ASP.NET web application using scaffolding. This will save me a lot of development time because the biggest chore is creating the CRUD (Create, Read, Update, and Delete) pages for every table. I think it can also be used to create a web application that can use either SQL Server or MySQL as its database because all of the data access is done through SubSonic which supports various providers. This would come in handy when a client decides to change hosting providers and needs to convert from MySQL to SQL Server or vice versa.