Attaching to SQL Views

In Visual Studio 2013 Update 2  (as well as Office Developer Tools for Visual Studio 2013 – March 2014 Update) some enhancements are available in the area of attaching to SQL Views.  These enhancements were made based on the feedback we received from the community.  With this update, you can now model the primary key for attached SQL… Read more

Enhancements in Visual Studio 2012 for Sorting Data across Relationships (Michael Simons)

Sorting data across relationships is often required when building applications within LightSwitch.  For example, suppose you are building a LightSwitch application that attaches to the Category and Product tables from the Northwind database. You can probably imagine applications in which you would want to display products and have them sorted by their associated Category’s CategoryName. … Read more

User Defined Relationships within Attached Database Data Sources (Michael Simons)

The first release of Visual Studio LightSwitch (LightSwitch V1) allows users to define relationships between tables within the intrinsic/built-in data source (ApplicationData).  When attaching to existing data sources, LightSwitch will import the relationships defined within the data source.  In addition LightSwitch allows users to define relationships between tables of different data sources, these are called… Read more

Filtering Data using Entity Set Filters (Michael Simons)

It is common for line of business applications to have scenarios which require row level security (RLS). For example a LightSwitch developer creates an application that stores Employee information such as name and address along with a relationship to EmployeeBenefit information such as salary and number of vacation days. All users of the application should… Read more

MSDN Magazine: Securing Access to LightSwitch Applications

Let’s face it: Implementing application security can be daunting. Luckily, Visual Studio LightSwitch makes it easy to manage permissions-based access control in line-of-business (LOB) applications, allowing you to build applications with access-control logic to meet the specific needs of your business. In this month’s issue of MSDN Magazine we’ve got a feature article on LightSwitch… Read more