ObjectNameDescriptor

Class ObjectNameDescriptor

Applies database specific formatting to an object names. E.g. schema.ViewName would create [schema].[ViewName] for SqlServer and "schema"."ViewName" for Postgres

Inheritance
ObjectNameDescriptor
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public sealed class ObjectNameDescriptor

Constructors

ObjectNameDescriptor(string, string)

Declaration
    public ObjectNameDescriptor(string qb, string qe)
Parameters
TypeNameDescription
stringqb
stringqe

ObjectNameDescriptor(string, string, string)

Creates a new instance and already parses the values. Right after initialization you can access the values in the properties.

Declaration
    public ObjectNameDescriptor(string objectName, string qb, string qe)
Parameters
TypeNameDescription
stringobjectName

The full object name (e.g. Schema.ViewName)

stringqb

The database specific quotation start (e.g. '[' for Sql Server)

stringqe

The database specific quotation start (e.g. ']' for Sql Server)

Properties

ObjectName

The name of the object that needs to have database spcific formatting applied

Declaration
    public string ObjectName { get; }
Property Value
TypeDescription
string

QB

The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'

Declaration
    public string QB { get; }
Property Value
TypeDescription
string

QE

The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'

Declaration
    public string QE { get; }
Property Value
TypeDescription
string

QuotatedDbName

The database name with quotes. E.g. "db."schema"."ViewName" would create "db"

Declaration
    public string QuotatedDbName { get; }
Property Value
TypeDescription
string

QuotatedFullName

The whole name with quotes. E.g. schema.ViewName would create "schema"."ViewName"

Declaration
    public string QuotatedFullName { get; }
Property Value
TypeDescription
string

QuotatedObjectName

The object name with quotes. E.g. schema.ViewName would create "ViewName"

Declaration
    public string QuotatedObjectName { get; }
Property Value
TypeDescription
string

QuotatedSchemaName

The schema name with quotes. E.g. "schema"."ViewName" would create "schema"

Declaration
    public string QuotatedSchemaName { get; }
Property Value
TypeDescription
string

UnquotatedDbName

The database name without any quoting. E.g. "db"."schema"."table" would create db

Declaration
    public string UnquotatedDbName { get; }
Property Value
TypeDescription
string

UnquotatedFullName

The whole name without any quotation. E.g. "schema"."ViewName" would create schema.ViewName

Declaration
    public string UnquotatedFullName { get; }
Property Value
TypeDescription
string

UnquotatedObjectName

The object name without any quoting. E.g. "schema"."ViewName" would create ViewName

Declaration
    public string UnquotatedObjectName { get; }
Property Value
TypeDescription
string

UnquotatedSchemaName

The schema name without any quoting. E.g. "schema"."ViewName" would create schema

Declaration
    public string UnquotatedSchemaName { get; }
Property Value
TypeDescription
string

Methods

ParseFromObjectName(string)

Declaration
    public ObjectNameDescriptor ParseFromObjectName(string objectName)
Parameters
TypeNameDescription
stringobjectName
Returns
TypeDescription
ObjectNameDescriptor

SetObjectName(string)

Declaration
    public ObjectNameDescriptor SetObjectName(string tableName)
Parameters
TypeNameDescription
stringtableName
Returns
TypeDescription
ObjectNameDescriptor

SetSchemaName(string)

Declaration
    public ObjectNameDescriptor SetSchemaName(string schemaName)
Parameters
TypeNameDescription
stringschemaName
Returns
TypeDescription
ObjectNameDescriptor