Click or drag to resize
SqlServerSpecificCreator Methods

The SqlServerSpecificCreator type exposes the following members.

Methods
  NameDescription
Protected methodAddParameterToScopeTracker
Adds the parameter to scope tracker.
(Inherited from DbSpecificCreatorBase.)
Public methodClampNameToLengthLimit
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.)
Protected methodConstructCallToAggregateWithFieldAsParameter
Constructs a call to the aggregate function specified with the field name specified as parameter.
(Overrides DbSpecificCreatorBaseConstructCallToAggregateWithFieldAsParameter(AggregateFunction, String).)
Public methodConvertComparisonOperator
Converts the passed in comparison operator to a string usable in a query.
(Inherited from DbSpecificCreatorBase.)
Public methodConvertExpressionOperator
Converts the passed in expression operator (exop) to a string usable in a query
(Inherited from DbSpecificCreatorBase.)
Public methodConvertExpressionToQueryFragment
Converts the expression to a query fragment and adds the parameters created during this process to the passed in parametercollection
(Inherited from DbSpecificCreatorBase.)
Protected methodConvertFieldToRawName
Converts the name of the field to the raw 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.)
Public methodConvertParameterOutputValueToRealValueT
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.)
Public methodConvertSetOperator
Converts the passed in set operator to a string usable in a query
(Inherited from DbSpecificCreatorBase.)
Public methodConvertSortOperator
Converts the passed in sort operator to a string usable in a query
(Inherited from DbSpecificCreatorBase.)
Public methodCreateCommand
Creates a new command.
(Inherited from DbSpecificCreatorBase.)
Public methodCreateCommand(DbConnection)
Creates a new command instance
(Inherited from DbSpecificCreatorBase.)
Protected methodCreateDynamicQueryEngine
Creates a new dynamic query engine instance
(Overrides DbSpecificCreatorBaseCreateDynamicQueryEngine.)
Public methodCreateFieldName(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.)
Public methodCreateFieldName(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.)
Public methodCreateFieldName(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.)
Public methodCreateFieldNameSimple(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.)
Public methodCreateFieldNameSimple(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.)
Public methodCreateHintStatement
Creates the hint statement for the hint passed in.
(Overrides DbSpecificCreatorBaseCreateHintStatement(RdbmsHint, String, Object).)
Public methodCreateLikeParameter
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).)
Protected methodCreateNewAliasScope
Creates a new alias scope and makes it active.
(Inherited from DbSpecificCreatorBase.)
Public methodCreateObjectName(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.)
Public methodCreateObjectName(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).)
Public methodCreateParameter(ParameterDirection, Object)
Creates a parameter based on the direction passed in and the value passed in.
(Inherited from DbSpecificCreatorBase.)
Public methodCreateParameter(IEntityFieldCore, IFieldPersistenceInfo, ParameterDirection)
Creates a valid Parameter based on the passed in IEntityFieldCore implementation and the passed in IFieldPersistenceInfo instance
(Inherited from DbSpecificCreatorBase.)
Public methodCreateParameter(IEntityFieldCore, IFieldPersistenceInfo, ParameterDirection, Object)
Creates a valid Parameter based on the passed in IEntityFieldCore implementation and the passed in IFieldPersistenceInfo instance
(Inherited from DbSpecificCreatorBase.)
Public methodCreateParameter(String, Int32, ParameterDirection, Boolean, Byte, Byte, Object)
Creates a new, filled parameter.
(Overrides DbSpecificCreatorBaseCreateParameter(String, Int32, ParameterDirection, Boolean, Byte, Byte, Object).)
Protected methodCreateParameterInstance(Object)
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.)
Protected methodCreateParameterInstance(String)
Creates a new parameter instance.
(Inherited from DbSpecificCreatorBase.)
Protected methodCreateParameterInstance(String, Object)
Creates a new parameter instance (with direction: input)
(Inherited from DbSpecificCreatorBase.)
Protected methodCreateParameterInstance(String, ParameterDirection, Object)
Creates a new parameter instance.
(Inherited from DbSpecificCreatorBase.)
Protected methodCreateParameterName
Creates a name usable for a Parameter, based on "p" and a unique marker.
(Overrides DbSpecificCreatorBaseCreateParameterName.)
Protected methodCreateParameterName(String)
Creates a name usable for a Parameter, based on "p" and a unique marker, prefxied with the prefix specified
(Inherited from DbSpecificCreatorBase.)
Public methodCreateSubQuery(IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection)
Creates a new Select Query which is ready to use as a subquery, based on the specified select list and the specified set of relations.
(Inherited from DbSpecificCreatorBase.)
Public methodCreateSubQuery(IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection, Boolean)
Creates a new Select Query which is ready to use as a subquery, based on the specified select list and the specified set of relations.
(Overrides DbSpecificCreatorBaseCreateSubQuery(IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection, Boolean).)
Public methodCreateTvfCallQuery
Creates a retrieval query from the tvfcall specified. The query will be a 'SELECT ... FROM functioncall' query.
(Inherited from DbSpecificCreatorBase.)
Public methodCreateValidAlias
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).)
Protected methodDestroyCurrentAliasScope
Destroys the current alias scope and makes the previous one active, if any.
(Inherited from DbSpecificCreatorBase.)
Public methodDetermineDbTypeNameForValue
Determines the db type name for value.
(Overrides DbSpecificCreatorBaseDetermineDbTypeNameForValue(Object, Object).)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodFindRealAlias(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.)
Public methodFindRealAlias(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.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetNewPerCallCatalogName
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.)
Public methodGetNewPerCallSchemaName
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.)
Protected methodGetRealValue(Object, TypeConverter, Type)
Gets the real value, by converting the passed in value, if necessary
(Inherited from DbSpecificCreatorBase.)
Protected methodGetRealValue(Object, TypeConverter, Type, Boolean)
Gets the real value, by converting the passed in value, if necessary
(Inherited from DbSpecificCreatorBase.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodSetCreatorInDQE
Sets this instance as the creator in the DQE. Used in subquery creations, to pass on the creator to a DQE.
(Inherited from DbSpecificCreatorBase.)
Protected methodSetParameterType
Sets the ADO.NET provider specific Enum type of the parameter, using the string presentation specified.
(Overrides DbSpecificCreatorBaseSetParameterType(DbParameter, String).)
Public methodStripObjectNameChars
Strips the object name chars from the name passed in. For example [name] will become name
(Overrides DbSpecificCreatorBaseStripObjectNameChars(String).)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodToUpperFunctionName
Returns the SQL functionname to make a string uppercase.
(Inherited from DbSpecificCreatorBase.)
Top
See Also