[Lazarus] Accessing MS SQLServer database from Lazarus/FPC?

[Inoussa OUEDRAOGO]

2011/1/20 Graeme Geldenhuys <graemeg.lists at gmail.com>

> On 20 January 2011 20:28, Bo Berglund <bo.berglund at gmail.com> wrote:
> >>
> >>Use query.ExecSQL instead of query.Open even in Delphi!
> >
> > Not if the stored procedure returns a recordset....
>
> And with this whole mess I would end by saying:  And that is why you
> will not see me ever use a Stored Procedure! 99.99% of the time they
> contain business logic, which doesn't belong in the data layer of your
> application in any case - you can't unit test that business logic.
>

Why can't that business logic be unit tested ? I did it myself many times.
It results into a more maintenable code(Object Pascal and SQL) and a high
perfoming applications.
Stored Procedures have their uses, just do not abuse them, as with other
technologies/features.

-- 
Inoussa O.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20110121/384dbff6/attachment-0003.html>