67 packages tagged with “Stored”
Support for store functions (table valued functions, scalar user defined functions and stored procedures) for Entity Framework 6.3.0+ Code First.
Entity Framework Core extension to execute stored procedures and map the result to a custom model
EntityFramework.Functions library implements Entity Framework code first support for - Stored procedures (with single result type, multiple result types, output parameter), - Table-valued functions (returning entity type, complex type), - Scalar-valued functions (composable, non-composable), - Aggregate functions, - Built-in functions, - Niladic functions, - Model defined functions. EntityFramework.Functions library works on .NET Standard with Entity Framework 6.4.0. It also works on .NET 4.0, .NET 4.5, .NET 4.6, .NET 4.7, .NET 4.8 with Entity Framework 6.1.0 and later. It can be installed through Nuget: - dotnet add package EntityFramework.Functions Or: - Install-Package EntityFramework.Functions -DependencyVersion Highest For more information, see: - Document (APIs and examples): https://weblogs.asp.net/Dixin/EntityFramework.Functions - Source code: https://github.com/Dixin/EntityFramework.Functions - Nuget package: https://www.nuget.org/packages/EntityFramework.Functions
A fully tested wrapper class for querying stored procedures.
Client Classes for Proc Proctor
This is a tiny library with which you can use any database stored procedure as like any normal CLR method, even with 'out' parameters!
Small and simple framework for calling stored SQL procedures.
Automagically generate C# database layers for stored procedures
T4 template for use with Storm
Command line runner for use with the Storm library
Sql executor for Storm using Sam Saffron's Dapper
StoredProcedureData contains Data Models for DbWebApi client to receive StoredProcedureResponse.
A simple framework for running sql tests against a temprary localdb instance, optionally deploying a dacpac, using a nice fluent c# api
A project to call stored procedures in a neat way
Helper for runing Stored Procedure against a Postgresql database
An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.
When you call stored procedure with select and output parameters and you don't select on some conditions (for example, you're just returning an error code) — you get a mapping EntityCommandExecutionException. This package fixes this annoying behavior of EF by returning empty data set and letting you read output parameters. Example: Consider you have this sql procedure: CREATE PROCEDURE [dbo].[Foo] @Condition int = NULL, @ResultCode Int = NULL OUTPUT AS BEGIN IF @Condition IS NULL BEGIN SET @ResultCode = 1; -- return 1 if condition = null RETURN; END SELECT 1 as 'One', 2 as 'Two'; -- select otherwise SET @ResultCode = 0; END Calling this procedure in EF: var resultCodeParameter = new ObjectParameter("ResultCode", typeof(int)); var result = db.Foo(null, resultCodeParameter).FirstOrDefault(); var resultCode = resultCodeParameter.Value; will throw an exception: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'xxx.Foo_Result'. A member of the type, 'One', does not have a corresponding column in the data reader with the same name. Calling EntityFix.Load() once on your application start will fix this bug.
SqlQuery library to query SQL Server stored procedures faster, easier and quicker
This package includes dynamic link library(dll) for ado.net operations on your project. It provides executing query, get table data and executing stored procedure query.
Easy call sql stored procedure from Xamarin Form.
High performance ADO.Net wrapper specifically develop to help make life easy working with Microsoft SQL Server stored procedures for .Net projects/Applications. For more detials vitis Git Wiki page: https://github.com/sknath25/StoredProcedurePlus.Net/wiki
Provide a set of tools to work with. Localisation though Json object file, SQL Server Dal through reflection/attribute using stored procedure (Close to Entity but more database flexible).
Data type and method generator for Sql Server stored procedures
Support for store functions (table valued functions, scalar user defined functions and stored procedures) for Entity Framework Classic Code First.
Library for easy calling and getting result of execution of stored procedures.
Simple StoredProcedure Binder in a type safe way. This generates class codes to call stored procedures.
A .Net framework for calling SQL Server stored procedures. The purpose of this framework is to allow stored procedures, their parameters and their return types to be represented in strongly typed .Net classes. These can then be used in conjunction with a SqlConnection, DbConnection or DbContext to execute the stored procedure. This framework can be used with or without the presence of Entity Framework, but a separate dll (Dibware.StoredProcedureFrameworkForEF which is part of this project) is required when using with EF. Requires .net v4.0 Documentation: https://github.com/dibley1973/StoredProcedureFramework/blob/master/UsingTheStoredProcedureFramework.md