Developer's Guide to ASP.NET 3.5 Master ASP.NET 3.5 development using C# and Visual Studio.NET 2008. Web forms, server controls, data binding, AJAX, ASMX and WCF services and more...

Beat stress - learn Kriya Yoga Meditations A six week online course in our style of Kriya Yoga is available absolutely FREE. Very few websites teach you the ancient art and science of Kriya Yoga in such a systematic and authentic manner.

Database Helper for .NET 2.0

BinaryIntellect DatabaseHelper is an open source data access component that simplifies your job of executing queries and stored procedures. It is developed using new factory classes of ADO.NET 2.0 and allows you to write provider neutral code. This helps you to quickly develop applications supporting different databases (SQL Server, Oracle, Access etc.).

Features

• Source code available in C# as well as VB.NET
• Generic data access for all the four data providers of .NET
• Developed using new Factory classes of ADO.NET 2.0
• Very small amount of code needed from your side
• Flexible and easy in use
• Support for parameterized queries and stored procedures
• Support for error handling
• Support for error logging
• Support for transactions
• Samples included

System Requirements

• .NET Framework 2.0
• Visual Studio 2005 or Visual C# Express or Visual Basic Express
• SQL Server 2000/2005 (express edition sufficient) database to run samples

Installation Instructions

• Download the associated ZIP file
• Unzip to get a Setup.msi file
• Run Setup.msi file and follow the installation instructions
• Open the Visual Stidio projects to see the complete source code

Posted On :	03 Mar 2006
Current Rating :
Rate This Article :	5 - Excellent 4 - Very Good 3 - Good 2 - Average 1 - Poor

About the Author

Bipin Joshi Bipin Joshi is the proprietor of BinaryIntellect Consulting where he conducts premier training programs on .NET technologies. He wears many hats including software consultant, mentor, prolific author, webmaster, Microsoft MVP and member of ASPInsiders. Having adopted Yoga way of life Bipin also teaches Kriya Yoga to the interested individuals. His detailed profile can be read at his blog. He can also be reached there.

Comments

DatabaseHelper Thank you for creating the Database Helper. It is a wonderful replacement for Microsoft's DAAB 2.0. The source code is really handy and I've made some changes to it to suit my needs. Posted By : Gilligan Joy Posted On : 3/14/2007

Database Helper for .NET 2.0 I have been using your DatabaseHelper for months and I love it. Thanks for your great work. Posted By : Murry Gammash Posted On : 5/10/2007

Visual Web Developer 2005 Express Edition Will this component work in VWD? Thanks Posted By : Rachid Posted On : 6/25/2007

Re: Visual Web Developer 2005 Express Edition You can consume the binary (dll) version in VWD. However, since VWD doesn't support creation of class libraries you can not open the project file in VWD. Posted By : Bipin Joshi Posted On : 6/26/2007

Database Helper Hi Bipin, Thanks for your class Database Helper, currently we are using it from one of our major project, however I do have some concern regarding RETURN VALUES from SP (Parameter Output), I'm having some problem adding this functionality, can you extend your help here? Thanks Posted By : Wiz Posted On : 7/10/2007

Re: Database Helper If you see the code, it clears the Parameters collection after each call to EecuteXXXX methods. Instead of clearing it there you can have an explicit method to clear it. So, by default when you call a method it will clear the parameters. Just pass an extra flag indicating if you wish to preserve it. Posted By : Bipin Joshi Posted On : 7/11/2007

Excellent. I tried this, it is good, but i am using microsft application block, how it is different from that. Raj Posted By : raj Posted On : 8/2/2007

BinaryIntellect.DataAccess.dll in VB.Net Is it possible to have a version of this dll assembly based on VB.net? I have converted your C# code to VB.Net used in the articles on creating a helpdesk for customers which appeared in ASPnetPro magazine. Now I am having problems with this project. I am using VWD Express Edition 2005 and ASP.Net 2.0. Posted By : Rachid Posted On : 10/12/2007

great! thanks Posted By : hwa Posted On : 11/6/2007

Source code Hi, ran msi and would like to know where source code is installed? Posted By : dar Posted On : 11/20/2007

Re: Source code When you installed you must have given some installation path. Just check that folder. Additionally the setup adds some entries in Start Menu through which you can see the code and open the sample projects. Posted By : Bipin Joshi Posted On : 11/20/2007

Thanks Joshi You Deserve More Thank You very much for providing BinaryIntellect Consulting. Its just awsome. Posted By : Rajesh Posted On : 1/9/2008

Thanks Your application is very helpful for me.Really very very thanks. Posted By : Anubhava Dimri Posted On : 1/11/2008

3.5 ? Thank you for the excellent resource. Will this work in asp.net 3.5 or will a 3.5 version be available anytime? -Jason Posted By : Jason Posted On : 1/15/2008

Re: 3.5 ? It works fine in 3.5 also. I am using it in my 2.0 as well as 3.5 projects. Posted By : Shiva Posted On : 1/15/2008

converting it to 3.5 Ok thanks shiva good to know. However when i tried to load the project file in visual basic express it tried to convert it and got errors. It seems to let me load and use the file though. Also, when i click on the project file properties and select 'references' i notice that all references are pointing to .NET 2.0 dll's. Do i need to manually change these? Do i even need to change these or will it still work for 3.5 web apps. Just curious. Thanks. Posted By : Jason Posted On : 1/16/2008

3.5 and the VB version The C# version seems to convert and compile ok in C# developer express 2008, however the vb version does not convert or compile ok in VB express 2008. Any suggestions? I was going to post these in the discussion forum but i cannot find the discussion form. Was it moved? :) Jason Posted By : Jason Posted On : 1/16/2008

Re: 3.5 and the VB version What error you get? I am using C# version. One simple thing that you can try is create a new project in VB and copy paste the source code in it. Posted By : Shiva Posted On : 1/19/2008

DatabaseHelper Thank you for creating the Database Helper. I was looking for something like this and your code helped me lot. Thank you. Posted By : Kusuma Posted On : 2/13/2008

Very Gud Thank you for the Database Helper.. I liked it very much Posted By : john rajesh Posted On : 4/7/2008

executeDataSet - returning mulitple tabes Do you have any suggestion on how to use ExecuteDataSet to return a dataset w/ multiple tables? For SQLServer, may be passing a store procedure. How would this work for MSAccess db? Posted By : ng Posted On : 4/10/2008

auto number field in Access - add new record Im trying to come up with a way to use the ExecuteNonQuery(sqlstring) to pass in an insert stmnt to add a new record to a table in access with primary key is an auto number. I need this id of the newly added record when ExecuteNonQuery is executed. Any suggestion? Posted By : NG Posted On : 4/10/2008

SET @LOGINID = SCOPE_IDENTITY() Thank ou for creating the Database Helper. I need recover output @LOGINID INT OUTPUT, but in DatabaseHelper I don´t. Fabio Posted By : Fabio Galante Mans Posted On : 4/24/2008

Database Helper for .NET 2.0 Thank you for the Database Helper.It's Helpful to me Posted By : shailesh Posted On : 6/2/2008