Home Page Icon
Home Page
Table of Contents for
Part 2: Working With Data
Close
Part 2: Working With Data
by Yann Duran, Tim Leung
Pro Visual Studio LightSwitch 2011 Development
Title
Contents at a Glance
Contents
About the Authors
About the Technical Reviewers
Acknowledgments
Foreword
Introduction
Understanding the Basics
How This Book Is Structured
Conventions
Comments and Errata
Part 1: LightSwitch Concepts
Chapter 1: Forms Over Data and Beyond
Who Is LightSwitch For?
The 10,000-Foot View
Model-Centric Architecture
Model-View-ViewModel (MVVM)
The LightSwitch Application Lifecycle
Summary
Chapter 2: Working in Visual Studio
Switching to File View
Root Folder Contents
ApplicationDefinition.lsml File
Server Project
ServerGenerated Project
Client Project
ClientGenerated Project
Common Project
SQL Server
Debugging LightSwitch Code
Compacting LS Solutions for Backup
Summary
Part 2: Working With Data
Chapter 3: Working with Data
Understanding Entities and Properties
Attaching to Existing Data
Creating a Table in the Intrinsic Database
Working with LightSwitch Data Types
Ensuring Unique Values
Creating Choice Lists
Setting Relationships
Using Computed Properties
Summary
Chapter 4: Accessing Data from Code
Introducing Data Access
Using LightSwitch Data Access Objects
Working with Screen Data
Working with Change Sets
Working with the Save Pipeline
Managing Transactions in LightSwitch
Understanding Concurrency
Working with User Data
Summary
Chapter 5: Validating Data
Where Is Validation Performed?
Predefined Validation
Custom Validation
The Validation Engine
Accessing Validation Results in Code
Custom Validation Examples
Performing Screen Validation
Validating Deletions
Database Validation
Summary
Chapter 6: Querying Data
Understanding Query Features
Filtering and Sorting Data by Using the Designer
Using LINQ
Where Is the Query Executed?
Exploring Query Examples
Using Advanced Sorting Techniques
Creating User-Defined Global Values
Summary
Part 3: Interacting With Data
Chapter 7: Creating and Using RIA Services
Why Would I Need a RIA Service?
Creating a RIA Service
Writing the RIA Service Code
Using a RIA Service
Summary
Chapter 8: Creating and Using Screens
Designing Screens
User Interface Settings
Writing Screen Code
Working with Built-In Data Controls
Custom Screens and Scenarios
Working with Files
Summary
Chapter 9: Creating and Using Custom Controls
Using Custom Controls vs. Control Extensions
Directly Using Silverlight Controls
Creating a Custom Silverlight Class
Calling Screen Code from a Custom Control
Summary
Chapter 10: Creating and Using Extensions
Understanding the Need for Extensions
Finding Extensions
Installing Extensions
Creating Extensions
Creating the Extension Library Project
Understanding Extensions
Understanding Theme Extensions
Understanding Shell Extensions
Understanding Screen Template Extensions
Understanding Control Extensions
Understanding Business Type Extensions
Understanding Data Source Extensions
Debugging Extensions
Distributing Extensions
Summary
Part 4: Getting Data Out
Chapter 11: Creating and Displaying Reports
Using ASP.NET to Create Reports
Using Microsoft Reporting Services
Linking Reports to LightSwitch
Creating Reports with Microsoft Word
Creating Adobe PDF Documents
Using Other Third-Party Solutions
Summary
Chapter 12: Creating and Sending Emails
Sending Email by Using Server-Side Code
Creating Mail in a Pickup Folder
Sending Mail via Outlook by Using COM Automation
Creating mailto Hyperlinks
Using mailto in a Screen Button
Summary
Part 5: Securing Your Application
Chapter 13: Authenticating Your Users
Choosing an Authentication Method
Using No Authentication
Using Windows Authentication—Allow Any Authenticated Windows User
Using Windows Authentication—Allow Specified Users
Using Forms Authentication
Membership Provider Settings
Summary
Chapter 14: Authorization
Understanding Authorization
Setting Permissions
Specifying the Application Administrator
Creating Roles
Adding Users
Filtering Data Based on User
Creating a Log Out Option
Summary
Chapter 15: Auditing What Your Users Do
Basic Table Properties
The General Approach
The Specific Approach
Summary
Part 6: Deployment
Chapter 16: Deploying Your Application
Deployment Fundamentals
Setting Up Your Web Server
Deployment Wizard
Installing the Packages
Three-Tier Manual Deployment
IIS7 ZIP File Deployment
Deploying Data
Updating an Application
Deploying to Azure
Summary
Chapter 17: When Things Don’t Go Quite Right
Troubleshooting Installations
Troubleshooting the SQL Server
Tracing LightSwitch Applications
SQL Server Connection Problems
Troubleshooting Publishing
Summary
Appendix A: Culture Names
Appendix B: LINQ Query Operators
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Chapter 2: Working in Visual Studio
Next
Next Chapter
Chapter 3: Working with Data
P A R T 2
Working With Data
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset