A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

with SQL Server 200x and, to a lesser extent, SQL Server Compact Edition 3.5. However, your O/RM tool choice might be influenced or even determined by support for one or more of the features in this ...