OracleSpecificCreator Class |
Namespace: SD.LLBLGen.Pro.DQE.Oracle
The OracleSpecificCreator type exposes the following members.
Name | Description | |
---|---|---|
OracleSpecificCreator |
CTor
|
Name | Description | |
---|---|---|
AliasScopes |
Gets the alias scopes.
(Inherited from DbSpecificCreatorBase.) | |
CreatingSubQuery |
Gets a value indicating whether the creator initiated a subquery creation. The DQE can then decide to limit the SQL emitting as some databases
limit features for subqueries.
(Inherited from DbSpecificCreatorBase.) | |
FactoryToUse |
Gets the DbProviderFactory instance to use.
(Overrides DbSpecificCreatorBaseFactoryToUse.) | |
ParameterPrefix |
Gets the parameter prefix, if required. If no parameter prefix is required, this property will return the empty string (by default it returns the empty string).
(Overrides DbSpecificCreatorBaseParameterPrefix.) | |
PerCallCatalogNameOverwrites |
Gets / sets perCallCatalogNameOverwrites name pairs
(Inherited from DbSpecificCreatorBase.) | |
PerCallSchemaNameOverwrites |
Gets / sets perCallSchemaNameOverwrites name pairs
(Inherited from DbSpecificCreatorBase.) | |
SetTimeoutOnCommandCreate |
Gets a value indicating whether the timeout has to be set on command create.
(Inherited from DbSpecificCreatorBase.) |
Name | Description | |
---|---|---|
AddParameterToScopeTracker |
Adds the parameter to scope tracker.
(Inherited from DbSpecificCreatorBase.) | |
AppendJoinSideToJoinFragments |
Appends the elements as a join side to the fragments passed in in the default format: ElementName temporalPredicate alias tableHint. If an element
is specified as empty/null, the element is skipped and no trailing space is emitted.
(Inherited from DbSpecificCreatorBase.) | |
AppendValidIdentifier |
Routine which creates a valid identifier string for the plain identifier string passed in and appends the fragments to the queryfragments specified.
For example, the identifier will be surrounded by "[]" on sqlserver. If the specified rawIdentifier needs wrapping with e.g. [], the [ and ] characters are
added as separate fragments to toAppendTo so no string concatenation has to take place. Use this method over CreateValidAlias if possible.
(Overrides DbSpecificCreatorBaseAppendValidIdentifier(QueryFragments, String).) | |
ClampNameToLengthLimit |
Method which clamps the passed in string to F__hashcode of toClamp if the length of toClamp is too long and
this creator's useRestrictedLengthOnAliasesOfFields is set to true in the ctor (which is the case in DB2 and Oracle)
(Inherited from DbSpecificCreatorBase.) | |
ConstructCallToAggregateWithFieldAsParameter |
Constructs a call to the aggregate function specified with the field name specified as parameter.
(Overrides DbSpecificCreatorBaseConstructCallToAggregateWithFieldAsParameter(AggregateFunction, String).) | |
ConvertComparisonOperator |
Converts the passed in comparison operator to a string usable in a query.
(Inherited from DbSpecificCreatorBase.) | |
ConvertExpressionOperator |
Converts the passed in expression operator (exop) to a string usable in a query
(Inherited from DbSpecificCreatorBase.) | |
ConvertExpressionToQueryFragment |
Converts the expression to a query fragment and adds the parameters created during this process to the passed in parametercollection
(Inherited from DbSpecificCreatorBase.) | |
ConvertFieldToRawName |
Converts the name of the field to the plain base name to use further in the CreateFieldName routine. This routine
makes sure expressions and function calls are taken into account. Used as the start call from CreateFieldName.
(Inherited from DbSpecificCreatorBase.) | |
ConvertParameterOutputValueToRealValueT(DbParameter) |
Converts the parameter output value (contained in the parameter specified) to a real value. This is necessary for example if the value
of the parameter is a value of a type native to an ADO.NET provider, like OracleDecimal.
(Overrides DbSpecificCreatorBaseConvertParameterOutputValueToRealValueT(DbParameter).) | |
ConvertParameterOutputValueToRealValueT(DbParameter) |
Converts the parameter output value (contained in the parameter specified) to a real value. This is necessary for example if the value
of the parameter is a value of a type native to an ADO.NET provider, like OracleDecimal.
(Inherited from DbSpecificCreatorBase.) | |
ConvertSetOperator |
Converts the passed in set operator to a string usable in a query
(Inherited from DbSpecificCreatorBase.) | |
ConvertSortOperator |
Converts the passed in sort operator to a string usable in a query
(Inherited from DbSpecificCreatorBase.) | |
CreateCommand |
Creates a new command.
(Inherited from DbSpecificCreatorBase.) | |
CreateCommand(DbConnection) |
Creates a new command.
(Overrides DbSpecificCreatorBaseCreateCommand(DbConnection).) | |
CreateCommand(DbConnection) |
Creates a new command instance
(Inherited from DbSpecificCreatorBase.) | |
CreateDynamicQueryEngine |
Creates a new dynamic query engine instance
(Overrides DbSpecificCreatorBaseCreateDynamicQueryEngine.) | |
CreateFieldName(IEntityFieldCore, IFieldPersistenceInfo, String, String, Boolean) |
Creates the name for the field, and takes into account an aggregate function present and an expression present. If one or both are present, the
field is replaced with (expression) or surrounded with (aggregate) the function (if applyAggregateFunction is true).
(Inherited from DbSpecificCreatorBase.) | |
CreateFieldName(IFieldPersistenceInfo, String, String, String, String) |
Creates a valid field name based on the passed in IFieldPersistenceInfo implementation. The fieldname is
ready to use in queries and contains all pre/postfix characters required. This field name is
not padded with an alias if that alias should be created. Effectively, this is the
same as CreateFieldName(field persistence info, fieldname, false);
(Inherited from DbSpecificCreatorBase.) | |
CreateFieldName(IFieldPersistenceInfo, String, String, Boolean, String, String) |
Creats a valid field name based on the passed in IFieldPersistenceInfo implementation. The fieldname is
ready to use in queries and contains all pre/postfix characters required.
(Inherited from DbSpecificCreatorBase.) | |
CreateFieldNameSimple(IFieldPersistenceInfo, String) |
Creates a valid field name based on the passed in IFieldPersistenceInfo implementation. The fieldname is
ready to use in queries and contains all pre/postfix characters required. This field name is
not padded with an alias if that alias should be created. Effectively, this is the
same as CreateFieldNameSimple(field persistence info, fieldname, false);. The fieldname is 'simple' in that
it doesn't contain any catalog, schema or table references.
(Inherited from DbSpecificCreatorBase.) | |
CreateFieldNameSimple(IFieldPersistenceInfo, String, Boolean) |
Creats a valid field name based on the passed in IFieldPersistenceInfo implementation. The fieldname is
ready to use in queries and contains all pre/postfix characters required. The fieldname is 'simple' in that
it doesn't contain any catalog, schema or table references.
(Inherited from DbSpecificCreatorBase.) | |
CreateHintStatement | Obsolete.
Creates the hint statement for the hint passed in.
(Inherited from DbSpecificCreatorBase.) | |
CreateLikeParameter |
Creates a valid Parameter for the pattern in a LIKE statement. This is a special case, because it shouldn't rely on the type of the
field the LIKE statement is used with but should be the unicode varchar type.
(Overrides DbSpecificCreatorBaseCreateLikeParameter(String, String).) | |
CreateNewAliasScope |
Creates a new alias scope and makes it active.
(Inherited from DbSpecificCreatorBase.) | |
CreateObjectName(IFieldPersistenceInfo) |
Creates a valid object name (f.e. a name for a table or view) based on the passed in IFieldPersistenceInfo implementation. The fieldname is
ready to use in queries and contains all pre/postfix characters required.
(Inherited from DbSpecificCreatorBase.) | |
CreateObjectName(String, String, String) |
Creates a valid object name (e.g. a name for a table or view) based on the fragments specified. The name is ready to use and contains
all alias wrappings required.
(Overrides DbSpecificCreatorBaseCreateObjectName(String, String, String).) | |
CreateParameter(ParameterDirection, Object) |
Creates a parameter based on the direction passed in and the value passed in.
(Inherited from DbSpecificCreatorBase.) | |
CreateParameter(ParameterDirection, Object, String) |
Creates a parameter based on the direction passed in and the value passed in.
(Inherited from DbSpecificCreatorBase.) | |
CreateParameter(IEntityFieldCore, IFieldPersistenceInfo, ParameterDirection) |
Creates a valid Parameter based on the passed in IEntityFieldCore implementation and the passed in IFieldPersistenceInfo instance
(Inherited from DbSpecificCreatorBase.) | |
CreateParameter(IEntityFieldCore, IFieldPersistenceInfo, ParameterDirection, Object) |
Creates a valid Parameter based on the passed in IEntityFieldCore implementation and the passed in IFieldPersistenceInfo instance
(Inherited from DbSpecificCreatorBase.) | |
CreateParameter(String, Int32, ParameterDirection, Boolean, Byte, Byte, Object) |
Creates a new, filled parameter.
(Overrides DbSpecificCreatorBaseCreateParameter(String, Int32, ParameterDirection, Boolean, Byte, Byte, Object).) | |
CreateParameterInstance(String) |
Creates a new parameter instance.
(Inherited from DbSpecificCreatorBase.) | |
CreateParameterInstance(Object, String) |
Creates a new parameter instance. It sets the value but doesn't set the type so the parameter type depends on the value.
(Inherited from DbSpecificCreatorBase.) | |
CreateParameterInstance(String, Object) |
Creates a new parameter instance (with direction: input)
(Inherited from DbSpecificCreatorBase.) | |
CreateParameterInstance(String, ParameterDirection, Object) |
Creates a new parameter instance.
(Inherited from DbSpecificCreatorBase.) | |
CreateParameterName |
Creates a name usable for a Parameter, based on "p" and a unique marker, prefixed with the parameter prefix for this DQE available in ParameterPrefix.
(Inherited from DbSpecificCreatorBase.) | |
CreatePlainSQLParameterName(Int32) |
Creates the name of a parameter based on the values specified, using the pattern: prefix + "p" + parameterNo. For plain sql queries.
(Inherited from DbSpecificCreatorBase.) | |
CreatePlainSQLParameterName(String) |
Creates the name of a parameter based on the values specified, using the pattern: prefix + nameWithoutPrefix. For plain sql queries.
(Inherited from DbSpecificCreatorBase.) | |
CreateSubQuery |
Creates a new Select Query which is ready to use as a subquery, based on the parameters specified
(Inherited from DbSpecificCreatorBase.) | |
CreateTemporalTablePredicate |
Creates the temporal table predicate fragment for the predicateType specified
(Inherited from DbSpecificCreatorBase.) | |
CreateTvfCallQuery |
Creates a retrieval query from the tvfcall specified. The query will be a 'SELECT ... FROM functioncall' query.
(Inherited from DbSpecificCreatorBase.) | |
CreateValidAlias |
Routine which creates a valid alias string for the raw alias passed in. For example, the alias will be surrounded by "[]" on sqlserver.
Used by the RelationCollection to produce a valid alias for joins.
(Overrides DbSpecificCreatorBaseCreateValidAlias(String).) | |
DestroyCurrentAliasScope |
Destroys the current alias scope and makes the previous one active, if any.
(Inherited from DbSpecificCreatorBase.) | |
DetermineDbTypeNameForValue |
Determines the db type name for value.
(Overrides DbSpecificCreatorBaseDetermineDbTypeNameForValue(Object, Object).) | |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
FindRealAlias(String, String, String) |
Finds the real alias for the entity + objectalias combination. A real alias is necessary as an entity mapped onto multiple tables (through inheritance)
is aliased with a single object alias but each target has to have a different real alias. Checks all scopes.
(Inherited from DbSpecificCreatorBase.) | |
FindRealAlias(String, String, String, Boolean) |
Finds the real alias for the entity + objectalias combination. A real alias is necessary as an entity mapped onto multiple tables (through inheritance)
is aliased with a single object alias but each target has to have a different real alias.
(Inherited from DbSpecificCreatorBase.) | |
GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
GetNewPerCallCatalogName(String) |
Gets the new catalog name from the per-call hashtable name overwrites set into this object. If no per call name pairs are defined or the
name passed in isn't found, the same name passed in is returned. Wraps the returned value in identifier wrapping chars (e.g. []) if needed.
If this is unneeded, call the overload which accepts a flag for this.
(Inherited from DbSpecificCreatorBase.) | |
GetNewPerCallCatalogName(String, Boolean) |
Gets the new catalog name from the per-call hashtable name overwrites set into this object. If no per call name pairs are defined or the
name passed in isn't found, the same name passed in is returned
(Inherited from DbSpecificCreatorBase.) | |
GetNewPerCallSchemaName(String) |
Gets the new schema name from the per-call hashtable name overwrites set into this object. If no per call name pairs are defined or the
name passed in isn't found, the same name passed in is returned. Wraps the returned value in identifier wrapping chars (e.g. []) if needed.
If this is unneeded, call the overload which accepts a flag for this.
(Inherited from DbSpecificCreatorBase.) | |
GetNewPerCallSchemaName(String, Boolean) |
Gets the new schema name from the per-call hashtable name overwrites set into this object. If no per call name pairs are defined or the
name passed in isn't found, the same name passed in is returned
(Inherited from DbSpecificCreatorBase.) | |
GetRealValue(Object, TypeConverter, Type) |
Gets the real value, by converting the passed in value, if necessary
(Inherited from DbSpecificCreatorBase.) | |
GetRealValue(Object, TypeConverter, Type, Boolean) |
Gets the real value, by converting the passed in value, if necessary
(Inherited from DbSpecificCreatorBase.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
GetUnionOperatorString |
Converts the specified operator to a string
(Inherited from DbSpecificCreatorBase.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
ProduceFromClauseDirectiveFragments |
Produces the from clause directive fragments from the specified fromClauseElementDirectives.
(Inherited from DbSpecificCreatorBase.) | |
SetCreatorInDQE |
Sets this instance as the creator in the DQE.
Used in subquery creations, to pass on the creator to a DQE.
(Inherited from DbSpecificCreatorBase.) | |
SetDbProviderFactoryParameterData(ListValuePairString, String, String) |
Sets the db provider factory parameter data. This will influence which DbProviderFactory is used and which enum types the field persistence info
field type names are resolved to.
| |
SetDbProviderFactoryParameterData(String, String, String) |
Sets the db provider factory parameter data. This will influence which DbProviderFactory is used and which enum types the field persistence info
field type names are resolved to.
| |
SetParameterSize |
Sets the size property in the parameter. This is done in this method as some ADO.NET providers have restrictions on which parameters should have the size property set.
(Inherited from DbSpecificCreatorBase.) | |
SetParameterType |
Sets the ADO.NET provider specific Enum type of the parameter, using the string presentation specified.
(Overrides DbSpecificCreatorBaseSetParameterType(DbParameter, String).) | |
StripObjectNameChars |
Strips the object name chars from the name passed in. For example [name] will become name
(Overrides DbSpecificCreatorBaseStripObjectNameChars(String).) | |
ToString | Returns a string that represents the current object. (Inherited from Object.) | |
ToUpperFunctionName |
Returns the SQL functionname to make a string uppercase.
(Inherited from DbSpecificCreatorBase.) |