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
Inherited Members
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
public sealed class ObjectNameDescriptor
Constructors
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
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
public string ObjectName { get; }
Property Value
Type | Description |
---|---|
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
Type | Description |
---|---|
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
Type | Description |
---|---|
string |
QuotatedFullName
The whole name with quotes. E.g. schema.ViewName would create "schema"."ViewName"
Declaration
public string QuotatedFullName { get; }
Property Value
Type | Description |
---|---|
string |
QuotatedObjectName
The object name with quotes. E.g. schema.ViewName would create "ViewName"
Declaration
public string QuotatedObjectName { get; }
Property Value
Type | Description |
---|---|
string |
QuotatedSchemaName
The schema name with quotes. E.g. "schema"."ViewName" would create "schema"
Declaration
public string QuotatedSchemaName { get; }
Property Value
Type | Description |
---|---|
string |
UnquotatedFullName
The whole name without any quotation E.g. "schema"."ViewName" would create schema.ViewName
Declaration
public string UnquotatedFullName { get; }
Property Value
Type | Description |
---|---|
string |
UnquotatedObjectName
The object name without any quoting. E.g. "schema"."ViewName" would create ViewName
Declaration
public string UnquotatedObjectName { get; }
Property Value
Type | Description |
---|---|
string |
UnquotatedSchemaName
The schema name without any quoting. E.g. "schema"."ViewName" would create schema
Declaration
public string UnquotatedSchemaName { get; }
Property Value
Type | Description |
---|---|
string |