Database Methods

Include Protected Members
Include Inherited Members

The Database type exposes the following members.

Methods

  Name Description
Public method Close Closes an open database.
Public method Dispose() Releases all resources used by a Database instance.
Protected method Dispose(Boolean) Releases the unmanaged resources used by a Database instance and optionally releases the managed resources.
Public method Equals (Inherited from Object.)
Public method Execute Executes a non-query SQL statement.
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetLastInsertId Returns the identity column of the most recently inserted row.
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public methodStatic member Open Opens a connection to a database using the specified file name or using the named connection string.
Public methodStatic member OpenConnectionString(String) Opens a connection to a database using the specified connection string.
Public methodStatic member OpenConnectionString(String, String) Opens a connection to a database using a connection string and the specified provider.
Public method Query Executes a SQL query that returns a list of rows as the result.
Public method QuerySingle Executes a SQL query that returns a single row as the result.
Public method QueryValue Executes a SQL query that returns a single scalar value as the result.
Public method ToString (Inherited from Object.)

Top

See Also

Reference

Database Class

WebMatrix.Data Namespace