Standard db access component

[Guy Incognito]

Hello,

I've developed a component that encapsulates common database activities.

This example creates a parameter array and executes a stored procedure:

SqlParameter[] list = {
SqlTool.GetParameter("@ID", 11),
SqlTool.GetParameter("@Name", "Steve")
}

SqlTool.ExecuteNonQuery("spUpdateName", list);

The type of the parameter is determined by polymorphism. The connection
string is taken from a key in web.config.

Here's my question: Is there a commonly used component for this kind of
thing? I've heard that Microsoft has one, but I haven't been able to
find it on their site.

Thanks,
Jason
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[William Ryan eMVP]

http://msdn.microsoft.com/library/de...ml/daab-rm.asp
--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"Guy Incognito" <an*******@devdex.com> wrote in message
news:e5**************@TK2MSFTNGP10.phx.gbl...

Hello,

I've developed a component that encapsulates common database activities.

This example creates a parameter array and executes a stored procedure:

SqlParameter[] list = {
SqlTool.GetParameter("@ID", 11),
SqlTool.GetParameter("@Name", "Steve")
}

SqlTool.ExecuteNonQuery("spUpdateName", list);

The type of the parameter is determined by polymorphism. The connection
string is taken from a key in web.config.

Here's my question: Is there a commonly used component for this kind of
thing? I've heard that Microsoft has one, but I haven't been able to
find it on their site.

Thanks,
Jason
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!