12 packages tagged with “StoredProcedures”
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
Access Stored Procedures with Code First. Includes support for Input and Output parameters, multiple result sets and Table-valued parameters. V2.1 updates the Table-valued parameter support to a much simpler POCO model, more in keeping with the spirit of Code First / Entity Framework 4.1 V2.2 updates the Dll to work with Entity Framework v.4.3.1 V2.5 updates the Dll for Entity Framework 5 v2.6 updates the Dll for Entity Framework 6; adds Command Timeout optional parameter for long running procs. v3.0 revamp of the interface, add support for Async, Streaming v3.2 fix a issue with Async procedure calls v3.3 internal changes to support Glimpse.EF6 v3.4 fix improper null handling in output parameters v3.5 fix dll version number v3.6 Don't send a parameter for null or empty (zero row count) Table Valued Parameter. Fixes error for empty or null TVP's. v3.7 Bug fix and a bit of code refactoring. v3.8 allow ordinal values instead of names for return value column assignment to properties v3.9 Bug fixes! Connections passed in are no longer inadvertently closed.
Access Stored Procedures with Entity Framework Core
A library for executing dynamic queries and stored procedures with flexible filters.
The VersaTul Data Sql project provides the ability to quickly create database access objects, usable on any suppporting SQL databases. This project is built on top of the System.Data.Common namespace and provides the functionality to quickly call stored procedures or plain text sql queries, then map the result into data objects using the provided helper methods.
The VersaTul Data MsSql project provides the ability to quickly create database access objects, usable on Microsoft SQL Server databases. This project is built on top of a combination of System.Data.Common and System.Data.SqlClient namespaces. These are used to provide the functionality to quickly call stored procedures or plain text sql queries, and map the result into data objects using the provided helper methods. The project also provides MsSql Bulk Copy functionality, which can be use to bulk insert data into a MsSQL Server databases.
OracleEFTools is a .NET library designed to simplify access to Oracle stored procedures from Entity Framework Core (EF Core). This tool provides a streamlined way to interact with Oracle databases, making it easier to work with complex stored procedures and integrate them into your EF Core workflow. Features Simplify the process of calling Oracle stored procedures from your EF Core application. Automatically handles input and output parameters. Fully supports asynchronous operations.
Fork of EntityFramework.Functions library - implements Entity Framework code first support for stored procedures, table-valued functions, scalar-valued functions (composable or non-composable), aggregate functions, built-in functions, and niladic function.
MySqlOptimizer v2.0.0 is a C# library designed to simplify MySQL database operations with advanced features like async support, transactions, bulk insert, and stored procedure output handling.
A data access library for simplified database operations. It provides a simple API for executing SQL queries, handling stored procedures, and managing caching strategies for optimal performance.