Download - Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon
![Page 1: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/1.jpg)
Integrating SharePoint
2010/2013 and Visual
Studio LightSwitch
Rob Windsor
@robwindsor
![Page 2: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/2.jpg)
About Me
• Senior SharePoint Architect with Portal Solutions
• Technical Contributor to the Pluralsight On-Demand Library
• Microsoft MVP, MCPD, MCT
• Founder and Past-President of the North Toronto .NET UG
• Co-author of Prof. Visual Basic 2012 and .NET 4.5 (Wrox)
![Page 3: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/3.jpg)
What is Visual Studio LightSwitch?
• Learn more at the LightSwitch Developer Center
• http://msdn.microsoft.com/en-us/lightswitch/default.aspx
The easiest way to create
modern business applications
for the enterprise
![Page 4: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/4.jpg)
Motivation for LightSwitch
• LightSwitch is a development tool that
Is designed to be used by business users
In the same way they are using Excel and Access today
Is designed to be used by developers
Apps can be transitioned to devs if they grow beyond the workgroup
Has built-in “plumbing” to handle common application requirements
Uses the latest Microsoft technologies
HTML5, JavaScript, Silverlight, Entity Framework, WCF, SQL Server
Uses well-known architectural patters
Builds scalable applications
Is extensible
Supports Wizard driven deployment
![Page 5: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/5.jpg)
LightSwitch Simplifies Development
• Data
Multiple sources / kinds (including SharePoint)
Entity model
• Screens
No markup solution
Extensible controls
Extensible layouts
• Rules and validation
Write once, execute everywhere
![Page 6: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/6.jpg)
LightSwitch 2011
![Page 7: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/7.jpg)
LightSwitch 2012
OData OData
![Page 8: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/8.jpg)
LightSwitch 2012 HTML Client Preview 2
OData OData
HTML5/JavaScript
![Page 9: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/9.jpg)
The LightSwitch Development Experience
![Page 10: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/10.jpg)
DEMO Introduction to Visual Studio
LightSwitch
![Page 11: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/11.jpg)
Entities
• Can be local (SQL Server Express) or attached (SQL
Server, SQL Azure, SharePoint, WCF RIA service)
• Can create relationships within and across data sources
• Custom business types
Provide validation and formatting
• Calculated properties
Write code to generate value
• Can validate at the entity or property level
![Page 12: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/12.jpg)
Screens
• Variety of built in screens
New, search, details, editable grid, list and details
• Can use auto-generated screens for adding/editing or
create your own
• Developers can modify screens at design-time and runtime
• Always based on queries
• Generated screens do not expose XAML
You can use Silverlight controls you create yourself
You can add UI elements packaged as extensions
![Page 13: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/13.jpg)
Queries
• LightSwitch creates queries automatically
Select * query is a collection, eg. CustomerCollection
Select where query is a detail, eg. CustomerDetail
• You can edit existing queries
Filter, sort, add parameters
• You can create new queries
• You can base queries on other queries
![Page 14: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/14.jpg)
The LightSwitch Development Experience
![Page 15: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/15.jpg)
DEMO Entities, Screens, Queries,
and Code
![Page 16: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/16.jpg)
Access Control
• Authentication
LightSwitch supports Windows and Forms authentication
• Authorization
Check if the user is allowed to do something
Define permissions and check them in code at entity
and property level
Permissions are granted through administration screens
![Page 17: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/17.jpg)
Access Control
• Permissions are defined by the developer
• The application’s administrator(s) define(s) users and roles
• Permissions are assigned to roles
• Users are assigned to roles
• A user’s effective permissions are the combined
permissions assigned to their roles
![Page 18: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/18.jpg)
Deployment Options
• 2-tier desktop application
Application runs entirely on user’s computer
• 3-tier desktop application
User interface runs on user’s computer
Middle-tier components run on Internet Information
Services (IIS) or Windows Azure
• 3-tier web application
User interface is browser based
Middle-tier components run on IIS or Windows Azure
![Page 19: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/19.jpg)
DEMO Access control and
deployment
![Page 20: Integrating SharePoint 2010, 2013 and Visual Studio Lightswitch by Rob Windsor - SPTechCon](https://reader034.vdocuments.us/reader034/viewer/2022051609/547d4979b37959532b8b5237/html5/thumbnails/20.jpg)
Thank You
• Big thanks to the organizers, sponsors and you for making
this event possible
• Please fill out your evaluation
• Please keep in touch
@robwindsor
msmvps.com/blogs/windsor