Using stored procedures adds specific setup tasks, which currently are not well supported by tools.
An alternative task is to store the sql statements as strings in app resources (if possible, all db access code
should be encapsulated in a .dll anyway, and this .dll could also contain the sql statements).
An additional advantage is SQL Compact can be used as storage engine.
Advertisements