Get the list of ADO.NET data providers registered in the machine and application configuration file : Data Provider « ADO.Net « C# / CSharp Tutorial

C# / CSharp Tutorial
1. Language Basics
2. Data Type
3. Operator
4. Statement
5. String
6. struct
7. Class
8. Operator Overload
9. delegate
10. Attribute
11. Data Structure
12. Assembly
13. Date Time
14. Development
15. File Directory Stream
16. Preprocessing Directives
17. Regular Expression
18. Generic
19. Reflection
20. Thread
21. I18N Internationalization
22. GUI Windows Forms
23. 2D
24. Design Patterns
25. Windows
26. XML
27. ADO.Net
28. Network
29. Directory Services
30. Security
31. unsafe
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
C# / C Sharp
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
PHP
Python
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
C# / CSharp Tutorial » ADO.Net » Data Provider 
27. 28. 1. Get the list of ADO.NET data providers registered in the machine and application configuration file
using System;
using System.Data;
using System.Data.Common;

class MainClass
{
    public static void Main(string[] args)
    {
        using (DataTable providers = DbProviderFactories.GetFactoryClasses())
        {
            Console.WriteLine("Available ADO.NET Data Providers:");
            foreach (DataRow prov in providers.Rows)
            {
                Console.WriteLine("Name:{0}", prov["Name"]);
                Console.WriteLine("Description:{0}", prov["Description"]);
                Console.WriteLine("Invariant Name:{0}", prov["InvariantName"]);
            }
        }

    }
}
Available ADO.NET Data Providers:
Name:Odbc Data Provider
Description:.Net Framework Data Provider for Odbc
Invariant Name:System.Data.Odbc
Name:OleDb Data Provider
Description:.Net Framework Data Provider for OleDb
Invariant Name:System.Data.OleDb
Name:OracleClient Data Provider
Description:.Net Framework Data Provider for Oracle
Invariant Name:System.Data.OracleClient
Name:SqlClient Data Provider
Description:.Net Framework Data Provider for SqlServer
Invariant Name:System.Data.SqlClient
27. 28. Data Provider
27. 28. 1. Get the list of ADO.NET data providers registered in the machine and application configuration file
ww___w.__j___a___va__2___s_.co_m | Contact Us
Copyright 2003 - 08 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.