Solved

Database Helper Class Required

Posted on 2010-08-27
13
2,383 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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 250 total points
ID: 33544401
0
 
LVL 16

Assisted Solution

by:SriVaddadi
SriVaddadi earned 250 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

839 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