GetDatabaseEnumeratorQuery Method (ConnectionStringManager.DBTypes, Boolean)

DbDetails GetDatabaseEnumeratorQuery Method (ConnectionStringManager DBTypes, Boolean)

CleanCode C# Libraries v1.2.03 API

Gets a query to enumerate databases (with or without system databases) for the current database type.

Namespace: CleanCode.DatabaseControls.Support
Assembly: CleanCode.DatabaseControls (in CleanCode.DatabaseControls.dll) Version: 1.2.3.0 (1.2.03)

Syntax

C++

Copy to Clipboard Print

public static string GetDatabaseEnumeratorQuery(
	ConnectionStringManager..::..DBTypes dbType,
	bool includeSysDBs
)

public static string GetDatabaseEnumeratorQuery(
	ConnectionStringManager..::..DBTypes dbType,
	bool includeSysDBs
)

Public Shared Function GetDatabaseEnumeratorQuery ( _
	dbType As ConnectionStringManager..::..DBTypes, _
	includeSysDBs As Boolean _
) As String

Public Shared Function GetDatabaseEnumeratorQuery ( _
	dbType As ConnectionStringManager..::..DBTypes, _
	includeSysDBs As Boolean _
) As String

public:
static String^ GetDatabaseEnumeratorQuery(
	ConnectionStringManager..::..DBTypes dbType, 
	bool includeSysDBs
)

public:
static String^ GetDatabaseEnumeratorQuery(
	ConnectionStringManager..::..DBTypes dbType, 
	bool includeSysDBs
)

Parameters

dbType: Type: CleanCode.DatabaseControls ConnectionStringManager DBTypes
The database type.

includeSysDBs: Type: System Boolean
if set to true includes system databases as well.

Return Value

A SQL query in the appropriate dialect; otherwise, null.

Remarks

If a query is defined, then the given database type has the notion of multiple databases for a given server, e.g. SQL Server. A notable one that does not is Oracle.