DeleteEntityStoredProcedureAttribute Class

This attribute is used to specify the stored procedure used to delete entities for the associated type

Definition

Namespace: EWSoftware.EntityFramework.DataAnnotations
Assembly: EWSoftware.EntityFramework (in EWSoftware.EntityFramework.dll) Version: 2025.11.12.0

C#View Source Request Example

public sealed class DeleteEntityStoredProcedureAttribute : StoredProcedureAttribute

VBView Source Request Example

Public NotInheritable Class DeleteEntityStoredProcedureAttribute
	Inherits StoredProcedureAttribute

C++View Source Request Example

public ref class DeleteEntityStoredProcedureAttribute sealed : public StoredProcedureAttribute

F#View Source Request Example

[<SealedAttribute>]
type DeleteEntityStoredProcedureAttribute = 
    class
        inherit StoredProcedureAttribute
    end

Inheritance: Object Attribute StoredProcedureAttribute DeleteEntityStoredProcedureAttribute

Remarks

The stored procedure must have one or more parameters representing the key columns on the entity type identified with a PrimaryKeyAttribute or one or more properties with a KeyAttribute or defined by the data context. It should not return a value or a result set. All parameters are input only.

Example

C#

[LoadByKeyStoredProcedure("spProductInfo"), InsertEntityStoredProcedure("spProductAddUpdate"),
  UpdateEntityStoredProcedure("spProductAddUpdate"), DeleteEntityStoredProcedure("spProductDelete")]
public sealed class ProductInfo : ChangeTrackingEntity
{
    // The primary key
    [Key]
    public int ProductID
    {
    get;
    set => this.SetWithNotify(value, ref field);
    }

    // Product name
    public string? ProductName
    {
    get;
    set => this.SetWithNotify(value, ref field);
    }

    ...
}

// Example Load By Key usage:
using var dataContext = new DemoDatabaseDataContext();

var productInfo = dc.LoadByKey<ProductInfo>(productID).Single();

// Add a new entity
var newProduct = new ProductInfo { ProductName = "New Product" };

dataContext.InsertEntity(newProduct);

// Update an existing entity
productInfo.ProductName = "Updated Product";

dataContext.UpdateEntity(productInfo);

// Delete an entity
dataContext.DeleteEntity(productInfo);

// Since change tracking is enabled, we could also have just submitted the changes:
// dataContext.SubmitChanges<ProductInfo>();

Constructors

DeleteEntityStoredProcedureAttribute

Initialize a new instance of the attribute using the given stored procedure name

Properties

ParameterNamePrefix	This can be used to define an optional parameter name prefix that will be applied to all stored procedure parameters. (Inherited from StoredProcedureAttribute)
StoredProcedureName	This read-only property returns the name of the stored procedure to execute when loading entities (Inherited from StoredProcedureAttribute)
TypeId	When implemented in a derived class, gets a unique identifier for this Attribute. (Inherited from Attribute)

Methods

Equals	Returns a value that indicates whether this instance is equal to a specified object. (Inherited from Attribute)
GetHashCode	Returns the hash code for this instance. (Inherited from Attribute)
GetType	Gets the Type of the current instance. (Inherited from Object)
IsDefaultAttribute	When overridden in a derived class, indicates whether the value of this instance is the default value for the derived class. (Inherited from Attribute)
Match	When overridden in a derived class, returns a value that indicates whether this instance equals a specified object. (Inherited from Attribute)
ToString	Returns a string that represents the current object. (Inherited from Object)

Extension Methods

ToNullableT	This is used to convert objects to null values if they are equal to null, DBNull.Value, or the default value for the given type. (Defined by DatabaseExtensions)
ToStringOrNull	This is used to convert an object to a string and return either the string value if not empty, or null if it is an empty string. (Defined by DatabaseExtensions)