Click or drag to resize
SqlServerSpecificCreator Class
Implements IDbSpecificCreator for SqlServer.
Inheritance Hierarchy

Namespace:  SD.LLBLGen.Pro.DQE.SqlServer
Assembly:  SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.2.0.0 (5.2.17.0403)
Syntax
[SerializableAttribute]
public class SqlServerSpecificCreator : DbSpecificCreatorBase

The SqlServerSpecificCreator type exposes the following members.

Constructors
  NameDescription
Public methodSqlServerSpecificCreator
CTor
Top
Properties
  NameDescription
Protected propertyAliasScopes
Gets the alias scopes.
(Inherited from DbSpecificCreatorBase.)
Public propertyCreatingSubQuery
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.)
Public propertyFactoryToUse
Gets the DbProviderFactory instance to use.
(Overrides DbSpecificCreatorBaseFactoryToUse.)
Protected propertyParameterPrefix
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.)
Public propertyPerCallCatalogNameOverwrites
Gets / sets perCallCatalogNameOverwrites name pairs
(Inherited from DbSpecificCreatorBase.)
Public propertyPerCallSchemaNameOverwrites
Gets / sets perCallSchemaNameOverwrites name pairs
(Inherited from DbSpecificCreatorBase.)
Protected propertySetTimeoutOnCommandCreate
Gets a value indicating whether the timeout has to be set on command create.
(Inherited from DbSpecificCreatorBase.)
Public propertyUseNoLockHintsForObjectNames
Gets / sets useNoLockHintsForObjectNames
Top
Methods
  NameDescription
Protected methodAddParameterToScopeTracker
Adds the parameter to scope tracker.
(Inherited from DbSpecificCreatorBase.)
Public methodAppendValidIdentifier
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).)
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 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.)
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 Obsolete.
Creates the hint statement for the hint passed in.
(Inherited from DbSpecificCreatorBase.)
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(ParameterDirection, Object, String)
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(String)
Creates a new parameter instance.
(Inherited from DbSpecificCreatorBase.)
Protected methodCreateParameterInstance(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.)
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, prefixed with the parameter prefix for this DQE available in ParameterPrefix.
(Inherited from DbSpecificCreatorBase.)
Public methodCreatePlainSQLParameterName(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.)
Public methodCreatePlainSQLParameterName(String)
Creates the name of a parameter based on the values specified, using the pattern: prefix + nameWithoutPrefix. For plain sql queries.
(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 methodCreateTemporalTablePredicate
Creates the temporal table predicate fragment for the predicateType specified
(Overrides DbSpecificCreatorBaseCreateTemporalTablePredicate(TemporalTablePredicateType, String, ListDateTime, ListDbParameter).)
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.)
Public methodProduceFromClauseDirectiveFragments
Produces the from clause directive fragments from the specified fromClauseElementDirectives.
(Overrides DbSpecificCreatorBaseProduceFromClauseDirectiveFragments(IEnumerableFromClauseElementDirective, String, String, ListDbParameter).)
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
Fields
  NameDescription
Public fieldStatic memberCe35InvariantProviderName
Invariant name for obtaining the factory for SqlServer CE Desktop's Ce client for SqlServer Ce v3.5 versions
Public fieldStatic memberCe3xInvariantProviderName
Invariant name for obtaining the factory for SqlServer CE Desktop's Ce client for SqlServer Ce v3.0 or v3.1
Public fieldStatic memberCe40InvariantProviderName
Invariant name for obtaining the factory for SqlServer CE Desktop's Ce client for SqlServer Ce v4.0 and up.
Public fieldStatic memberServerInvariantProviderName
Invariant name for obtaining the factory for SqlServer's SqlClient, the client used when connecting to the server/Express/MSDE variant of SqlServer
Top
See Also