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

object

ObjectNameDescriptor

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public sealed class ObjectNameDescriptor ``` {{< rawhtml >}}

Constructors

ObjectNameDescriptor(string, string)

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor(string qb, string qe) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	qb
string	qe

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

{{< /rawhtml >}} ```C# public ObjectNameDescriptor(string objectName, string qb, string qe) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	objectName	The full object name (e.g. Schema.ViewName)
string	qb	The database specific quotation start (e.g. '[' for Sql Server)
string	qe	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

{{< /rawhtml >}} ```C# public string ObjectName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QB

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

Declaration

{{< /rawhtml >}} ```C# public string QB { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QE

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

Declaration

{{< /rawhtml >}} ```C# public string QE { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QuotatedDbName

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

Declaration

{{< /rawhtml >}} ```C# public string QuotatedDbName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QuotatedFullName

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

Declaration

{{< /rawhtml >}} ```C# public string QuotatedFullName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QuotatedObjectName

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

Declaration

{{< /rawhtml >}} ```C# public string QuotatedObjectName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

QuotatedSchemaName

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

Declaration

{{< /rawhtml >}} ```C# public string QuotatedSchemaName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

UnquotatedDbName

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

Declaration

{{< /rawhtml >}} ```C# public string UnquotatedDbName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

UnquotatedFullName

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

Declaration

{{< /rawhtml >}} ```C# public string UnquotatedFullName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

UnquotatedObjectName

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

Declaration

{{< /rawhtml >}} ```C# public string UnquotatedObjectName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

UnquotatedSchemaName

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

Declaration

{{< /rawhtml >}} ```C# public string UnquotatedSchemaName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Methods

ParseFromObjectName(string)

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor ParseFromObjectName(string objectName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	objectName

Returns

Type	Description
ObjectNameDescriptor

SetObjectName(string)

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor SetObjectName(string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	tableName

Returns

Type	Description
ObjectNameDescriptor

SetSchemaName(string)

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor SetSchemaName(string schemaName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	schemaName

Returns

Type	Description
ObjectNameDescriptor