Performance concerns between DataSet and stored procedure

I have to develop one program that consists data manipulation (retrieve data, update data and new insert data) to multiple tables. Which will be suitable approach and faster in performance using DataSet object and stored procedure 开发者_运维技巧with CURSOR object? Please point me out. Thanks you all!

Data manipulation is typically faster when done in the DB in the stored procedure.

Unless there is a reason you have to do the manipulation within the application, do it on the DB itself.

I sugget to go for ORM aproach like Entety Framework , LINQ to SQL or Nhibernate you both get better performance and greater development speed.