Subsonic - All your Databases Belong To Us

Recently a colleague of mine introduced me to an amazing technology. Subsonic is a tool that integrates closely with Visual Studio 2005 and will generate an object model for your database at compile time based on the database connection in your web.config.

This greatly simplifies your code as all the connection logic, proc calls with types etc all disappear into a couple lines of code. Its amazing. You should really look into it. I have provided a couple links here to get you started.\\

Here is the main site for the project: http://www.subsonicproject.com/
You will also want the tools that integrate with Visual Studio 2005 available at:
http://www.codeplex.com/subsonictools

If you have any cool links about subsonic post comments here with them or email them to me at chris@clinchportal.com or chrisw_88@hotmail.com

Enumerating SQL Servers from .NET 2.0

I ran into a situation where I was not sure of the name of the SQL Server I would be using on a hosted site.

I found this code that helped to find a list of them all.

http://dotnetslackers.com/SQL/re-20320_Enumerating_SQL_Servers_from_NET_2_0.aspx

Hope this helps you too.

Introduction

Welcome To The VB.NET Guild.

Although, I am mainly a C# developer and actually prefer it, I have been getting comments from vb.net developers that there is a growing need for a Guild for them as well.

I have finally caved and here we are. I will try an place cross-over articles on both blogs and place vb.net specific ones here.

If you have any vb.net specific issues, tips, tricks, sample code you wish to share with the guild simply email me at chris.williams@clinchportal.com and I will post them here.