Microsoft SharePoint 2010 technology for Developers

1. Microsoft SharePoint 2010 technology for Developers Part II Olaf Feldkamp Microsoft Schweiz GmbH Olaf.Feldkamp@microsoft.com

2. Agenda • Business Connectivity Services • Office Development with Visual Studio 2010 • Open XML SDK 2.0 • Word Automation Services • Ribbon and Dialog Framework • Workflow in SharePoint 2010

3. SharePoint 2010 Sessions at TechDays 2010 SharePoint 2010for Developers I • Line-of-Business Applications with SharePoint and Silverlight • Workflow Development • SharePoint Sandboxed Solutions • Migration/Update to SharePoint 2010 • Microsoft Online Services • What's new in Office Client Sites Composites Communities Insights Content Search Insights Overview SharePoint forInformation Architects SharePoint 2010 for Developers II

4. Business Connectivity Services

5. Business Users – without Code Use out-of-the-box features Customize with SharePoint Designer and InfoPath Application Developers – with Code Build web parts (classic ASP.NET, AJAX, Silverlight), line-of-business data integration, list event handlers, workflows, workflow activities, application pages, content types, … Business Collaboration Applications Operations – Reliability Sandboxed solutions Silverlight user interface (and business logic) SharePoint Composite Solutions

6. Business Connectivity Services (BCS) Office Client SharePoint Server 2010 Office Integration SharePoint Site VSTO Package External List External Business Parts Custom Code Search, Workflow, Web Parts Secure Store Service Business Connectivity Services Business Connectivity Services Cache BCS Client Runtime External Content Types Server Runtime External Data ADO.NET Web ServiceWCF Service .NET AssemblyConnector

7. Development Approaches IT Admin Power User “Live” Connection Import &Configure WSP • No code, configure existing back-end integration end-points • Connect to WCF, ADO.NET and .NET Objects • Simultaneously author thin and rich client UX for External Lists. Create InfoPath Forms WSP/ClickOnce Package • Create custom back-end integration logic using .NET Assemblies • Author thin and rich client UX as SharePoint and VSTO customization projects Developer

8. Business Connectivity Services in Action

9. Business Connectivity Services with SharePoint Designer demo

10. BCS with Visual Studio 2010

11. Office Developmentwith Visual Studio 2010

12. Visual Studio 2010 provides backward-compatible tooling Office 2007 project templates are supported But not Office 2003 Visual Studio 2010 and 2008 work side-by-side All 2007 supported scenarios persist forward to 2010 Improved deployment support in Office 2010 with Visual Studio 2010 Package multiple add-ins deployment now supported Office Primary Interop Assemblies no longer needed Language enhancements C#—Optional Parameters, Named Arguments, Dynamic types VB—Implicit line continuation, Dynamic types, Auto-properties Office Development with Visual Studio 2010

13. Backstage View Group Column Tab FastCommand

14. Reference: officeatwork AGCustomers: various

15. Customizing the Backstage Viewwith Visual Studio 2010 demo

16. Open XML SDK 2.0

17. Programming with Open XML File Container Open XML SDK 2.0 Document Properties Comments Markup Styles Images, sound,video Embedded code Custom XML

18. Open XML SDK 2.0 demo

19. Word Automation Services

20. Word, Excel, Access, and Visio Services

21. The SDK and Word Automation Services are designed to be complimentary SDK for file manipulation Word Automation Services for file conversion/archiving tasks Word Automation Services + Open XML SDK Open XML SDK 2.0 Print Template Docu-ments Data PDF Word Automation Services

22. Combining Open XML and Word Automation Services demo

23. Ribbon andDialog Framework

24. Ribbon, Status Bar and Notification Area Notification Ribbon Status Bar

25. The Dialog Framework

26. Ribbon andDialog Framework demo

27. Workflow in SharePoint 2010

28. Workflow in SharePoint 2010 Custom Non-Declarative Custom Activities Custom Declarative Out-of-Box Customi-zation Out-of-Box Workflows • Import Reusable Workflow • Advanced modeling • Workflow Forms • Handle workflow events • Encapsulate custom code in a new action • Deploy in full or partial trust (as user code) • Start from scratch, from existing, or import from Visio • More types of workflows • Task process framework • Association and initiation settings • Modify logic in SPD • Design forms in InfoPath • Ready to use • Common approval scenarios Increasing Functionality SharePoint Designer Browser Visual Studio

29. Bringing SPD and Visual Studio together Workflow Package Power User Developer Custom Activities

30. Importing a Workflow Package to Visual Studio demo

31. Read/write capabilities with backend systems through Business Connectivity Services Visual Studio 2010 continues to make it easy to build Microsoft Office-based solutions Word Automation Services are the Word conversion and layout engine on the server Especially powerful if combined with Open XML SDK 2.0 The new contextual ribbon is customizable Improved workflow capabilities Summary

32. Thank you for your Attention! • For more Information please contact • Olaf Feldkamp • Development Platform Advisor • Olaf.Feldkamp(at)microsoft.com • Phone (UC): +41 (43) 456 63 87 • Microsoft Schweiz GmbH • Richtistrasse 3 • 8304 Wallisellen