?
Solved

Database Helper Class Required

Posted on 2010-08-27
13
Medium Priority
?
2,530 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
ID: 33544262
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33544312
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
ID: 33544353
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 65

Expert Comment

by:rockiroads
ID: 33544394
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
ID: 33544396
You can use Microsoft Enterprise Library.
0
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 1000 total points
ID: 33544401
0
 
LVL 16

Assisted Solution

by:SriVaddadi
SriVaddadi earned 1000 total points
ID: 33545095
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
ID: 33548263
Thanks every one.
Will check the options and revert
0
 
LVL 19

Author Closing Comment

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

Expert Comment

by:rockiroads
ID: 33552993
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
ID: 33553057
@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
ID: 33553162
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
ID: 33553185
Sorry for not giving you point.
Will take care next time buddy
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month16 days, 20 hours left to enroll

862 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