TSqlObject 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.
Represents an instance of an object for a SQL Server database schema.
public sealed class TSqlObjecttype TSqlObject = classPublic NotInheritable Class TSqlObject- Inheritance
-
TSqlObject
Properties
| Item[ModelPropertyClass] |
Returns the property value. |
| Name |
Identity of the object. |
| ObjectType |
Type of the object. |
Methods
| Equals(Object) |
Checks if this TSqlObject is equal to another TSqlObject |
| GetAst() |
Generates a new TSqlScript representing the AST for the TSqlObject, if this is supported for the TSqlObject. AST generation is only supported for top-level objects, with certain objects such as the DatabaseOptions and inline constraints not supporting AST generation even though they are top level types. If it's unknown whether the object is capable of being scripted then the TryGetAst(TSqlScript) method should be used instead. The generated AST is a newly generated object that defines the information about this TSqlObject and any objects that would be scripted together with it. For example a Table would also script out the Columns and inline constraint definitions of a Table. This method can be used to copy object information from one model to another, or to script out information about objects in the model. |
| GetChildren() |
Returns all TSqlObject child objects within the Default scope. |
| GetChildren(DacQueryScopes) |
Returns all TSqlObject child objects within the specified DacQueryScopes scope. |
| GetHashCode() |
Gets the Hashcode for this object |
| GetMetadata(ModelMetadataClass) |
Returns the metadata property value. |
| GetMetadata<T>(ModelMetadataClass) |
Returns the metadata property value. |
| GetParent() |
Returns the parent TSqlObject, if it is within the Default scope and if there is only one TSqlObject that could be the parent for this object.. |
| GetParent(DacQueryScopes) |
Returns the parent TSqlObject, if it is within the specified DacQueryScopes scope and if there is only one TSqlObject that could be the parent for this object. |
| GetProperty(ModelPropertyClass) |
Returns the property value. |
| GetProperty<T>(ModelPropertyClass) |
Returns the property value. |
| GetReferenced() |
Gets all referenced objects within the Default scope |
| GetReferenced(DacQueryScopes) |
Gets all referenced objects within a given DacQueryScopes scope. |
| GetReferenced(ModelRelationshipClass) |
Gets referenced objects for a given ModelRelationshipClass, where objects are within the Default scope |
| GetReferenced(ModelRelationshipClass, DacQueryScopes) |
Gets referenced objects for a given ModelRelationshipClass, where objects are within a given DacQueryScopes scope. |
| GetReferencedRelationshipInstances() |
For each object referenced by this TSqlObject, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the Default scope will be returned. |
| GetReferencedRelationshipInstances(DacExternalQueryScopes) |
For each object referenced by this TSqlObject, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the specified DacQueryScopes scope will be returned. To return non-composite or system references the scope must be set to include externals. In addition, in this case only the ObjectIdentifier of the referenced object will be returned |
| GetReferencedRelationshipInstances(DacQueryScopes) |
For each object referenced by this TSqlObject, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the specified DacQueryScopes scope will be returned. To return non-composite or system references the GetReferencedRelationshipInstances(DacExternalQueryScopes) method should be called instead |
| GetReferencedRelationshipInstances(ModelRelationshipClass) |
For objects referenced by this TSqlObject with a specific ModelRelationshipClass, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the Default scope will be returned. |
| GetReferencedRelationshipInstances(ModelRelationshipClass, DacExternalQueryScopes) |
For objects referenced by this TSqlObject with a specific ModelRelationshipClass, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the specified DacExternalQueryScopes scope will be returned. To return non-composite or system references the scope must be set to include externals. In addition, in this case only the ObjectIdentifier of the referenced object will be returned |
| GetReferencedRelationshipInstances(ModelRelationshipClass, DacQueryScopes) |
For objects referenced by this TSqlObject with a specific ModelRelationshipClass, returns the ModelRelationshipInstance defining the relationship data. This will include the referenced object if it exists, the ObjectIdentifier used to identify the referenced object, and any properties specific to this relationship. Only objects within the specified DacQueryScopes scope will be returned. To return non-composite or system references the GetReferencedRelationshipInstances(DacExternalQueryScopes) method should be called instead |
| GetReferencing() |
Gets all referencing objects within the Default scope |
| GetReferencing(DacQueryScopes) |
Gets all referencing objects within a given DacQueryScopes scope. |
| GetReferencing(ModelRelationshipClass) |
Gets referencing objects, where the relationship is defined by a specific ModelRelationshipClass and where objects are within the Default scope |
| GetReferencing(ModelRelationshipClass, DacQueryScopes) |
Gets referencing objects, where the relationship is defined by a specific ModelRelationshipClass and where objects are within a given DacQueryScopes scope. |
| GetReferencingRelationshipInstances() |
For each object referencing this TSqlObject, returns the ModelRelationshipInstance defining the relationship data. This will include the referencing object - definedby the FromObject field, and any properties specific to this relationship. Only objects within the specified DacQueryScopes scope will be returned. |
| GetReferencingRelationshipInstances(DacQueryScopes) |
For each object referencing this TSqlObject, returns the ModelRelationshipInstance defining the relationship data. This will include the referencing object - definedby the FromObject field, and any properties specific to this relationship. Only objects within the Default scope will be returned. |
| GetReferencingRelationshipInstances(ModelRelationshipClass) |
For each object referencing this TSqlObject with a specific ModelRelationshipClass, returns the ModelRelationshipInstance defining the relationship data. This will include the referencing object - definedby the FromObject field, and any properties specific to this relationship. Only objects within the Default scope will be returned. |
| GetReferencingRelationshipInstances(ModelRelationshipClass, DacQueryScopes) |
For each object referencing this TSqlObject with a specific ModelRelationshipClass, returns the ModelRelationshipInstance defining the relationship data. This will include the referencing object - definedby the FromObject field, and any properties specific to this relationship. Only objects within the specified DacQueryScopes scope will be returned. |
| GetScript() |
Generates a CREATE script from the objects AST. AST generation is only supported for top-level objects, with certain objects such as the DatabaseOptions and inline constraints not supporting AST generation even though they are top level types. If it's unknown whether the object is capable of being scripted then the TryGetAst(TSqlScript) method should be used instead. |
| GetSourceInformation() |
Gets the SourceInformation for this object, if this is available |
| TryGetAst(TSqlScript) |
Attempts to generate an AST for the object. AST generation is only supported for top-level objects, with certain objects such as the DatabaseOptions and inline constraints not supporting AST generation even though they are top level types. The generated AST is a newly generated object that defines the information about this TSqlObject and any objects that would be scripted together with it. For example a Table would also script out the Columns and inline constraint definitions of a Table. This method can be used to copy object information from one model to another, or to script out information about objects in the model. |
| TryGetScript(String) |
Attempts to generate a CREATE script from the objects AST. AST generation is only supported for top-level objects, with certain objects such as the DatabaseOptions and inline constraints not supporting AST generation even though they are top level types. If it's unknown whether the object is capable of being scripted then the TryGetAst(TSqlScript) method should be used instead. |