.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