Browse by Tags

Since stored procedures provide benefits over directly using TSQL commands, a lot of database administrators like to completely hide database tables from applications.  Instead, they will expose a View to read data from the table, and then create stored procedures to allow inserting, updating and...

Note: This article applies to LightSwitch in both Visual Studio 2010 and Visual Studio 11. Many existing databases make use of stored procedures (or stored procs). There are advantages that stored procedures have over other types of database interaction as listed in MSDN at http://msdn.microsoft.com...