PRODUCT SUPPORT ANNOUNCEMENT
See the latest about COVID-19 shipping availability and video/Web Edition load errors. Learn more.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF The popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Microsoft® Visual Studio® LightSwitch® Unleashed
Alessandro Del Sole
Microsoft Visual Studio LightSwitch represents a breakthrough in business application development for Windows clients, the Web, and the cloud. Using this new tool, you can build powerful data-centric applications with far less code than ever before. Microsoft Visual Studio LightSwitch Unleashed is the first comprehensive, start-to-finish guide to this powerful new tool. Written by longtime Visual Basic expert and Microsoft MVP Alessandro Del Sole, this book covers everything Microsoft developers need to know to make the most of LightSwitch–from the absolute basics to the most advanced enterprise techniques.
You learn how to use LightSwitch to build modern, scalable, customized line-of-business applications that automatically leverage technologies such as Silverlight, WCF, and SQL Server Express with no effort or expertise on your part. Through hands-on examples, Del Sole guides you through building solutions that can integrate and analyze business information from virtually any source, crafting custom logic that solves your company’s unique problems, and delivering state-of-the-art usability through professional-quality user interfaces.
Category: Microsoft Programming
User Level: Intermediate—Advanced
ON THE WEB:
Download all examples and source code presented in this book as they are available from informit.com/title/9780672335532
Part I Building Applications with LightSwitch
Chapter 1 Introducing Visual Studio LightSwitch 1
Who Uses LightSwitch?
A Short History of Microsoft Business Tools
Microsoft Access with Visual Basic for Applications
Microsoft Visual Basic 6
Microsoft Visual FoxPro
Microsoft Visual StudioNET (2002 to 2010)
About Visual Studio LightSwitch.
Technologies Used Behind the Scenes
Companion Source Code
Setting Up the Development Machine
Controls and Toolkits.
What You Need to Know About Programming
Chapter 2 Exploring the IDE
Getting Started with Visual Studio LightSwitch
Introducing the Start Page
Creating New Projects and Exploring Solutions
The LightSwitch Designer
The Entity Designer
The Screen Designer
The Properties Window
The Query Designer
The Application Designer
The Code Editor.
Building, Running, and Debugging Applications.
Managing and Arranging Windows
Visual Studio 2010 with LightSwitch
Chapter 3 Building Data-Centric Applications
Creating a New Application
Creating a New Data Source.
Adding Entity Properties.
Building a Complete Entity.
The User Interface: Implementing Screens
Creating a Data Entry Screen.
Creating a Search Screen.
Testing the Application on the Development Machine
Starting the Application as a Desktop Client
Adding and Editing Data
Displaying and Searching Data
Exporting Data to Microsoft Excel
Basic Screen Customizations.
Running the Application as a 3-Tier Desktop Client
Running the Application in the Web Browser.
Required Fields Validation
Default Validation of Business Types
Validating Email Addresses.
Validating Phone Numbers
Chapter 4 Building More-Complex Applications with Relationships and Details Screens
Creating a New LightSwitch Project
Designing Complex Data Sources.
Entities That Define Choice Lists.
Working with the Money Data Type
Using Computed Properties
More-Complex, Business-Oriented User Interfaces.
Creating Data Entry Screens
Creating Search Screens
Running the Application and Entering Data.
Editing Data with Editable Grids
Handling Master-Details Relationships with Details Screens
Editing the Screen Navigation Control
Customizing the Look and Feel of Screens
Implementing Data Validation.
Validation on Master-Details Relationships
Part II Manipulating Data
Chapter 5 Customizing Data Validation
Understanding the Validation Model
Built-In Validation Rules
Writing Custom Validation Rules
Client Validation: Validating Entity Properties
Client and Server Validation: Validating a Single Entity.
Data Validation on the Server: Validating Entity Collections
Validation in Master-Details Relationships
For the Experts: Implementing Complex Validation Rules with theNET Framework
Chapter 6 Querying, Filtering, and Sorting Data
Querying Data in LightSwitch
Applying Filters at the Data Level
Understanding the Query Event Model
Applying Filters at the Screen Level
Applying Sorting Logic
Sorting at the Data Level.
Sorting at the Screen Level
Basing Queries on Other Queries.
Chapter 7 Customizing Applications with Buttons, COM Automation, and Extensions
Customizing the Command Bars.
Adding Built-In Buttons to the Screen Command Bar
Adding and Managing Custom Buttons
Handling More-Complex Scenarios with COM Interoperability
Downloading, Installing, and Using Extensions
Extensions Types in Visual Studio LightSwitch.
Downloading and Installing Extensions.
Chapter 8 Aggregating Data from Different Data Sources
Connecting to SQL Server Databases.
Installing the Sample Northwind Database.
Creating New Applications on Existing SQL Server Databases.
Aggregating Data from Existing Databases into LightSwitch Applications
Database in the Cloud: Connecting to SQL Azure
Establishing Connections to SQL Azure
Creating a SQL Azure Database
Connecting LightSwitch Applications to SQL Azure.
Collaboration: Working with Lists from SharePoint 2010
Running the Default Website
Configuring a Vacation Plan Calendar on SharePoint 2010
Extending LightSwitch Applications with SharePoint Data.
Part III Securing and Deploying Applications
Chapter 9 Implementing Authentication and Authorization
Implementing Windows Authentication.
Setting Up the Development Environment.
Authorization: Settings Permissions
Writing the Permission Logic
Permission Logic on Entities.
Permission Logic on the User Interface.
Debugging the Application.
Creating User Roles and Administering the Application
Implementing Forms Authentication
Publishing Applications with Forms Authentication
Testing the Application with Different Credentials
Permission Elevation on Server Code
Chapter 10 Deploying LightSwitch Applications
Understanding 2-Tier and 3-Tier Applications.
Preparing the Application for Deployment.
Specifying the Application Name and Logo.
Styling the Application
Localizing an Application.
Deploying 2-Tier Applications
Application Server Configuration
Specifying a Certificate
Publishing and Deploying the Application.
Deploying 3-Tier Applications
Configuring the Target Web Server
Publishing the Application
Remotely Publishing to a Web Server
Creating and Importing Packages into IIS
Deploying to Windows Azure
Preparing Applications to Deployment
Part IV Advanced LightSwitch
Chapter 11 Handling Events in Code
Working with Entities in Code.
Understanding Data Objects
Handling Data Events in Code
Handling Custom Query Events in Code
Handling Screen Events in Code
Launching Screens Programmatically
Opening Screens Without Passing Parameters
Opening Screens by Passing Parameters
Chapter 12 Dissecting a LightSwitch Application
Applications Architecture and Tiers
Understanding the Data Access and Storage Tiers
Understanding the Logic Tier.
Understanding the Presentation Tier
Dissecting LightSwitch Projects.
Overview of LightSwitch Solutions
Chapter 13 Advanced LightSwitch with Visual Studio 2010
Managing the Application Life Cycle with TFS 2010.
Connecting to Team Foundation Server.
Creating New Team Projects
Submitting Projects to Source Control.
Creating and Assigning Work Items
Retrieving Specific Project Versions with Version Control
Unit Testing Your Helper Code
Creating a Test Project
Creating Unit Tests
Analyzing the Execution Flow with IntelliTrace
IntelliTrace in Action with LightSwitch
IntelliTrace Log Files
Chapter 14 Debugging LightSwitch Applications
The Error List Tool Window.
Breakpoints and Data Tips.
Debugging in Steps
About Runtime Errors.
The Edit and Continue Feature
Advanced Debugging Instrumentation
Breakpoints and Trace Points Unleashed.
Showing a Variables Value in the Locals Window.
Evaluating Expressions in the Command Window
Understanding the Method Calls Flow in the Call Stack Window
Analyzing Threads with the Threads Window.
Understanding Debugger Visualizers
Debugging in Code.
The Debug Class.
Using Debugger Attributes in Code.
Part V Extensibility
Chapter 15 Customizing the IDE
Customizing Visual Studio LightSwitch
Customizing Commands and Toolbars
Customizing an Existing Toolbar
Creating a New Custom Toolbar.
Managing User Settings
Using, Creating, and Managing Reusable Code Snippets
Using Code Snippets
The Code Snippet Manager
Creating and Using Custom Code Snippets
Chapter 16 Customizing Applications with Custom Controls
Building Custom Controls
Creating Controls with Visual Studio 2010
Implementing and Aggregating Chart Controls.
Binding the User Control to Data and the Screen
Integrating Bing Maps
Claiming Your Bing Maps Developer Keys.
Making Bing Maps Available to LightSwitch
Updating Entities to Support Bing Maps
Adding Bing Maps to Screens.
Chapter 17 Implementing Printing and Reporting
Using the Office Integration Extension
Overview of the Class Library
Creating Emails and Appointments with
Exporting to Microsoft Word and to PDF
Importing and Exporting Data with
Microsoft Excel 2010
Using SQL Server Reporting Services
Reporting Extensions from Microsoft Partners
XtraReports from Developer Express
NetAdvantage for LightSwitch from Infragistics
OLAP Extension from Component One.
Telerik Reporting for Silverlight.
Using Custom Controls for Printing and Reporting
Creating a Visual Report as a User Control
Displaying the Report in the User Interface
Silverlight’s Printing APIs
Chapter 18 LightSwitch Extensibility: Themes, Shells, Controls, and Screens
Understanding the Extensibility Model
Creating a New Extensibility Project
Setting Extension Properties
Adding a Theme to the Extensibility Project.
Editing Themes with Visual Studio 2010.
Editing Themes with Expression Blend 4
Making the Green Theme
Testing the Custom Theme.
Creating Custom Shells
Creating Extensibility Projects for Custom Shells
Editing the Official Sample from Microsoft
Sharing Custom Controls.
Available Control Types
Creating Control Extensions.
Creating Screen Templates
Designing Custom Screen Templates
Implementing the IScreenTemplate Properties
Generating the Screen Content Tree.
Adding Code to the Screen.
Testing the Screen Template
Screen Templates Tips and Tricks
Chapter 19 LightSwitch Extensibility: Data and Extension Deployment
Creating Business Types.
Implementing a New Business Type
Implementing the Data Type Definition
Implementing Data Validation.
Testing the Extension
Creating and Using Custom Data Sources with WCF RIA Services
TheNET Framework for WCF RIA Services
Creating WCF RIA Services to Work with XML Data
Calling WCF RIA Services from LightSwitch Applications
Calling Stored Procedures Through WCF RIA Services
Sharing Custom Data Sources
Testing Custom Data Sources
Handling Connection Strings
Deploying Extensions to Others.
Preparing the Deployment Manifest.
Uploading VSIX Packages to the Visual Studio Gallery
Releasing Extension Updates
Appendix A Installing and Configuring Visual Studio LightSwitch
Installing Visual Studio LightSwitch
Managing the Offline Documentation
Appendix B Useful Resources
LightSwitch Developer Center.
LightSwitch How-Do-I Videos
Training Kit and Starter Kits
The Visual Studio Gallery.
Visual Studio LightSwitch Help Website.
LightSwitch Video Training on MyVBProf.com
Italian LightSwitch Tips & Tricks Community.
Other LightSwitch Blogs and Websites.
Document Toolkit for LightSwitch.
RSSBus Data Providers
Infragistics NetAdvantage Light Edition
9780672335532 TOC 1/26/2012