SqlConnectionStringHelper

Namespace: Chimayo.Ssis.Ast.ControlFlowApi

API to support building common SQL Server connection string values and expressions

Nested types and modules

TypeDescription
SqlConnectionString

Helper type representing the individual components of a SQL Server connection string

Functions and values

Function or valueDescription
createAdoNetConnectionStringExpression (...)
Signature: svr:'d -> dbName:'e -> upOption:(string * string) option -> appName:'f -> string
Type parameters: 'd, 'e, 'f

Create an expression that can be used to specify an ADO.NET connection string. The server, database and application name values can be supplied as string values or as CfVariableRef values, in which case the variable value is injected.

createInlineAdoNetConnectionString (...)
Signature: svr:string -> dbName:string -> upOption:(string * string) option -> appName:string -> string

Create an ADO.NET connection string

createInlineOleDbConnectionString (...)
Signature: svr:string -> dbName:string -> upOption:(string * string) option -> appName:string -> string

Create an OLE DB connection string

createOleDbConnectionStringExpression (...)
Signature: svr:'d -> dbName:'e -> upOption:(string * string) option -> appName:'f -> string
Type parameters: 'd, 'e, 'f

Create an expression that can be used to specify an OLE DB connection string. The server, database and application name values can be supplied as string values or as CfVariableRef values, in which case the variable value is injected.

empty
Signature: SqlConnectionString

An empty SqlConnectionString value

setAppName appName scs
Signature: appName:string -> scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by changing the application name

setDatabase dbName scs
Signature: dbName:string -> scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by changing the database name

setProviderToSqlNativeClient11 scs
Signature: scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by setting the provider to the OLE DB SQL Server 2012 Native Client provider

setServer svr scs
Signature: svr:string -> scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by changing the server name

toAdoConnectionString
Signature: SqlConnectionString -> string

Produce an ADO compatible connection string

toAdoNetConnectionString
Signature: SqlConnectionString -> string

Produce an ADO.NET compatible connection string

toOleDbConnectionString
Signature: SqlConnectionString -> string

Produce an OLE DB compatible connection string

useIntegratedSecurity scs
Signature: scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by enabling integrated security

useUsernamePasswordSecurity (...)
Signature: uname:string -> pwd:string -> scs:SqlConnectionString -> SqlConnectionString

Transform a SqlConnectionString by embedding username/password credentials