ActiveDB answers a basic question:
Why shouldn't a call to a SQL Server stored procedure be as simple
as calling a function in one's code?
The answer to that: it shouldn't.
ActiveDB is a powerful component written for Microsoft Visual Studio
2005 and 2008 that lets the developer invoke Microsoft SQL Server 2000
and 2005 stored procedures as regular .NET method calls.
It only takes five minutes to get up and running. Just point ActiveDB
at your development database and let it generate method stubs for calling
the stored procedures. Then simply specify the connection string to
the actual database you will be accessing and you have all of the stored
procedures at your fingertips through Visual Studio's IntelliSense.
ActiveDB
handles automatically input and output arguments and lets you pass them as native
.NET variables. If a stored procedure returns a data set, you have access to that
data set as the return value of the stored procedure method call
(the stored procedure's return value is also available).
ActiveDB also gives you access to the actual names of the query columns returned
by the stored procedure. No more referencing column properties through numeric
indexes or having to spell the column names exactly right. ActiveDB even
tells you the .NET native type of those columns so you can cast their
values to the appropriate type.
What's more, with ActiveDB, if you change your stored procedure's arguments to
use different types or change the order of the arguments, ActiveDB will let you
pick up those changes at compile time through compiler errors.
No more deployment surprises when someone makes a "small" change
to the stored procedure.
See the kind of code you can write from the samples included with ActiveDB.
C#
VB
ActiveDB was developed through many years of enterprise level database programming.
You can trust it to run your most demanding applications.
|