Updating Records in LightSwitch using Stored Procedures

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 deleting records in the table. The problem is, Visual Studio…

5

Executing a Simple Stored Procedure in LightSwitch

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/en-us/library/aa214299(SQL.80).aspx.  This makes them very popular with database administrators. So it…

18