Found 21 packages
Dapper extension to use user defined parameter (Table Valued Parameter) in Dapper.
Support for store functions (table valued functions, scalar user defined functions and stored procedures) for Entity Framework 6.3.0+ Code First.
ToDataTable is a pair of .Net Core extension methods that allow you to create a .Net DataTable (or a SQL Server Table-Valued Parameter) from a collection of objects.
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
Open-source Excel add-in in C#/.NET4.0 that makes matrix, vector and most importantly, table-valued functions of Finaquant Calcs available for Excel users and programmers. Based on ExcelDNA and NetOffice
NHibernate plugin to support MSSQL Table-Valued Functions in LINQ-Queries
Support for store functions (table valued functions, scalar user defined functions and stored procedures) for Entity Framework Classic Code First.
SQL Server provider for FluidDbClient. This library also makes working with Table Valued Parameters a snap.
A set of extensions to Dapper, specifically for Microsoft SQL Server * TableValuedParameter<T> * ExecuteWithIdentity
Finaquant Calcs is a commercial .NET library with (1) table-valued functions (Table Functions) and (2) Calculation Nodes and Networks (Calculation Engine). This free 30-day evaluation version comes with restricted table size (max 5000 rows). You may buy a permanent license with unlimited table size.
Finaquant Protos is a non-commercial and free .NET library with table-valued functions (Table Functions). This .NET library can only be used for non-commercial purposes like education and science. Please see Finaquant Calcs with additional features and unlimited table size for commercial use.
A forked version of PetaPoco http://www.toptensoftware.com/petapoco/ - Based on v5 branch. Supports Async and Multipoco operations. Includes support for StoredProc extensions and XML and Table-Valued Parameter queries.
Easy Table Valued Parameter - Easy one to many insert/update/delete.
Little ORM which provide the LINQ queries to unknown sources(views, tables, stored procedures, table-valued functions) at compilation time 🤘
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.
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.
ORM for SQL Server, with support for table valued parameters, multiple resultsets, etc. Full async support!
ADO.NET Micro-ORM to SQL Server, implemented as .NET Standard 2.1 (since version 3.5.x) or a .Net Core 6.0 library (since version 3.0.0). Use version 2.x.x, which was built with Net Standard 2.0, if you want to utilise this library with the .Net Framework or a previous version of .NET Core. This library is designed to use stored procedures, table-valued parameters and structured static mappers, with the goal of reading and saving of complex object graphs at once in the fast, convinient and efficient way. Read more: https://www.codeproject.com/articles/1155836/artisan-orm-or-how-to-reinvent-the-wheel
Makes it easy to get query from dapper, especially with table valued parameters (TSQL only)
A simple wrapper for IDbConnection that allows logging SQL statements and works easily with Dapper or anything where you can pass the IDbConnection you want to use. It has support for Stored Procedures, Functions, and Table-Valued Functions and formats the logs such that they can be directly run in SSMS which is extremely useful for debugging.