xSQL Schema Compare SDK for SQL Server version 12
SqlDatabase Class Members
Properties  Methods  Events


The following tables list the members exposed by SqlDatabase.

Public Properties
 NameDescription
Public PropertyConnectionString Gets or sets the dedicated connection string for the database which contains the credentials required to connect to the database. By default the database use the credentials of the parent SQL Server.  
Public PropertyDependencyManager Provides access to database dependencies.  
Public PropertyFullName Gets the full name of the entity formatted as schema.name. If the entity has no schema, only the name is returned. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyFullNameDelimited Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingName Gets the fully-qualifying name for the entity. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingNameDelimited Gets the fully-qualifying name for the entity with delimiters. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyId Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyIsLoadedFromSnapshot Gets the value that indicates whether the database is loaded from a snapshot file.  
Public PropertyName Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyParent Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyPropertiesGets the SqlDatabasePropertySet object that provides access to various database properties.  
Public PropertySchema Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySessionProvides access to the most-recent schema read session. See SchemaSession class for more details.  
Public PropertySqlAggregates Gets the collection of user-defined aggregates.  
Public PropertySqlApplicationRoles Gets the collection of database application roles.  
Public PropertySqlAssemblies Gets the collection of database .NET assemblies.  
Public PropertySqlAsymmetricKeys Gets the collection of database asymmetric keys.  
Public PropertySqlBrokerContracts Gets the collection of Service Broker contracts.  
Public PropertySqlBrokerMessageTypes Gets the collection of Service Broker message types.  
Public PropertySqlBrokerPriorities Gets the collection of Service Broker priorities.  
Public PropertySqlBrokerQueues Gets the collection of Service Broker queues.  
Public PropertySqlBrokerRemoteServiceBindings Gets the collection of Service Broker remote service bindings.  
Public PropertySqlBrokerRoutes Gets the collection of Service Broker routes.  
Public PropertySqlBrokerServices Gets the collection of Service Broker services.  
Public PropertySqlCertificates Gets the collection of database certificates.  
Public PropertySqlClrDatabaseTriggers Gets the collection of database CLR triggers.  
Public PropertySqlClrDataTypes Gets the collection of CLR (user-defined) types.  
Public PropertySqlClrFunctions Gets the collection of CLR functions.  
Public PropertySqlClrProcedures Gets the collection of CLR procedures.  
Public PropertySqlColumnEncryptionKeys Gets the collection of the column encryption keys in the database.  
Public PropertySqlColumnMasterKeys Gets the collection of the column master keys in the database.  
Public PropertySqlDatabaseGets the SqlEntity.SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertySqlDatabaseRoles Gets the collection of database roles.  
Public PropertySqlDatabaseTriggers Gets the collection of database triggers.  
Public PropertySqlDefaults Gets the collection of defaults.  
Public PropertySqlEntityType Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public PropertySqlExtendedProperties Gets the collection of extended properties for the database.  
Public PropertySqlFileGroups Gets the collection of database filegroups.  
Public PropertySqlFullTextCatalogs Gets the collection of full-text catalogs.  
Public PropertySqlFullTextStopLists Gets the collection of full-text stop lists.  
Public PropertySqlFunctions Gets the collection of user-defined functions.  
Public PropertySqlLogFiles Gets the collection database log files.  
Public PropertySqlMemoryTables Gets the collection of memory-optimized tables.  
Public PropertySqlPartitionFunctions Gets the collection of partition functions.  
Public PropertySqlPartitionSchemes Gets the collection of partition schemes.  
Public PropertySqlPermissions Gets the collection of database permissions including statement permissions.  
Public PropertySqlProcedures Gets the collection of user-defined stored procedures.  
Public PropertySqlRules Gets the collection of rules.  
Public PropertySqlSchemas Gets the collection of database schemas.  
Public PropertySqlSearchPropertyLists Gets the collection of search property lists.  
Public PropertySqlSecurityPolicies Gets the collection of the security policies in the database.  
Public PropertySqlSequences Gets the collection of sequences.  
Public PropertySqlServerGets the SqlServer on which the database resides.  
Public PropertySqlSymmetricKeys Gets the collection of database symmetric keys.  
Public PropertySqlSynonyms Gets the collection of synonyms.  
Public PropertySqlTables Gets the collection of database tables.  
Public PropertySqlUserDefinedDataTypes Gets the collection of user-defined data types.  
Public PropertySqlUserDefinedTableTypes Gets the collection of user-defined table types.  
Public PropertySqlUsers Gets the collection of database users.  
Public PropertySqlViews Gets the collection of database views.  
Public PropertySqlXmlSchemaCollections Gets the collection of database xml schema collections.  
Top
Public Methods
 NameDescription
Public Methodstatic (Shared in Visual Basic)CreateFromSnapshotOverloaded.  Creates a database objects from the specified snapshot.  
Public MethodCreateScripterGets a xSQL.Schema.SqlServer.SqlScripter object that can be used to generate T-SQL script for the database objects.  
Public MethodEqualsOverloaded. Returns true if this instance of the SqlScriptableEntity class is equal to the other object, which should also be an instance of SqlScriptableEntity class. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public MethodGetConnectionString Gets the connection string for the database, which contains the credentials required to connect to the database.  
Public MethodGetDefaultSnapshotFilename Returns the default filename for the database snapshot.  
Public MethodGetScript Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public MethodReadSchemaOverloaded.  Reads the database schema.  
Public MethodSaveToSnapshotOverloaded.  Saves the schema of the database to a snapshot file with the specified name.  
Public MethodToString Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Top
Public Events
 NameDescription
