Microsoft Visual Studio LightSwitch Business Application Development -- Table of Contents -- Microsoft Visual Studio LightSwitch Business Application Development -- Credits -- About the Author -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 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 -- 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 -- 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 -- Connecting SQL Server 2005 and above -- Updating the data source -- Connecting to SQL Server 2011 (in CTP1) -- Connecting to SQL Azure -- Connecting to SQL Server 2008 R2 Express -- Connecting to SQL Server Compact -- Connecting to databases on MySQL -- Getting the connector -- Connecting to a database on MySQL -- Accessing data on SharePoint 2010 -- Accessing data from a WCF RIA Service -- Summary -- References -- 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 -- 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 -- Unique Index -- Custom Validation -- Where to write the code -- Custom code -- Test custom code -- 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 -- 6. Querying and Filtering Data -- Querying in LightSwitch -- Querying a Single Entity -- Filtering and sorting the data -- Filtering the data -- Selecting the columns to display -- Sorting the list -- Queries using a parameter -- Querying multiple entities -- AutoCompleteBox to set the parameter value -- Static spans -- Querying a query -- Summary -- References -- 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 -- 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 -- Bug in querying a 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 -- 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 thePackt site -- Reference -- 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.