Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Add a Table to the LightSwitch Internal Database

You can add tables to the LightSwitch internal database. Conversely, you cannot add tables or other abstractions to external data sources such as a SQL Server database, SharePoint list, or WCF RIA Service by using LightSwitch. For those data sources, LightSwitch generates entities that match the structure of the data source.

For more information, see Data: The Information Behind Your Application.

link to video For a related video demonstration, see How Do I: Define My Data in a LightSwitch Application?.

To add a table to the LightSwitch Internal Database

  1. In Solution Explorer, click the Data Sources node.

  2. On the Project menu, click Add Table.

    A new table is opened in the data designer.

    In Solution Explorer, LightSwitch creates a node that represents the LightSwitch internal database. By default, the name of the node is ApplicationData. The following illustration shows the ApplicationData node in Solution Explorer.

    Intrinsic database
  3. In the Data Designer, at the top of the new table, double-click the name of the table, and then type a new name.

  4. Define the fields of the table. For more information, How to: Define Data Fields in a LightSwitch Database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.