>>>>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.

There has been a lot of coverage of ADO.NET lately in the .NET course I am taking and I don't understand why some people say it's so hard to work with. It seems pretty straightforward, with lots of options if you want to use them.

Don't know diddly about Entity Framework yet, other than that it is supposedly elbowing Linq out of the way within Microsoft.