SqlObject Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
SqlObject adds to SqlObjectBase logic to initialize from an xml file
[System.Runtime.InteropServices.ComVisible(false)]
public abstract class SqlObject : Microsoft.SqlServer.Management.Sdk.Sfc.SqlObjectBase, Microsoft.SqlServer.Management.Sdk.Sfc.ISupportInitDatabaseEngineData
[<System.Runtime.InteropServices.ComVisible(false)>]
type SqlObject = class
inherit SqlObjectBase
interface ISupportInitDatabaseEngineData
Public MustInherit Class SqlObject
Inherits SqlObjectBase
Implements ISupportInitDatabaseEngineData
- Inheritance
- Attributes
- Implements
Constructors
SqlObject() |
Properties
ConditionedSqlList |
prefix, postfix etc, that must be added when certain fields are requested (Inherited from SqlObjectBase) |
ConnectionInfo |
conection object (Inherited from EnumObject) |
Distinct |
the result must be distinct (Inherited from SqlObjectBase) |
Filter |
filter for this level (Inherited from EnumObject) |
FixedProperties |
list of the properties for which the value is know e.g. Name is know if the fileter is in the form [@Name='fff'] or [@Name='fff' and ( xxxxx ) ] (Inherited from EnumObject) |
Name |
name of the xpath level (Inherited from EnumObject) |
OrderByRedirect |
used to translate an order by on post process fields to other, supporting fields (Inherited from SqlObjectBase) |
PostProcessList |
post processes for the level (Inherited from SqlObjectBase) |
PropertyLinkList |
links for properties (Inherited from SqlObjectBase) |
Request |
the request for this level, it is received from one level down or from user if it is the last level (Inherited from EnumObject) |
RequestParentSelect |
Storeage for a parent select ( when we need the tsql for the parent level, usually to insert it in prefix ) (Inherited from SqlObjectBase) |
ResourceAssembly |
abstract function that returns the assembly in which this object has the configuration file |
ResultTypes |
reports the ResultTypes supported by this level (Inherited from SqlObjectBase) |
SpecialQuery |
stores a query used to test a condition , for example that a table needed to resolve this level exists, if that fails then the empty set is returned rather then exception (Inherited from SqlObjectBase) |
SqlRequest |
the SqlRequest that this level must resolve (Inherited from SqlObjectBase) |
StatementBuilder |
The TSQL place holder + information that will be later transformed in TSQL (Inherited from SqlObjectBase) |
SupportsParameterization | (Inherited from SqlObjectBase) |
Urn |
this property lives only while a request is serviced (Inherited from EnumObject) |
Methods
AddConditionals(String) |
add sql wich is necessary if the property: field, is requested (Inherited from SqlObjectBase) |
AddConditionalsJustPropDependencies(String) |
add whatever is required to support it (Inherited from SqlObjectBase) |
AddConstantForFilter(String) |
FilterDecoder reports that a constant is used in filter gives client a chance to modify it (Inherited from SqlObjectBase) |
AddFilterProperty(String) |
the xpath scanner has detected that this property is used in filter add whatever is required to support it, return value (Inherited from SqlObjectBase) |
AddLinkProperty(String) |
add whatever is required to support it, return value (Inherited from SqlObjectBase) |
AddOrderByAcrossDatabases() |
add the order by clause when the tsql runs across databases (Inherited from SqlObjectBase) |
AddOrderByInDatabase() |
add the order by clause when the tsql runs inside one database (Inherited from SqlObjectBase) |
AddOrderByProperty(String, Boolean) |
Add the information that the TSQL is ordered by the property name if overrideFlags is tru don't check if it is legal to use this property for order by (Inherited from SqlObjectBase) |
AddOrderByProperty(String) |
the xpath scanner has detected that this property is used in orderby add whatever is required to support it, return value (Inherited from SqlObjectBase) |
AddProperty(ObjectProperty) |
add to the collection of properties (Inherited from EnumObject) |
AddPropertyForFilter(String) |
name property is used in filter (Inherited from SqlObjectBase) |
BeforeStatementExecuted(String) |
Allow subclasses to add anything to the statement (Inherited from SqlObjectBase) |
BuildStatement(EnumResult) |
build statement (Inherited from SqlObjectBase) |
ClearHits() |
clear all the conditional tsql which was activated for the fields in this request (Inherited from SqlObjectBase) |
ComputeFixedProperties() |
calculate the list of fixed properties ( their value can be deduced from the filter ) (Inherited from EnumObject) |
FillData(ResultType, StringCollection, Object, StatementBuilder) |
n queries to prepare and the last one to fill the data (Inherited from SqlObjectBase) |
FillDataWithUseFailure(SqlEnumResult, ResultType) |
Get data from Sql Server. If we fail to get into a database then ignore that database (Inherited from SqlObjectBase) |
GetAliasPropertyName(String) |
get the property name as it will be aliased in the result set to the user (Inherited from EnumObject) |
GetData(EnumResult) |
fill StatementBuilder with the information for this level (Inherited from SqlObjectBase) |
GetFixedStringProperty(String, Boolean) |
get a fixed ( with known value from filter ) property of type string (Inherited from EnumObject) |
GetProperties(ObjectPropertyUsages) |
returns the object properties by usage (Inherited from EnumObject) |
GetProperty(String, ObjectPropertyUsages) |
accessor for a property by name and usage ( internal use ) (Inherited from EnumObject) |
GetSqlProperty(String, ObjectPropertyUsages) |
get the property field if it is legal for the usage, else throw (Inherited from SqlObjectBase) |
GetUrnProperties() |
until we have a formal way so that each object declares which properties it uses for urn try this best guess aproach (Inherited from EnumObject) |
Initialize(Object, XPathExpressionBlock) |
initialize the connection info and xpath information |
IntegrateParentResult(EnumResult) |
combine StatementBuilder from this level with what was received in the result from the parent level (Inherited from SqlObjectBase) |
LoadAndStore(XmlReadDoc, Assembly, StringCollection) |
load from the specfied xml doc in the assemblyObject assembly the fields specified in requestedFields; also after loading initialize static links between the properties. |
LoadInitData(String, ServerVersion, DatabaseEngineType, DatabaseEngineEdition) |
load the specified file for the specified version |
LoadInitDataFromAssembly(Assembly, String, ServerVersion, DatabaseEngineType, DatabaseEngineEdition) |
load the specified file for the specified version from the specified assembly |
PostProcess(EnumResult) |
execute any PostProcess actions (Inherited from SqlObjectBase) |
ResolveComputedField(String) |
a computed field has been used. return its dynamically calculated value (Inherited from SqlObjectBase) |
ResolveLocalLinkLinks() |
resolve all links which can be resolved at the local level (Inherited from SqlObjectBase) |
RestoreInitialState() |
get the object in a clean state remove whatever was changed to resolve the current request (Inherited from SqlObjectBase) |
RetrieveParentRequest() |
Retrive the request that will be sent to the parent level. we must comunicate wht info we need from the parent level here (Inherited from SqlObjectBase) |
StoreInitialState() |
pre initialize the object with the static info. ( resolve local links ) (Inherited from SqlObjectBase) |
TryGetProperty(String, ObjectPropertyUsages) |
accessor for a property by name and usage ( internal use ) (Inherited from EnumObject) |