If your case is the simple Add/Update-ing several rows, the

Updategram give you more simple way. You completely were

out of the SQL code.

SP give you more control under your data inside SQL. If you

also have SPs or

part of your business logic is/will be inside SQL you need

use SPs. Usually we have to use SP with OPENXML.