LoadAllStoredProcedureAttribute Class

This attribute is used to specify the stored procedure used to load all 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 LoadAllStoredProcedureAttribute : StoredProcedureAttribute

VBView Source Request Example

Public NotInheritable Class LoadAllStoredProcedureAttribute
	Inherits StoredProcedureAttribute

C++View Source Request Example

public ref class LoadAllStoredProcedureAttribute sealed : public StoredProcedureAttribute

F#View Source Request Example

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

Inheritance: Object Attribute StoredProcedureAttribute LoadAllStoredProcedureAttribute

Remarks

If the stored procedure name matches the entity type name exactly or ends with the value of the ResultSetSuffix property, the attribute can be omitted.

Example

C#

[LoadAllStoredProcedure("spStateCodes")]
public sealed class StateCode
{
    // The state code
    public string State { get; set; }

    // The state description
    public string StateDesc { get; set; }
}

// Example usage:
using var dataContext = new DemoDatabaseDataContext().NoTracking();

var stateCodes = dc.LoadAll<StateCode>().ToList();

Constructors

LoadAllStoredProcedureAttribute

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)