<p>Came across this:</p>

<p><a href="http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp" rel="nofollow noreferrer">http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp</a></p>

<p>And wondering if this is the right solution as I am not that big of a fan of creating a class for every stored procedure or do I use Enterprise Library for ASP.net 2.0 project.</p>

Is there any possibility of upgrading to framework 3.5? if so take a look at LINQ to SQL and Entity Framework as this will accomplish alot of this for you.
If not then as long as it generates standard code that doesnt tie you into 3rd party libraries then you could certainly use it. At my workplace we have our own generator similar to this and it works well although we will shortly be moving to LINQ to SQL.