Icon of program: ActiveDB

ActiveDB for Windows

Download now

Used ActiveDB for Windows?

Editors’ Review

Download.com staff
ActiveDB is a utility that enables .NET applications to access SQL Server stored procedures using simple method calls. It generates call stubs for stored procedures, drastically simplifying database integration and parameter handling.

  • Pros

    • Invokes SQL Server stored procedures as standard .NET method calls.
    • Generates stored procedure call stubs automatically.
    • Handles stored procedure parameter types and output parameters correctly.
    • Creates overloaded methods for parameters that utilize default values.
    • Allows data set column reference using auto-generated, matching column names.

  • Cons

    • Functionality appears limited strictly to Microsoft SQL Server.
    • Requires pointing at a development database for stub generation.
    • Version 1 includes only unspecified updates.
Icon of program: ActiveDB

ActiveDB for Windows

Download now

Used ActiveDB for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows XP
  • Windows 2000
Additional Requirements
Windows 2000/XP/2003 Server, Microsoft .NET Framework 2
POPULARITY
Total Downloads
555
Downloads Last Week
13
Report Software

Program available in other languages

Last Updated

Developer’s Description

By mfByte
Invoke Micorosft SQL Server stored procedures as .NET method calls.

With ActiveDB you can access your SQL Server stored procedures from a .NET program with one line of code. It's like having IntelliSense on your database. Just point ActiveDB at your development database and let it generate all the stored procedure call stubs. Then give ActiveDB the actual connection string and invoke the stored procedure as easily as a .NET method: DataSet ds = Northwind. Employee_Sales_by_Country (from, thru); ActiveDB handles all the stored procedure parameters correctly -- their type and if they are an output parameter. It even creates overloaded methods for parameters with default values.

What's more, if your stored procedure returns a data set, with ActiveDB you can reference the columns of the returned data set table using auto-generated column names that are the same as the column names in the SQL query. No more hardcoding column references or using numeric indices into the Columns collection. Version 1 includes unspecified updates.

Download.com
Your review for ActiveDB