Hi -



My question involves where to put "ado helper" functions within a Visual

Basic COM+ component.



I am piecing together a set of COM+ based-middleware services based on the

Wrox "beginning e-commerce" design and Microsoft's Nile.com example.



Info on Nile can be found at:



http://msdn.microsoft.com/vstudio/centers/scale/nile.asp



I like Wrox object model, but Nile seems to have more sophisticated db

access code than the beginning e-commerce site (Nile has an excellent set 

of functions for running parameterized stored procs and also has thorough

error-handling).



I am wondering, however why the nile.com architects decided to put the

database access functions in a .bas file rather than in a .cls.



Has anyone taken a look at the nile application ???  If not, I suggest

checking it out ... the application is not that sophisticated, but the db

access code seems quite good and I am interested in taking the best of the

wrox commerce site and Nile and adapting them for my use.



At the top of my list of quesitons is the value of modifying the Nile

database.bas function library and converting it to a Class in order to use

it in the Wrox Beginning E-Commerce component.  (I will be

running the application on w2k and Com+).



All of the functions and subs in the .bas code are methods that are used by

the classes of the component.



Is there any reason to re-code the .bas library and make it a class ???  Is

there anything to read about that will help me understand when I should use

.bas files for functions that are used by classes ????



Many thanks,



Steve