SqlServerProviderFactory Class

In This Topic

Represents a factory required to create inheritors of generic base classes to use with dotConnect for SQL Server.

Syntax

Visual Basic
C#

'Declaration
 
Public Class SqlServerProviderFactory 
   Inherits System.Data.Common.DbProviderFactory

public class SqlServerProviderFactory : System.Data.Common.DbProviderFactory

Remarks

You can use SqlServerProviderFactory class to implement code where user chooses which DBMS to use.

To obtain an instance of the class you can use the DbProviderFactories.GetFactory method with the invariant name Devart.Data.SqlServer.

Example

This sample routine creates and returns Devart.Common.DbConnection object.

csharp

public DbConnection GetConnectionBaseClass2(DbProviderFactory factory)
{
// if our factory supports creating a DbConnection, return it.
if ((factory.SupportedClasses & DbProviderSupportedClasses.DbConnection) > 0)
  return factory.CreateConnection();
else
  return null;
}

Visual Basic

Public Function GetConnectionBaseClass2(ByVal factory As DbProviderFactory) As DbConnection
  'if our factory supports creating a DbConnection, return it.
  If ((factory.SupportedClasses And DbProviderSupportedClasses.DbConnection) > 0) Then
    Return factory.CreateConnection()
  Else
    Return Nothing
  End If
End Function

Inheritance Hierarchy

System.Object
System.Data.Common.DbProviderFactory
Devart.Data.SqlServer.SqlServerProviderFactory

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlServerProviderFactory Members
Devart.Data.SqlServer Namespace

Send Feedback