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
System.Object
ObjectNameDescriptor
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.Helper
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
TypeNameDescription
System.StringobjectName

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

System.Stringqb

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

System.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
System.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
System.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
System.String

QuotatedFullName

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

Declaration
    public string QuotatedFullName { get; }
Property Value
TypeDescription
System.String

QuotatedObjectName

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

Declaration
    public string QuotatedObjectName { get; }
Property Value
TypeDescription
System.String

QuotatedSchemaName

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

Declaration
    public string QuotatedSchemaName { get; }
Property Value
TypeDescription
System.String

UnquotatedFullName

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

Declaration
    public string UnquotatedFullName { get; }
Property Value
TypeDescription
System.String

UnquotatedObjectName

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

Declaration
    public string UnquotatedObjectName { get; }
Property Value
TypeDescription
System.String

UnquotatedSchemaName

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

Declaration
    public string UnquotatedSchemaName { get; }
Property Value
TypeDescription
System.String