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

The full object name (e.g. Schema.ViewName)
System.String qb

The database specific quotation start (e.g. '[' for Sql Server)
System.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
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
Type Description
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
Type Description
System.String

QuotatedFullName

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

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

QuotatedObjectName

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

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

QuotatedSchemaName

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

Declaration
public string QuotatedSchemaName { get; }
Property Value
Type Description
System.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
System.String

UnquotatedObjectName

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

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

UnquotatedSchemaName

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

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