Class SqlWorkspaceFactoryClass

Namespace
ESRI.ArcGIS.DatasourcesGDB
Assembly
ESRI.Server.DatasourcesGDB.dll
[Guid("5297187B-FD2B-4A5F-8991-EB3F6F1CA502")]
[ClassInterface(ClassInterfaceType.None)]
public class SqlWorkspaceFactoryClass : SqlWorkspaceFactory, IWorkspaceFactory2, IWorkspaceFactory, IRemoteDatabaseWorkspaceFactory, ISupportErrorInfo, ISqlDefaultConnectionInfo
Inheritance
SqlWorkspaceFactoryClass
Implements
Inherited Members

Constructors

SqlWorkspaceFactoryClass()

public SqlWorkspaceFactoryClass()

Explicit Interface Implementations

ClearParameters(string, string, string)

Clears connection property parameters.

virtual void ClearParameters(string dbclient, string instance, string authenticationMode)

Parameters

dbclient string
instance string
authenticationMode string

ContainsWorkspace(string, IFileNames)

Indicates if parentDirectory contains a valid workspace, or is a valid file-system workspace.

virtual bool ContainsWorkspace(string parentDirectory, IFileNames fileNames)

Parameters

parentDirectory string
fileNames IFileNames

Returns

bool

Remarks

ContainsWorkspace is useful when browsing the file system for workspaces. It takes a parent directory and the list of file names in the directory to be examined. It returns true if the parent directory represents a workspace covered by this factory or if the parent directory contains a workspace or a connection file to a workspace covered by this factory.

Copy(IWorkspaceName, string, out IWorkspaceName)

Copies a workspace to the specified destination folder.

virtual bool Copy(IWorkspaceName WorkspaceName, string destinationFolder, out IWorkspaceName workspaceNameCopy)

Parameters

WorkspaceName IWorkspaceName
destinationFolder string
workspaceNameCopy IWorkspaceName

Returns

bool

Remarks

The Copy and Move methods can be used to copy or move workspaces or connection files between folders in the file system. The Boolean result indicates if the operation was successful. In the case of remote database workspaces, these operations work on the connection file representing the workspace.

Create(string, string, IPropertySet, int)

Creates a new workspace specified by the directory, file name, and connection properties.

virtual IWorkspaceName Create(string parentDirectory, string Name, IPropertySet ConnectionProperties, int hWnd)

Parameters

parentDirectory string
Name string
ConnectionProperties IPropertySet
hWnd int

Returns

IWorkspaceName

Remarks

Create has different results depending on the type of workspace factory. If you are working with ArcSDE, a new connection file (.sde) is created. If you are working with an ArcGIS for Desktop Advanced workspace factory, a folder with an INFO subfolder is created. The optional ConnectionProperties parameter specifies any additional connection properties needed, such as the server, instance, user and password in the case where a connection file to a remote database workspace is being created. If no connection properties are specified, this method will result in a dialog being displayed that prompts the user for the required properties.

DeleteConnectionFile(string)

Deletes the remote database workspace connection file.

virtual void DeleteConnectionFile(string PathName)

Parameters

PathName string

EditConnectionFile(string, int)

Edits the properties of a remote database workspace connection file.

virtual IWorkspaceName EditConnectionFile(string PathName, int hWnd)

Parameters

PathName string
hWnd int

Returns

IWorkspaceName

GetClassID()

The class ID of the WorkspaceFactory.

virtual UID GetClassID()

Returns

UID

Remarks

GetClassID returns the unique identifier for the workspace factory. You can use this to distinguish different versions of the same type of factory, for example, whether you are working with an SDEWorkspace, FileGDBWorkspace or AccessWorkspace factory.

GetWorkspaceName(string, IFileNames)

Retrieves the workspace name of a workspace from the given list of file names.

virtual IWorkspaceName GetWorkspaceName(string parentDirectory, IFileNames fileNames)

Parameters

parentDirectory string
fileNames IFileNames

Returns

IWorkspaceName

Remarks

GetWorkspaceName is useful when browsing the file system for workspaces. It is handed in a parent directory and the list of file names in the directory to be examined. It returns a WorkspaceName object representing the first workspace it finds in the list of filenames and removes any filenames representing the workspace from the input list of filenames.

IWorkspaceFactory2_ContainsWorkspace(string, IFileNames)

virtual bool IWorkspaceFactory2_ContainsWorkspace(string parentDirectory, IFileNames fileNames)

