Table of Contents

• Preface

• Chapter 1: Getting Started with Microsoft LightSwitch
• What is Visual Studio LightSwitch and who is the target audience?
• Basic architecture of a VSLS application
• The VSLS designers
• Installing Microsoft LightSwitch
• Installing on Windows 7
• Installation problems and remedies
• Installing on Windows XP
• Installing the databases used in the book
• Downloading the samples
• Installing the databases on SQL Express 2008
• Summary
• References

• Chapter 2: Microsoft LightSwitch IDE and Architecture
• Visual Studio LightSwitch Beta 2 application architecture
• Presentation tier
• Logic tier
• Data Access Service and Data storage
• Business logic
• Hosting Process
• Visual Studio LightSwitch Beta 2 IDE
• The Start page
• The Main menu
• Exploring the LightSwitch Project
• Creating a new project
• Project
• File View of the application
• Summary
• References

• Chapter 3: Accessing Data from a VSLS Application
• WCF RIA service
• Components of a WCF RIA service
• Creating data entities in LightSwitch applications
• Creating a table (or entity) in a LightSwitch application
• Data types in Microsoft LightSwitch
• Salesman table
• Creating data entities using an external data source
• Review of business-related Northwind database tables
• Attaching to external data
• Accessing data on a database
• Accessing data on SharePoint 2010
• Accessing data from a WCF RIA Service
• Summary
• References

• Chapter 4: Screens in VSLS application
• Screens, data, and visual presentation
• Microsoft LightSwitch screens
• New Data Screen
• Creating a screen
• Binding screen to data source
• Screen properties
• Displaying the screen
• Search Data Screen
• Testing the functionality
• Can you add or modify the data in the Search Data Screen?
• List and Details Screen
• Creating a screen from scratch
• Create an unbound Search Data Screen
• Add a group
• Add a data item
• Add an AutoCompleteBox
• Display and test combo-box
• Export to Excel functionality
• Disabling Export to Excel
• Customizing a screen at runtime
• Summary
• References

• Chapter 5: Working with Entities
• Entities in Microsoft LightSwitch
• Entity Designer
• Creating data entities: adding, deleting, and modifying fields
• Choice list
• Setting up a default e-mail domain
• Entering Money field
• Setting up Phone Properties (formatting)
• Adding a computed field
• Computed value using the Edit Method
• Entity field validation
• Built-in validation
• Custom Validation
• How are the code pages organized in the project?
• Relationships between entities in LightSwitch
• Relationships between tables (entities) from an attached source
• What is the workaround?
• How to establish a many-to-many relationship?
• Summary
• References

• Chapter 6: Querying and Filtering Data
• Querying in LightSwitch
• Querying a Single Entity
• Filtering and sorting the data
• Filtering the data
• Sorting the list
• Queries using a parameter
• Querying multiple entities
• AutoCompleteBox to set the parameter value
• Static spans
• Querying a query
• Summary
• References

• Chapter 7: Writing Code in Microsoft LightSwitch
• Getting started with writing code
• Why do you write code?
• Where to write the code?
• How you write code?
• Data Model and Screens in LightSwitch
• Writing and testing code targeting the entity
• Inserting default values in the entity
• Inserting data into an entity by code
• Validating entity
• Writing and testing screen-related code
• Entering default values using code with screens
• Overriding default behavior
• Accessing screen elements
• Writing custom queries using code
• A simple query with code
• Query with selection and sorting
• Query with text search
• Data from related tables
• Finding records by navigation
• Using a query to add data
• Summary
• References

• Chapter 8: Authentication and Authorization in Microsoft LightSwitch
• Authentication schemes
• Access permission
• Permissions with Forms authentication
• Creating screen Permissions with Forms authentication
• Where is the permission saved?
• Permission to a button
• Permission to query
• Permitting a user to run a query
• Permission to a query based on another query
• Permission to Entity
• Permissions with Windows authentication
• LightSwitch Project with Windows Authentication
• User testing the WindowsAuthenticationVB
• Associating Permissions with roles
• Permission elevation of server code
• Elevating the permission example
• User Management
• Summary
• References

• Chapter 9: Deploying LightSwitch Applications
• Publishing and maintaining a two-tier desktop application
• Installing the application
• Running the application
• Adding users
• Publishing updates to the application
• Deploying the application to another computer
• Removing the application
• Publishing to Web
• Where do you publish to?
• Certificate-backed deployment
• Publishing a three-tier application
• Publishing a three-tier application with Forms Authentication
• Displaying the application
• Publishing a three-tier application with Windows Authentication
• Publishing application to Windows Azure
• Creating the application to be deployed to Windows Azure
• Obtaining the subscription to Windows Azure and configuring the hosting site
• Preparing the application for Forms Authentication and deployment to Windows Azure
• Publishing to Windows Azure hosting site
• Creating a package for publication
• Summary
• About using project download from the Packt site
• Reference

• Chapter 10: Troubleshooting, Debugging, Custom Controls, and Extensions
• Troubleshooting
• Debugging LightSwitch applications
• LightSwitch Debug Menu
• Adding custom controls to LightSwitch
• Creating a User Control
• Extensions
• Theme extension using CookBook recipe
• Setting up the right environment
• Creating a theme extension
• Installing the extension
• Using the extension
• Changing the design of the theme
• Summary
• References

• Index