How to Use a Picker as a Filter in your LightSwitch apps

I’ve gotten more than a few questions over the last couple months on how to do this common pattern for filtering data based on a picker. For instance, I have a table of customers and I want to pick from a list and then pull up their details. Or say I have a list of… Read more

Calling ASP.NET Web API from a LightSwitch Silverlight Client

Before I left for a wonderful vacation camping in Lake Tahoe :) I showed you how you can use Web API with your LightSwitch middle-tier service in order to call stored procedures in your databases. I also showed you how we’ve improved database management in Visual Studio 2013 with the addition of SQL Server Data… Read more

Calling Stored Procs in your LightSwitch Databases using Web API

Last post I showed you a new LightSwitch feature in Visual Studio 2013 Preview that let’s you use SSDT database projects to manage your intrinsic (internal) LightSwitch database. You can use database projects to do all sorts of things to the intrinsic database that aren’t supported via the data designer, like add indexes, write stored… Read more

Adding Stored Procs to your LightSwitch Intrinsic Database

When you build a LightSwitch application the very first question you are asked is whether you want to connect to an existing data source or if you want to create a new one. If you choose to create new, this means that you want to build the data model using the LightSwitch data designer and… Read more

Saving Data Across One-to-One Relationships

I’ve had a couple questions recently on how you could add data to tables that have a one-to-zero-or-one relationship in Visual Studio LightSwitch. Depending on whether the related record is mandatory (required) or not you have a couple different options when inserting data. So in this post I’ll show you a couple different options for… Read more

New LightSwitch VS 2012 “How Do I?” Videos Released!

Check it out! We just released a couple new videos on the LightSwitch Developer Center’s “How Do I?” video section. These videos continue the Visual Studio 2012 series where I walk through the new features available in LightSwitch in VS 2012. How Do I: Perform Automatic Row-Level Filtering of Data? In this video, see how… Read more

LightSwitch Tips & Tricks on Query Performance

LightSwitch allows you to connect to multiple data sources, relate them together, and create screens to edit the data. These data sources can be a variety of databases like SQL Server and SQL Azure, SharePoint, and custom RIA services. With the release of Visual Studio 11 Beta, the next version of LightSwitch also allows you… Read more

Using the Save and Query Pipeline to Flag and Filter Data with LightSwitch in Visual Studio 11

Note: This information applies to LightSwitch in Visual Studio 11 (LightSwitch V2) In business applications sometimes we need to flag records with additional attributes in response to business rules and then consistently filter those flagged records in some way or another throughout the application. For instance we may have critical or historical data that must… Read more

Working with SQL Server LocalDB in LightSwitch Projects in Visual Studio 2012

Note: This article applies to LightSwitch in Visual Studio 2012 (LightSwitch V2) In Visual Studio LightSwitch, when you design your data model through the Data Designer you are either creating new tables or attaching to external data sources. When you create new tables, LightSwitch automatically creates them in the internal database, also known as the… Read more

Using Different Edit Screens Based on Record Types (Table Inheritance)

I had a reader ask a question this week on how to use Visual Studio LightSwitch to open different Edit Detail screens based on the “type” of record. This is a very common thing to do especially for data models that use table inheritance (or sub-tables). For instance say we are building an application for… Read more