Parameters

parentDirectory string
fileNames IFileNames

Returns

bool

IWorkspaceFactory2_Copy(IWorkspaceName, string, out IWorkspaceName)

virtual bool IWorkspaceFactory2_Copy(IWorkspaceName WorkspaceName, string destinationFolder, out IWorkspaceName workspaceNameCopy)

Parameters

WorkspaceName IWorkspaceName
destinationFolder string
workspaceNameCopy IWorkspaceName

Returns

bool

IWorkspaceFactory2_Create(string, string, IPropertySet, int)

virtual IWorkspaceName IWorkspaceFactory2_Create(string parentDirectory, string Name, IPropertySet ConnectionProperties, int hWnd)

Parameters

parentDirectory string
Name string
ConnectionProperties IPropertySet
hWnd int

Returns

IWorkspaceName

IWorkspaceFactory2_GetClassID()

virtual UID IWorkspaceFactory2_GetClassID()

Returns

UID

IWorkspaceFactory2_GetWorkspaceName(string, IFileNames)

virtual IWorkspaceName IWorkspaceFactory2_GetWorkspaceName(string parentDirectory, IFileNames fileNames)

Parameters

parentDirectory string
fileNames IFileNames

Returns

IWorkspaceName

IWorkspaceFactory2_IsWorkspace(string)

virtual bool IWorkspaceFactory2_IsWorkspace(string fileName)

Parameters

fileName string

Returns

bool

IWorkspaceFactory2_Move(IWorkspaceName, string)

virtual bool IWorkspaceFactory2_Move(IWorkspaceName WorkspaceName, string destinationFolder)

Parameters

WorkspaceName IWorkspaceName
destinationFolder string

Returns

bool

IWorkspaceFactory2_Open(IPropertySet, int)

virtual IWorkspace IWorkspaceFactory2_Open(IPropertySet ConnectionProperties, int hWnd)

Parameters

ConnectionProperties IPropertySet
hWnd int

Returns

IWorkspace

IWorkspaceFactory2_OpenFromFile(string, int)

virtual IWorkspace IWorkspaceFactory2_OpenFromFile(string fileName, int hWnd)

Parameters

fileName string
hWnd int

Returns

IWorkspace

IWorkspaceFactory2_ReadConnectionPropertiesFromFile(string)

virtual IPropertySet IWorkspaceFactory2_ReadConnectionPropertiesFromFile(string fileName)

Parameters

fileName string

Returns

IPropertySet

IWorkspaceFactory2_WorkspaceDescription[bool]

virtual string IWorkspaceFactory2_WorkspaceDescription[bool plural] { get; }

Parameters

plural bool

Returns

string

IWorkspaceFactory2_WorkspaceType

virtual esriWorkspaceType IWorkspaceFactory2_WorkspaceType { get; }

Returns

esriWorkspaceType

InterfaceSupportsErrorInfo(ref Guid)

virtual void InterfaceSupportsErrorInfo(ref Guid riid)

Parameters

riid Guid

IsWorkspace(string)

True if the specified file identifies a workspace supported by the workspace factory.

virtual bool IsWorkspace(string fileName)

Parameters

fileName string

Returns

bool

Move(IWorkspaceName, string)

Moves a workspace to the specified destination folder.

virtual bool Move(IWorkspaceName WorkspaceName, string destinationFolder)

Parameters

WorkspaceName IWorkspaceName
destinationFolder string

Returns

bool

Remarks

The Copy and Move methods can be used to copy or move workspaces or connection files between folders in the file system. The Boolean result indicates if the operation was successful. In the case of remote database workspaces, these operations work on the connection file representing the workspace.

Open(IPropertySet, int)

Opens the workspace specified by the connection properties.

virtual IWorkspace Open(IPropertySet ConnectionProperties, int hWnd)

Parameters

ConnectionProperties IPropertySet
hWnd int

Returns

IWorkspace

Remarks

Open takes as input a property set of connection properties that specify the workspace to connect to. In the case of file system workspaces and local database workspaces, a single property named DATABASE, whose value is the pathname to the workspace, is usually all that is required. In the case of remote database workspaces accessed via ArcSDE the properties can include the USER, PASSWORD, DATABASE, SERVER, INSTANCE, VERSION, HISTORICAL_NAME, HISTORICAL_TIMESTAMP, and AUTHENTICATION_MODE properties of the database being connected to.

