>>>What is the optimum & most secure way to update data from within an application.
>>>some use direct "Update" command, some do it through SQL stored procedure, ...
>>>
>>>The development tools used are VB.NET 2008 and SQL 2005
>>
>>For security you will want to use Stored Procedures - this way you are not exposing your database structure information,
>
>With the Entity framework as far as I understood everything is secure.

I saw a presentation the other day, and was left with a big "So What?". It seems neat and everything, but I really didn't see too many advantages to a traditional ADO.NET approach. Granted, the presentation might not have been that good.