Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Provides methods and properties that are used to access and manage data that is stored in a database.
Inheritance Hierarchy
System.Object
WebMatrix.Data.Database
Namespace: WebMatrix.Data
Assembly: WebMatrix.Data (in WebMatrix.Data.dll)
Syntax
'Declaration
Public Class Database _
Implements IDisposable
'Usage
Dim instance As Database
public class Database : IDisposable
public ref class Database : IDisposable
type Database =
class
interface IDisposable
end
public class Database implements IDisposable
The Database type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.jpeg "Public property") |
Connection | Gets the current connection to a database. |
Top
Methods
| Name | Description | |
|---|---|---|
.jpeg "Public method") |
Close | Closes an open database. |
|
Dispose() | Releases all resources used by a Database instance. |
.jpeg "Protected method") |
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.) |
.gif "Static member") |
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.) |
Top
Events
| Name | Description | |
|---|---|---|
.jpeg "Public event") |
ConnectionOpened | Occurs when a new database connection is opened by a Database instance. |
Top
Remarks
This class represents a helper, which is a component that simplifies Web programming in ASP.NET Web Pages. You can use the Database class to open, read, and update a database.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.