Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
Library Powered By
This library is powered by Entity Framework Extensions
EntityFrameworkExtras
EntityFrameworkExtras provides some useful additions to EntityFramework such as executing Stored Procedures with User-Defined Table Types and Output Parameters.
Nuget
- Entity Framework Core - https://www.nuget.org/packages/EntityFrameworkExtras.EFCore/
- Entity Framework 6 - https://www.nuget.org/packages/EntityFrameworkExtras.EF6/
- Entity Framework 5 - https://www.nuget.org/packages/EntityFrameworkExtras.EF5/
- Entity Framework 4 - https://www.nuget.org/packages/EntityFrameworkExtras/
Executing a Stored Procedure with a User Defined Table Type
- Define a stored procedure class
[StoredProcedure("storedproc_AddMemberWithAddresses")]
public class AddMemberStoredWithAddressesProcedure
{
[StoredProcedureParameter(SqlDbType.NVarChar, ParameterName = "ForeName")]
public string FirstName { get; set; }
[StoredProcedureParameter(SqlDbType.NVarChar,ParameterName = "SurName")]
public string LastName { get; set; }
[StoredProcedureParameter(SqlDbType.Int)]
public int Age { get; set; }
[StoredProcedureParameter(SqlDbType.Udt)]
public List<Address> Addresses { get; set; }
}- A User Defined Table Type parameter is declared as a List<> (List). The UDT will also require some attributes:
[UserDefinedTableType("udt_Address")]
public class Address
{
[UserDefinedTableTypeColumn(1)]
public string Line1 { get; set; }
[UserDefinedTableTypeColumn(2)]
public string Line2 { get; set; }
[UserDefinedTableTypeColumn(3)]
public string Postcode { get; set; }
}- Execute the Stored Procedure with either a DbContext or an ObjectContext
DbContext context = new DbContext("ConnectionString");
var proc = new AddMemberStoredWithAddressesProcedure()
{
FirstName = "Michael",
LastName = "Bovis",
Age = 26,
Addresses = new List<Address>()
{
new Address() {Line1 = "16", Line2 = "The Lane", Postcode = "MA24WE"}
}
};
context.Database.ExecuteStoredProcedure(proc);Executing a Stored Procedure with a Output parameter
- To add an Output parameter you just need to set the Direction parameter to ParameterDirection.Output.
[StoredProcedure("storedProc_GetOldestAge")]
public class GetOldestAgeStoredProcedure
{
[StoredProcedureParameter(SqlDbType.Int, Direction = ParameterDirection.Output)]
public int Age { get; set; }
}- Execute the Stored Procedure and the parameter will be set to the output parameter value
var proc = new GetOldestAgeStoredProcedure();
context.Database.ExecuteStoredProcedure(proc);
int age = proc.Age; //Is now the oldest ageThanks to the contributors!
- https://github.com/JoeBrockhaus - Joe
- https://github.com/thomasvanderhoofWork - Thomas
- https://github.com/dimeptr - Dimeptr
- https://github.com/kalahari - Blake
- https://github.com/jurkrit - Jurkrit
- https://github.com/Mark-SH - Mark
