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


C# Examples » ADO.Net » Data Provider »

 

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"]);
                        }
                }

        }
}
    
   
  
   



Output

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


HTML code for linking to this page:

Follow Navioo On Twitter

C# Examples

 Navioo ADO.Net
» Data Provider