I need learn what kind of database technologies/connections can be made via MSSQL Server in C#?

Posted on 2011-10-05
Medium Priority
Last Modified: 2012-08-13
Hi there;

I need learn what kind of database technologies/connections can be made via MSSQL Server in C#?

I asked the following question

and the answer covers ADO.NET? What about other technologies in C# for MSSQL?

Kind regards.
Question by:jazzIIIlove
LVL 53

Accepted Solution

Dhaest earned 668 total points
ID: 36916339
I don't think that there are other technologies than ado.net (this is just a layer between your program and the database)
LVL 11

Assisted Solution

by:Kelvin McDaniel
Kelvin McDaniel earned 668 total points
ID: 36916401
Both C# and SQL Server 2008 R2 can connect to the following TYPES of providers:
1. SQL Native Client
2. Oracle

Theoretically, ANY database system that the requesting system has access to (locally or remotely) which implements at least one of these providers can be connected to.

More here at...
SQL Server: http://msdn.microsoft.com/en-us/library/ms188279.aspx
C#/ADO.NET: http://msdn.microsoft.com/en-us/library/ms254500.aspx

I think you're looking for a definitive list, however. I'm not sure there is a recent "complete" one... but here's an older one I located: http://web.archive.org/web/20050224020748/http://www.able-consulting.com/ADO_Conn.htm

Assisted Solution

luani earned 664 total points
ID: 36916553

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

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