Solved

Database Helper Class Required

Posted on 2010-08-27
13
2,354 Views
Last Modified: 2012-05-10
I am searching for a database helper class with which i can connect to any type of Database i.e. MS SQL, oracle, My SQL, etc.

Like sqlhelper.cs, i can only connect to MS SQL.

But my requirement is of open source/freeware db helper with which i can perform tasks.
0
Comment
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 4

Expert Comment

by:dschauhan82
Comment Utility
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
Ive used Hibernate before for Java and know of NHibernate though I have never used it. You want to give that a go? http://community.jboss.org/wiki/NHibernateforNET
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
With the sql helper class, maybe put your db configs somewhere in some sort of xml file and read that. Then create the appropriate connections based on the db. There is also a enterprise library data access block from ms and another database helper from c#buddies http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=3
0
 
LVL 8

Expert Comment

by:Mohit Vijay
Comment Utility
You can use Microsoft Enterprise Library.
0
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 250 total points
Comment Utility
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 16

Assisted Solution

by:SriVaddadi
SriVaddadi earned 250 total points
Comment Utility
You could use the classes from Data Access Application block (part of MS Enterprise Library). Here are some quick starts

http://msdn.microsoft.com/en-us/library/ff648274.aspx
0
 
LVL 19

Author Comment

by:Amandeep Singh Bhullar
Comment Utility
Thanks every one.
Will check the options and revert
0
 
LVL 19

Author Closing Comment

by:Amandeep Singh Bhullar
Comment Utility
Thanks a lot for the suggestions.
I opted for Microsoft Library.
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
oh so u just needed a link? Bad of me for mentioning it but not posting a link lol.
0
 
LVL 19

Author Comment

by:Amandeep Singh Bhullar
Comment Utility
@rockiroads
You provided me link for SQLHelper. but i required complete layer will all functionality and that can interact with any type of DB

Thanks for your suggestion. I voted the one that i actually used.
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
in total 3 - link to sql helper and c#buddies as well as mentioning the ms library, same time as vjsoft, and not mentioning the same (but a different link) over an hour later. not a problem though as I just felt like posting a funny comment.
0
 
LVL 19

Author Comment

by:Amandeep Singh Bhullar
Comment Utility
Sorry for not giving you point.
Will take care next time buddy
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now