Public EventSchemaOperation A generic event that provides information during schema operations.  
Public EventSchemaOperationCanceled The event that occurs after a schema operation is canceled.  
Public EventSnapshotOperation An event that provides progress information during the creation of a database snapshot.  
Public EventSqlAggregateFinished The event that indicates that the schema read of user-defined aggregates has finished.  
Public EventSqlApplicationRoleFinished The event that indicates that the schema read of application roles has finished.  
Public EventSqlAssemblyFileFinished The event that indicates that the schema read of assembly files has finished.  
Public EventSqlAssemblyFinished The event that indicates that the schema read of database .NET assemblies has finished.  
Public EventSqlAsymmetricKeyFinished The event that indicates that the schema read of asymmetric keys has finished.  
Public EventSqlBrokerContractFinished The event that indicates that the schema read of service broker contracts has finished.  
Public EventSqlBrokerMessageTypeFinished The event that indicates that the schema read of service broker message types has finished.  
Public EventSqlBrokerPriorityFinished The event that indicates that the schema read of service broker priorities has finished.  
Public EventSqlBrokerQueueFinished The event that indicates that the schema read of service broker queues has finished.  
Public EventSqlBrokerRemoteServiceBindingFinished The event that indicates that the schema read of service broker remote service bindings has finished.  
Public EventSqlBrokerRouteFinished The event that indicates that the schema read of service broker routes has finished.  
Public EventSqlBrokerServiceFinished The event that indicates that the schema read of broker services has finished.  
Public EventSqlCertificateFinished The event that indicates that the schema read of certificates has finished.  
Public EventSqlCheckConstraintFinished The event that indicates that the schema read of check constraints has finished.  
Public EventSqlClrDataTypeFinished The event that indicates that the schema read of CLR data types has finished.  
Public EventSqlClrFunctionFinished The event that indicates that the schema read of CLR functions has finished.  
Public EventSqlClrProcedureFinished The event that indicates that the schema read of CLR procedures has finished.  
Public EventSqlClrTriggerFinished The event that indicates that the schema read of CLR triggers has finished.  
Public EventSqlColumnFinished The event that indicates that the schema read of columns has finished.  
Public EventSqlDatabaseClrTriggerFinished The event that indicates that the schema read of database CLR triggers has finished.  
Public EventSqlDatabaseRoleFinished The event that indicates that the schema read of database roles has finished.  
Public EventSqlDatabaseTriggerFinished The event that indicates that the schema read of database triggers has finished.  
Public EventSqlDefaultConstraintFinished The event that indicates that the schema read of default constraints has finished.  
Public EventSqlDefaultFinished The event that indicates that the schema read of database defaults has finished.  
Public EventSqlExtendedPropertyFinished The event that indicates that the schema read of extended properties has finished.  
Public EventSqlForeignKeyFinished The event that indicates that the schema read of foreign keys has finished.  
Public EventSqlFullTextCatalogFinished The event that indicates that the schema read of full-text catalogs has finished.  
Public EventSqlFullTextIndexFinished The event that indicates that the schema read of full-text indexes has finished.  
Public EventSqlFullTextStopListFinished The event that indicates that the schema read of full-text stop lists has finished.  
Public EventSqlFunctionFinished The event that indicates that the schema read of user-defined functions has finished.  
Public EventSqlIndexFinished The event that indicates that the schema read of indexes has finished.  
Public EventSqlMemoryTableFinished The event that indicates that the schema read of memory-optimized tables has finished.  
Public EventSqlPartitionFunctionFinished The event that indicates that the schema read of partition functions has finished.  
Public EventSqlPartitionSchemeFinished The event that indicates that the schema read of partition schemes has finished.  
Public EventSqlPermissionFinished The event that indicates that the schema read of permissions has finished.  
Public EventSqlPrimaryKeyFinished The event that indicates that the schema read of primary keys has finished.  
Public EventSqlProcedureFinished The event that indicates that the schema read of stored-procedures has finished.  
Public EventSqlRuleFinished The event that indicates that the schema read of rules has finished.  
Public EventSqlSchemaFinished The event that indicates that the schema read of database schemas has finished.  
Public EventSqlSearchPropertyFinished The event that indicates that the schema read of search properties has finished.  
Public EventSqlSearchPropertyListFinished The event that indicates that the schema read of search property lists has finished.  
Public EventSqlSecurityPolicyFinished The event that indicates that the schema read of the security policies has finished.  
Public EventSqlSequenceFinished The event that indicates that the schema read of sequences has finished.  
Public EventSqlSpatialIndexFinished The event that indicates that the schema read of spatial indexes has finished.  
Public EventSqlStatisticFinished The event that indicates that the schema read of statistics has finished.  
Public EventSqlSymmetricKeyFinished The event that indicates that the schema read of symmetric keys has finished.  
Public EventSqlSynonymFinished The event that indicates that the schema read of synonyms has finished.  
Public EventSqlTableFinished The event that indicates that the schema read of database tables has finished.  
Public EventSqlTriggerFinished The event that indicates that the schema read of triggers has finished.  
Public EventSqlUniqueConstraintFinished The event that indicates that the schema read of unique constraints has finished.  
Public EventSqlUserDefinedDataTypeFinished The event that indicates that the schema read of user-defined data types has finished.  
Public EventSqlUserDefinedTableTypeFinished The event that indicates that the schema read of user-defined table types has finished.  
Public EventSqlUserFinished The event that indicates that the schema read of database users has finished.  
Public EventSqlViewFinished The event that indicates that the schema read of database views has finished.  
Public EventSqlXmlIndexFinished The event that indicates that the schema read of xml indexes has finished.  
Public EventSqlXmlSchemaCollectionFinished The event that indicates that the schema read of xml schema collections has finished.  
Top
See Also

Reference

SqlDatabase Class
xSQL.Schema.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback