?
Solved

Database Helper Class Required

Posted on 2010-08-27
13
Medium Priority
?
2,469 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: 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!

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

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