none
List of provider names RRS feed

  • Question

  • Hello,

    I'm looking for an extensive and updated list of names of ADO.Net providers. Can anybody please give me a link?

    Thanks.

     

    Sunday, November 14, 2010 6:23 AM

Answers


  • See if the following helps:

    Imports System
    Imports System.Data
    Imports System.Data.Common
    
    Friend Class MainClass
    	Public Shared Sub Main(ByVal args() As String)
    		Using providers As DataTable = DbProviderFactories.GetFactoryClasses()
    			Console.WriteLine("Available ADO.NET Data Providers:")
    			For Each prov As DataRow In providers.Rows
    				Console.WriteLine("Name:{0}", prov("Name"))
    				Console.WriteLine("Description:{0}", prov("Description"))
    				Console.WriteLine("Invariant Name:{0}", prov("InvariantName"))
    			Next prov
    		End Using
    
    	End Sub
    End Class
    

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Saturday, November 20, 2010 7:59 AM
    Tuesday, November 16, 2010 10:16 PM

All replies

  • This is the only one that I am aware of, but it might be missing a few (e.g ODP.NET):

    http://www.sqlsummit.com/DataProv.htm

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, November 16, 2010 3:10 PM
  • Thanks, but actually what I meant is a list of the names as they are registered and known in the system, i.e the providers' unique names that identify them.

     

    Tuesday, November 16, 2010 9:01 PM

  • See if the following helps:

    Imports System
    Imports System.Data
    Imports System.Data.Common
    
    Friend Class MainClass
    	Public Shared Sub Main(ByVal args() As String)
    		Using providers As DataTable = DbProviderFactories.GetFactoryClasses()
    			Console.WriteLine("Available ADO.NET Data Providers:")
    			For Each prov As DataRow In providers.Rows
    				Console.WriteLine("Name:{0}", prov("Name"))
    				Console.WriteLine("Description:{0}", prov("Description"))
    				Console.WriteLine("Invariant Name:{0}", prov("InvariantName"))
    			Next prov
    		End Using
    
    	End Sub
    End Class
    

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Saturday, November 20, 2010 7:59 AM
    Tuesday, November 16, 2010 10:16 PM
  • Thanks, I actually know the GetFactoryClasses function, but it only shows the providers that are registered with the system the application is running on , whereas I want a list of the existing providers in the market.

     

    Wednesday, November 17, 2010 8:38 AM
  • I don't know that any such resource exists.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, November 17, 2010 1:19 PM