List of acceptable connection property names and a brief description of each

"SERVER" – SDE server name you are connecting to.

"INSTANCE" – Instance you are connection to.

"DATABASE" – Database connected to.

"USER" – Connected user.

"PASSWORD" – Connected password.

"AUTHENTICATION_MODE" – Credential authentication mode of the connection. Acceptable values are "OSA" and "DBMS".

"VERSION" – Transactional version to connect to. Acceptable value is a string that represents a transaction version name.

"HISTORICAL_NAME" – Historical version to connect to. Acceptable value is a string type that represents a historical marker name.

"HISTORICAL_TIMESTAMP" – Moment in history to establish an historical version connection. Acceptable value is a date time that represents a moment timestamp.

 

Notes:

  • The "DATABASE" property is optional and is required for ArcSDE instances that manage multiple databases (for example, SQL Server).
  • If “AUTHENTICATION_MODE” is “OSA” then “USER” and “PASSWORD” are not required. “OSA” represents operating system authentication and uses the operating system credentials to establish a connection with the database.
  • Since the workspace connection can only represent one version only 1 of the 3 version properties (“VERSION” or “HISTORICAL_NAME” or “HISTORICAL_TIMESTAMP”) should be used.
  • The "VERSION" property is case sensitive and the correct case must be used when entering the version property.

OpenFromFile(string, int)

Opens the workspace specified by the given file name.

virtual IWorkspace OpenFromFile(string fileName, int hWnd)

Parameters

fileName string
hWnd int

Returns

IWorkspace

Remarks

OpenFromFile takes the pathname of a file or directory that represents either a FileSystemWorkspace or LocalDatabaseWorkspace, or a connection file to a RemoteDatabase workspace and returns an interface on the specified workspace. Clients of these methods can then proceed to open and access datasets in the workspace. If these methods are called with insufficient properties, then the user will be presented with a connection dialog that will prompt for the required properties.

The hWnd argument is the parent window or application's window. The hWnd will guarantee that the connection dialog, if presented to you because of insufficient properties, has the correct parent.

OpenFromString(string, int)

Opens the workspace specified by a connection string.

virtual IWorkspace OpenFromString(string connectStr, int hWnd)

Parameters

connectStr string
hWnd int

Returns

IWorkspace

Remarks

The connect string is a collection of name value pairs separated by a semicolon (;).

The "VERSION" property is case sensitive and the correct case must be used when entering the version property.

ReadConnectionPropertiesFromFile(string)

The connection properties from the specified file.

virtual IPropertySet ReadConnectionPropertiesFromFile(string fileName)

Parameters

fileName string

Returns

IPropertySet

Remarks

The filename parameter represents the pathname of a file that contains the connection information to be placed into the IPropertySet variable.

RenameConnectionFile(string, string)

Renames the remote database workspace connection file.

virtual IWorkspaceName RenameConnectionFile(string oldPathName, string newName)

Parameters

oldPathName string
newName string

Returns

IWorkspaceName

Remarks

The oldPathName is the path and connection file name.  the newName is the new file name without a path.  An error is returned if newName has a fully qualified path. 

SetParameters(string, string, string, string, string)

Sets connection property parameters.

virtual void SetParameters(string dbclient, string instance, string authenticationMode, string User, string password)

Parameters

dbclient string
instance string
authenticationMode string
User string
password string

WorkspaceDescription[bool]

A singular or plural description of the type of workspace the workspace factory opens/creates.

virtual string WorkspaceDescription[bool plural] { get; }

Parameters

plural bool

Returns

string

Remarks

The plural parameter is used as a helper that will take and make the workspacefactory plural. e.g. SDE Connection will become SDE Connections.

WorkspaceType

The type of workspace the workspace factory opens/creates.

virtual esriWorkspaceType WorkspaceType { get; }

Returns

esriWorkspaceType

Remarks

The WorkspaceType property of a WorkspaceFactory returns information on the type of workspace managed by the WorkspaceFactory. Workspaces are classified into the following types specified by the esriWorkspaceType enumeration; FileSystemWorkspace, LocalDatabaseWorkspace, and RemoteDatabaseWorkspace.
See esriWorkspaceType for information on the types of workspaces.
Shapefiles workspaces are examples of FileSystemWorkspace. Personal and File Geodatabases are examples of LocalDatabaseWorkspace. An ArcSDE Geodatabase is an example of a RemoteDatabaseWorkspace.