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 methods.

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.