This document is provided on an "AS IS" basis without warranties of any kind. Smartsite iXperion class libraries may change in future releases.

Syntax

C#	Copy Code
public abstract class Database

Visual Basic (Declaration)	Copy Code
Public MustInherit Class Database

The type exposes the following members.

Public Methods

	Name	Description
	ConvertSqlServerTypeToNativeType	Converts the SqlServer type to the .Net native's type.
	CreateAdapter	Creates an IDbDataAdapter instance for the current database server.
	CreateCommand	Overloaded.
	CreateConnection	Create an IDbConnection instance for the current database server.
	CreateDatabase	Overloaded.
	CreatePagingQuery	Modifies the sql query into a query that uses paging.
	CreateParameter	Overloaded.
	Equals	(Inherited from Object.)
	ExecuteNonQuery	Overloaded.
	ExecuteReader	Overloaded.
	ExecuteScalar	Overloaded.
	ExecuteStoredProcedure	Executes a stored procedure. The query parameters must be named parameters. The result is a datatable that contains all the output parameters and their values of the stored procedure.
	GetById	Gets the Database that belongs to the given id which is defined in Smartsite.data.config.
	GetCommand	Overloaded.
	GetHashCode	(Inherited from Object.)
	GetIdentity	Overloaded.
	GetParameterName	Returns a string containing the modified parameterName, matching the current database format.
	GetType	(Inherited from Object.)
	NotifyAllTablesChanged	Notify this Database object that all the tables in the database have changed. This is useful when an unknown set of tables has been changed or when someone wants all the caches to be flushed.
	NotifyTableChanged	Overloaded.
	PreloadAsync	Asynchronously preloads the default database factory provider.
	PreparseQuery	Overloaded.
	SetIdentityInsertOnOff	Sets the identity insert on or off.
	ToString	(Inherited from Object.)

	Name	Description
	CreateConnectionBase	Creates a new connection.
	CreateMetaXml	Creates an Xml document containing a description of the database.
	ExecuteInternal	Executes the query
	Finalize	(Inherited from Object.)
	GetCachedParsedQuery	Returns the cached parsed query from cache or null otherwise.
	GetObjectId	Overloaded.
	LogExecute	Overloaded.
	MakeDbNullable<(Of <<'(T>)>>)
	MemberwiseClone	(Inherited from Object.)
	OnAfterExecuteStoredProcedure	Execeted after a stored procedure has been executed. This method can be used to modify the result.
	OnBeforeExecuteStoredProcedure	Executed before a stored procedure has been executed. This method can be used to modify the command object.
	PreparseParameterizedQuery	Overloaded.
	SetCachedParsedQuery	Adds the parsed query to the cache.
	SplitQueryOnParameters	Splits a parameterized query on the '?' symbol, ignoring any question marks in strings or comments. This method can be used by inheritors who must replace the '?' symbol by something else because their providers need that.
	SplitSqlStatements	Splits the sql statement in multiple statements.

	Name	Description
	DynamicDatabaseConnections	String for Dynamic Connections.

	Name	Description
	ApplicationName	Gets or sets the application name that is reported on the database connection. (Visible in Sql Traces).
	ConnectionString	Returns the connection string.
	Current	Returns the default database of the current user.
	Id	Returns the Id of this database
	IsCmsDatabase	Gets if this database is a CMS database. Once set to true, isCmsDatabase can never be set to false again.
	Meta	Returns meta information about this database.
	ProviderName	Gets the provider invariant name.
	ServerType	Returns the database server type.
	ServerVersion	Gets the dbms version.
	TableCache	Returns the TableCacheManager for this Database.

	Name	Description
	CustomVwSchemaProcedureParameters	Returns the sql query that retrieves data normally returned by VwSchemaProcedureParameters. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
	CustomVwSchemaProcedures	Returns the sql query that retrieves data normally returned by vwSchemaTables. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
	CustomVwSchemaTables	Returns the sql query that retrieves data normally returned by vwSchemaTables. This sql query is used for non-Cms databases when vwSchemaTables does not exist.
	Factory	Gets the factory for this database.
	ParsedConnectionString	Gets the parsed connection string.

	Name	Description
	TableChanged	Event that is raised when a row in a table in this database is changed.