CodeOnlyStoredProcedures 2.1.0-pre

• .NETFramework 4.0

  • EntityFramework (>= 6.1.3)

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.
         
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.

1.0.0
Added implementation of ToString that will print the stored procedure's schema, name, and parameters.
Significantly improved speed of the code that converts values to enum values.
Added xml comments to all public methods. While not complete documentation, they are a huge first step.