Database Class
Provides methods and properties that are used to access and manage data that is stored in a database.
Assembly: WebMatrix.Data (in WebMatrix.Data.dll)
The Database type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | Close | Closes an open database. |
![]() | Dispose() | Releases all resources used by a Database instance. |
![]() | Dispose(Boolean) | Releases the unmanaged resources used by a Database instance and optionally releases the managed resources. |
![]() | Equals | (Inherited from Object.) |
![]() | Execute | Executes a non-query SQL statement. |
![]() | Finalize | (Inherited from Object.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetLastInsertId | Returns the identity column of the most recently inserted row. |
![]() | GetType | (Inherited from Object.) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() ![]() | Open | Opens a connection to a database using the specified file name or using the named connection string. |
![]() ![]() | OpenConnectionString(String) | Opens a connection to a database using the specified connection string. |
![]() ![]() | OpenConnectionString(String, String) | Opens a connection to a database using a connection string and the specified provider. |
![]() | Query | Executes a SQL query that returns a list of rows as the result. |
![]() | QuerySingle | Executes a SQL query that returns a single row as the result. |
![]() | QueryValue | Executes a SQL query that returns a single scalar value as the result. |
![]() | ToString | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | ConnectionOpened | Occurs when a new database connection is opened by a Database instance. |
Show:
