Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Database Helper Class Required

Posted on 2010-08-27
13
Medium Priority
?
2,503 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 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