Working with Data in LightSwitch (Guided Tour)

Applications that you build in Visual Studio LightSwitch 2011 use a "forms over data" model. Forms, which are called screens in smb_current_short, are used to display, enter, or update data that is stored in a database or other data source. In this set of lessons you will learn how to connect to a data source; modify the data types that are used to display data; validate data; define relationships between data sources; and much more.

Note

This lesson builds upon the My First Application project that you created in the Creating Your First LightSwitch application lesson. If it is not already open, open it by pointing to File, and then clicking Open Project

Note

In order to complete the LightSwitch guided tour lessons you must download and install the Northwind sample database. For more information, see Installing the Northwind Sample Database

Lessons

Title

Description

Connecting to Data

Shows you how to connect to a SQL Server database.

Customizing Entity Fields

Shows you how to display data in a format different from its storage type.

Presenting a List of Choices

Demonstrates how to create a fixed list of values for a data field.

Adding Validation

Shows you how to validate data that the user enters.

Adding Computed Properties

Shows you how to create calculated values.

Defining Relationships

Shows you how to define relationships between data in different data sources.

See Also

Concepts

LightSwitch Guided Tour

Other Resources

Data: The Information Behind Your Application