DbSet(Of TEntity) Class
Entity Framework 5.0
Represents a typed entity set that is used to perform create, read, update, and delete operations. DbSet is not publicly constructible and can only be created from a DbContext instance.
System.Object
System.Data.Entity.Infrastructure.DbQuery(Of TEntity)
System.Data.Entity.DbSet(Of TEntity)
System.Data.Entity.Infrastructure.DbQuery(Of TEntity)
System.Data.Entity.DbSet(Of TEntity)
Namespace: System.Data.Entity
Assembly: EntityFramework (in EntityFramework.dll)
'Declaration Public Class DbSet(Of TEntity As Class) _ Inherits DbQuery(Of TEntity) _ Implements IDbSet(Of TEntity), IQueryable(Of TEntity), _ IEnumerable(Of TEntity), IQueryable, IEnumerable 'Usage Dim instance As DbSet(Of TEntity)
Type Parameters
- TEntity
The type that defines the set. The type can be derived type as well as base type.
The DbSet(Of TEntity) type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | Local | Returns ObservableCollection(Of T) that represents entities of the set that are currently being tracked by the context and have not been marked as Deleted. Accessing the Local property never causes a query to be sent to the database. This property is usually used after a query has already been executed. |
| Name | Description | |
|---|---|---|
![]() | Add | Adds the given entity to the context the Added state. When the changes are being saved, the entities in the Added states are inserted into the database. After the changes are saved, the object state changes to Unchanged. |
![]() | AsNoTracking | Returns a new query where the entities returned will not be cached in the DbContext. (Inherited from DbQuery(Of TResult).) |
![]() | Attach | Attaches the given entity to the context in the Unchanged |
![]() | Create | Creates a new instance of an entity for the type of this set. This instance is not added or attached to the set. The instance returned will be a proxy if the underlying context is configured to create proxies and the entity type meets the requirements for creating a proxy. |
![]() | Create(Of TDerivedEntity) | Creates a new instance of an entity for the type of this set or for a type derived from the type of this set. This instance is not added or attached to the set. The instance returned will be a proxy if the underlying context is configured to create proxies and the entity type meets the requirements for creating a proxy. |
![]() | Equals | Returns whether the specified object is equal to the current set. (Overrides DbQuery(Of TResult).Equals(Object).) |
![]() | Finalize | (Inherited from Object.) |
![]() | Find | Uses the primary key value to attempt to find an entity tracked by the context. If the entity is not in the context then a query will be executed and evaluated against the data in the data source, and null is returned if the entity is not found in the context or in the data source. Note that the Find also returns entities that have been added to the context but have not yet been saved to the database. |
![]() | GetHashCode | Returns the hash fucntion for the specified set. (Overrides DbQuery(Of TResult).GetHashCode.) |
![]() | GetType | Gets the type for the current set. |
![]() | Include | Returns the included LINQ to entities query against a DbContext. (Inherited from DbQuery(Of TResult).) |
![]() | MemberwiseClone | (Inherited from Object.) |
![]() | Remove | Marks the given entity as Deleted. When the changes are saved, the entity is deleted from the database. The entity must exist in the context in some other state before this method is called. |
![]() | SqlQuery | Creates a raw SQL query that will return entities in this set. By default, the entities returned are tracked by the context; this can be changed by calling AsNoTracking on the DbSqlQuery(Of TEntity) returned from this method. |
![]() | ToString | Returns a String representation of the underlying query. (Inherited from DbQuery(Of TResult).) |
| Name | Description | |
|---|---|---|
![]() | AddOrUpdate(Of TEntity)(TEntity()) | Overloaded. Adds or updates entities by key when SaveChanges is called. Equivalent to an "upsert" operation from database terminology. This method can be useful when seeding data using Migrations. (Defined by IDbSetExtensions.) |
![]() | AddOrUpdate(Of TEntity)(Expression(Of Func(Of TEntity, Object)), TEntity()) | Overloaded. Adds or updates entities by key when SaveChanges is called. Equivalent to an "upsert" operation from database terminology. This method can be useful when seeding data using Migrations. (Defined by IDbSetExtensions.) |
![]() | AsNoTracking(Of TEntity) | Returns a new query where the entities returned will not be cached in the DbContext or ObjectContext. (Defined by DbExtensions.) |
![]() | Include(Of TEntity)(String) | Overloaded. Specifies the related objects to include in the query results. (Defined by DbExtensions.) |
![]() | Include(Of TEntity, TProperty)(Expression(Of Func(Of TEntity, TProperty))) | Overloaded. Specifies the related objects to include in the query results. (Defined by DbExtensions.) |
![]() | Load | An extension method on IQueryable that enumerates the results of the query. This is equivalent to calling ToList without actually creating the list. (Defined by DbExtensions.) |
| Name | Description | |
|---|---|---|
![]() ![]() | IListSource.ContainsListCollection | Returns false. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IQueryable.ElementType | The IQueryable element type. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IQueryable.Expression | The IQueryable LINQ Expression. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IEnumerable(Of TResult).GetEnumerator | Gets the enumeration of this query causing it to be executed against the store. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IEnumerable.GetEnumerator | Gets the enumeration of this query causing it to be executed against the store. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IListSource.GetList | Throws an exception indicating that binding directly to a store query is not supported. (Inherited from DbQuery(Of TResult).) |
![]() ![]() | IQueryable.Provider | The IQueryable provider. (Inherited from DbQuery(Of TResult).) |
DbSet implements IQueryable so that it can be used with LINQ. All query functionality is delegated to the existing LINQ to Entities provider.
DbSet does not support the Entity SQL methods.
DbSet does not support MEST (Multiple Entity Sets per Type) meaning that there is always a one-to-one correlation between a type and a set.
Show:

