.NET Compact Framework 3.5 Data-Driven Applications Build robust and feature-rich mobile data-driven applications with the help of real-world examples Edmund Tan BIRMINGHAM - MUMBAI .NET Compact Framework 3.5 Data-Driven Applications Copyright © 2010 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, Packt Publishing, nor its dealers or distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: April 2010 Production Reference: 1220410 Published by Packt Publishing Ltd. 32 Lincoln Road Olton Birmingham, B27 6PA, UK. ISBN 978-1-849690-10-2 www.packtpub.com Cover Image by Vinayak Chittar (
[email protected]) [ FM- 2 ] Table of Contents Preface Chapter 1: CRMLive.NET: An Overview 1 9 Tomorrow Inc. The mobile sales force application The mobile dashboard application The mobile support case application Data flow in CRMLive.NET Deciding on the type of mobile application Thin clients Thick clients Smart clients Messaging A brief summary Defining the mobile sales force application Capturing lead, opportunity, and customer information 10 10 11 12 12 13 13 14 14 15 15 16 17 Task management Full-text search functionality Integrating with Windows Mobile and the hardware 20 21 22 Data synchronization Dual database support Application maintenance and upgrades 25 25 25 Mobile screen design Creating reusable controls Maintaining global lists Data retrieval and manipulation on the mobile device Data transfer between multiple mobile devices Detect incoming phone calls and SMS Integrating with the Windows Mobile Calendar and Contacts book Data exchange using Bluetooth and IrDA Capturing handwritten input 18 19 19 20 20 23 23 24 24 Table of Contents Defining the mobile dashboard application Using stateless web services as a data source Rendering the dashboard 25 26 27 Defining the mobile support case application Building a messaging backbone with MSMQ Summary 28 29 30 Road show revenue Total monthly sales Sales for last three months Chapter 2: Building the Data Tier Designing the data tier SQL Server CE 3.5 versus Oracle Lite 10g Connecting the Windows Mobile emulator to ActiveSync Setting up SQL Server Compact 3.5 Installing SQL Server CE on the development machine Installing SQL Server CE on the Pocket PC device. Setting up Oracle Lite 10g Installing Oracle Lite 10g on the development machine Installing Oracle Lite 10g on the Pocket PC device Building the data tier Building the CRMLiveFramework project Defining the IDataLibPlugin interface Building the Plugin Manager UI An overview Implementing the PluginCollection class Implementing the PluginManager class Creating the SalesForceApp project Building the ConfigurePlugin form Building the PluginsSetup form Testing what you've built so far Building the databas