Database Helper Class Required

http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-database-as-a-data-source-HA010100908.aspx

hope this help

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

there is this example here if it helps any http://www.eggheadcafe.com/tutorials/aspnet/b3f8033a-ccfa-4e0b-a715-9a89c4e570e2/sql-helper-class-in-c.aspx

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

You can use Microsoft Enterprise Library.

Thanks every one.
Will check the options and revert

Thanks a lot for the suggestions.
I opted for Microsoft Library.

oh so u just needed a link? Bad of me for mentioning it but not posting a link lol.

@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.

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.

Sorry for not giving you point.
Will take care next time buddy