SQLHelper Class

问题:

Is there a recent version of the SQLHelper class out there. I've been using one for a few years now and was wondering if there is a new version out there for .NET Framework 2.0 or 3.0. I prefer this on small projects vs Microsoft Data App Block (which I use on larger projects).

I came across this link

http://www.microsoft.com/downloads/details.aspx?familyid=f63d1f0a-9877-4a7b-88ec-0426b48df275&displaylang=en

回答1:

According to this...

SqlHelper was actually replaced with an abstract class, called Database, and two concrete classes that derive from it: SqlDatabase and OracleDatabase.

回答2:

To follow up on this question since it hasen't been answered:

Is there a new version to the 2004 sqlHelper class which can be retrived from:

http://www.microsoft.com/downloads/details.aspx?familyid=f63d1f0a-9877-4a7b-88ec-0426b48df275&displaylang=en

I know there are Application Blocks part of Enterprise Library 4.1 Oct 2008, but I can't find the sqlHelper class in it.

回答3:

I have an extend version of this library It's available on GitHub: and NuGet. It was based on the source code of the SqlHelper.

Extra features that i think that aren't in the original

• Async/await
• MySql Support
• Generics