This project has moved. For the latest updates, please go here.

DataBooster 1.7

Rating: No reviews yet
Downloads: 341
Change Set: 39110
Released: Jan 12, 2015
Updated: Jan 12, 2015 by AbelCheng
Dev status: Stable Help Icon

Recommended Download

Application DataBooster Library 1.7 for SQL Server + Oracle (use ODP.NET Managed Driver)
application, 30K, uploaded Jan 12, 2015 - 196 downloads

Other Available Downloads

Application DataBooster Library 1.7 for SQL Server + Oracle (use ODP.NET Provider)
application, 29K, uploaded Jan 12, 2015 - 36 downloads
Application DataBooster Library 1.7 for SQL Server + Oracle (use DataDirect Provider)
application, 29K, uploaded Jan 12, 2015 - 32 downloads
Application DataBooster Library 1.7 for SQL Server
application, 25K, uploaded Jan 12, 2015 - 44 downloads
Application Utility Scripts for Oracle
application, 3K, uploaded Jan 12, 2015 - 33 downloads

Release Notes

v1.7
  • New feature - Added a single API ExecuteStoredProcedure, support for dynamic data (JSON). Dynamic StoredProcedure, Dynamic InputParameters, Dynamic OutputParameters, ReturnValue and Dynamic ResultSets (also support data binding). So that you can easily create a thoroughly generic ASP.NET Web API (see example in wikipage).
Any http clients can use Stored Procedure Name or Database Function Name as endpoint (e.g. http://BaseURL/YourStoredProcedureName), put required parameters (name-values) in JSON format request body (Content-Type: "application/json"). The response JSON will have all Result Sets, Output Parameters and Return Value.

The latest binaries releases are available right in Visual Studio NuGet Packages:
Remarks:

All above binaries releases require .NET Framework 4.0 or later.
SQL Server support is always build-in (can't be unplugged).
  1. The first download (DLL) uses ODP.NET Managed Driver to connect Oracle;
  2. The second download (DLL) requires ODP.NET 4 (unmanaged driver) to connect Oracle;
  3. The third download (DLL) also requires DataDirect v3.5 to connect Oracle;
  4. The fourth download (DLL) doesn't support Oracle.

Please download the source code if the provider need to be replaced by others. For example ODP.NET, add reference Oracle.DataAccess.dll and set conditional compilation symbols "ORACLE;ODP_NET" in DataAccess project properties.

The UtilityScripts folder contains a Oracle function which can generate C# class code for the result set (SYS_REFCURSOR) return from a stored procedure, also includes a sample shown how to use it in PL/SQL Developer.

(This was a derivative library of dbParallel project http://dbparallel.codeplex.com originally, so the namespace starts with "DbParallel.DataAccess")

Reviews for this release

No reviews yet for this release.