CodeOnlyStoredProcedures 2.2.0

.NET Framework 4.0
There is a newer version of this package available.
See the version list below for details. 
dotnet add package CodeOnlyStoredProcedures --version 2.2.0
NuGet\Install-Package CodeOnlyStoredProcedures -Version 2.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="CodeOnlyStoredProcedures" Version="2.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add CodeOnlyStoredProcedures --version 2.2.0
#r "nuget: CodeOnlyStoredProcedures, 2.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install CodeOnlyStoredProcedures as a Cake Addin
#addin nuget:?package=CodeOnlyStoredProcedures&version=2.2.0

// Install CodeOnlyStoredProcedures as a Cake Tool
#tool nuget:?package=CodeOnlyStoredProcedures&version=2.2.0

A library for easily calling Stored Procedures in .NET. Works great with Entity Framework Code First models.
Code Only Stored Procedures will not create any Stored Procedures on your database. Instead, its aim is to make it easy to call your existing stored procedures by writing simple code.

Product Compatible and additional computed target framework versions.
.NET Framework net40 is compatible.  net403 was computed.  net45 is compatible.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • .NETFramework 4.0

  • .NETFramework 4.5

    • No dependencies.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on CodeOnlyStoredProcedures:

Package Downloads
ContractOnlyStoredProcedures

Easily call stored procedures by writing an interface that describes their names, inputs, and results. Uses the CodeOnlyStoredProcedures library to acually execute the stored procedures.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.4.0-pre04 13,081 4/27/2017
2.4.0-pre03 875 2/14/2017
2.4.0-pre02 854 1/18/2017
2.4.0-pre01 831 1/1/2017
2.3.0 22,184 10/26/2016
2.3.0-pre06 1,054 10/15/2016
2.3.0-pre05 1,131 10/14/2016
2.3.0-pre04 1,107 9/2/2016
2.3.0-pre03 1,105 8/9/2016
2.3.0-pre02 1,088 8/2/2016
2.3.0-pre01 1,101 8/1/2016
2.2.6 2,441 5/26/2016
2.2.6-pre1 1,179 5/24/2016
2.2.5 1,953 2/25/2016
2.2.5-pre3 1,116 2/20/2016
2.2.5-pre2 1,137 2/15/2016
2.2.5-pre1 1,132 2/15/2016
2.2.5-pre 1,129 2/7/2016
2.2.4 1,387 2/3/2016
2.2.4-pre 1,283 12/5/2015
2.2.3 1,689 8/24/2015
2.2.3-pre1 1,174 8/23/2015
2.2.2 1,566 6/22/2015
2.2.2-pre1 1,146 6/20/2015
2.2.2-pre 1,176 6/20/2015
2.2.1 1,405 5/31/2015
2.2.0 1,383 5/23/2015
2.2.0-pre1 1,194 5/22/2015
2.2.0-pre 1,076 5/16/2015
2.1.0 1,374 5/12/2015
2.1.0-pre1 1,147 5/9/2015
2.1.0-pre 1,011 4/18/2015
2.0.0 1,209 4/12/2015
2.0.0-pre5 1,021 4/10/2015
2.0.0-pre4 1,023 3/30/2015
2.0.0-pre3 934 3/17/2015
2.0.0-pre2 922 3/14/2015
2.0.0-pre1 1,102 11/27/2014
2.0.0-pre 1,026 10/29/2014
1.3.1 1,371 10/23/2014
1.3.1-pre 953 10/18/2014
1.3.0 1,147 10/17/2014
1.3.0-pre-14269-0553 972 9/27/2014
1.2.1 1,261 9/10/2014
1.2.0 1,190 9/9/2014
1.1.0 1,171 8/27/2014
1.1.0-pre-14235-2130 1,019 8/23/2014
1.0.1 1,186 8/18/2014
1.0.0 1,230 6/4/2014
1.0.0-RC-14138-2033 913 5/18/2014
1.0.0-RC-14135-0132 965 5/15/2014
0.6.0-RC-14124-2136 904 5/4/2014
0.5.1-RC-14073-1456 969 3/14/2014
0.5.0-rc-14031-0502 953 1/31/2014
0.4.0-rc-14030-0437 1,138 1/30/2014
0.3.3-rc-14027-0615 971 1/27/2014
0.3.2-rc-14027-0322 1,007 1/27/2014
0.3.1-rc-14025-0559 958 1/25/2014
0.3.1-beta-14025-0557 958 1/25/2014
0.2.1-rc-14024-0611 949 1/24/2014
0.2.1-beta-14024-0547 968 1/24/2014
0.1.1 1,257 1/23/2014
0.0.7 1,182 1/7/2014
0.0.6.1 1,156 1/2/2014
0.0.5 1,139 12/24/2013
0.0.3 1,223 12/9/2013

2.2.0
Added ability to pass Table Valued Parameters in the dynamic syntax, and as a property via WithInput, without decorating the class with the TableValuedParameterAttribute. It will use the class name as the TableName, and dbo as the Schema.
Added ability to return single rows from dynamic stored procedures in one line, so long as the stored procedure returns one or fewer items

2.1.0
Added ability to specify the order in which multiple result sets are returned for hierarchical models.
Added global data transformers, that will be applied for all columns in all stored procedures. These should be specified before any StoredProcedure is created.
Added option to enable numeric conversions for all numeric properties. This should be specified before any StoredProcedure is created.
Fixed bug where System.Single (float in C#) property types could not be returned (it would throw an exception).
Fixed bug where StoredProcedure<dynamic> would not apply any IDataTransformers specified.
Fixed bug where expected columns that don't get returned were throwing an IndexOutOfRangeException instead of a StoredProcedureResultsException
         
2.0.0
Removed dependency on SQL Server for all stored procedures (except those that accept Table Valued Parameters)
Results from the dynamic syntax can now be cast explicitly
Result columns can be marked as optional, so if no value is returned, the execution will not fail.
Stored Procedures can return dynamic (which will be an ExpandoObject, with all colums returned by the stored procedure as properties).
Stored Procedures that return hierarchical objects as multiple result sets can now have their relationships automatically discovered
Performance improvements

1.3.1
Fixed bug where none of the named properties of StoredProcedureParameterAttribute could be set on an object, because they were nullable.
Fixed bug where calling a stored procedure that returns results asynchronously could block the calling thread.

1.3.0
Added StoredProcedure.Execute and StoredProcedure.ExecuteAsync methods to more explicitly control dynamic stored procedures.
Added ability to specify an implementation of an interface, so a StoredProcedure can return an IEnumerable<interface>

1.2.1
Added better exception when a model is missing a public parameterless constructor.

1.2.0
Added a much cleaner syntax for calling stored procedures, by using dynamic objects.

1.1.0
Improved exceptions so that it is easier to determine why the data returned doesn't map to your model correctly.
Now ignores read-only properties, so they don't have to be attributed with [NotMapped]

1.0.1
Fixed bug where calling a stored procedure within a Task that was executing on the SynchronizationContext could cause a deadlock.