.NET Compact Framework 3.5 Data Driven Applications


.NET Compact Framework 3.5 Data Driven Applications
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
$9.99
save 67%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
$49.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • Develop data-driven mobile applications from the ground up on top of the Oracle Lite and SQL Server Lite databases
  • Build ergonomic User Interfaces targeting the mobile platform that you can easily adapt for your business applications
  • Optimize performance and security on the mobile platform as well as drawing useful charts and reports using .NET CF's graphics libraries for your data-driven applications
  • Utilize the various tools provided by Microsoft to maintain and fine-tune your enterprise applications with the help of realistic case studies
  • Build three real-world business applications from the ground up with the help of easy-to-understand code snippets to provide practical and hands-on experience

Book Details

Language : English
Paperback : 484 pages [ 235mm x 191mm ]
Release Date : April 2010
ISBN : 1849690103
ISBN 13 : 9781849690102
Author(s) : Edmund Tan
Topics and Technologies : All Books, Application Development, Microsoft Development , Microsoft, .NET


Table of Contents

Preface
Chapter 1: CRMLive.NET: An Overview
Chapter 2: Building the Data Tier
Chapter 3: Building the Mobile Sales Force Module
Chapter 4: Building Search Functionality
Chapter 5: Building Integrated Services
Chapter 6: Data Synchronization
Chapter 7: Optimizing for Performance
Chapter 8: Securing the Application
Chapter 9: Globalization
Chapter 10: Building the Dashboard
Chapter 11: Building the Support Case System
Chapter 12: Testing and Debugging
Chapter 13: Packaging and Deployment
Index
  • Chapter 1: CRMLive.NET: An Overview
    • 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
        • Mobile screen design
        • Creating reusable controls
        • Maintaining global lists
        • Data retrieval and manipulation on the mobile device
        • Data transfer between multiple mobile devices
      • Task management
      • Full-text search functionality
      • Integrating with Windows Mobile and the hardware
        • Detect incoming phone calls and SMS
        • Integrating with the Windows Mobile Calendar and Contacts book
        • Data exchange using Bluetooth and IrDA
        • Capturing handwritten input
      • Data synchronization
      • Dual database support
      • Application maintenance and upgrades
    • Defining the mobile dashboard application
      • Using stateless web services as a data source
      • Rendering the dashboard
        • Road show revenue
        • Total monthly sales
        • Sales for last three months
    • Defining the mobile support case application
      • Building a messaging backbone with MSMQ
      • Summary
  • 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 database plugins
      • Implementing the SQL Server CE Plugin
        • Storing DDL in the resource file
        • Building the plugin class
        • Connecting to SQL Server CE
        • Programmatically creating the SQL Server CE database
        • Testing what you've done so far
      • Browsing the SQL Server CE database with Query Analyzer
        • Retrieving data from SQL Server CE
        • Data manipulation in SQL Server CE
        • Dealing with GUID values in SQL Server CE
      • Implementing the Oracle Lite plugin
        • Storing DDL in the resource file
        • Building the plugin class
        • Connecting to Oracle Lite
        • Programmatically creating the Oracle Lite database
      • Browsing the Oracle Lite database with Msql
        • Retrieving data from Oracle Lite
        • Data manipulation in Oracle Lite
        • Dealing with GUID values in Oracle Lite
    • Summary
  • Chapter 3: Building the Mobile Sales Force Module
    • A brief walkthrough of what you will be building
    • Building a form navigation class
    • Building the main menu
      • Using Main() as the startup object
    • Creating the business objects to encapsulate your DataSets
      • Validating data in your business objects
    • Building the AccountViewer form
      • Data binding .NET controls to your business objects
      • Launching the AccountViewer form
      • Testing the AccountViewer form
    • Building the Tasks list
      • Populating the Tasks Datagrid control
      • Building the TaskDetailViewer form
      • Launching the TaskDetailViewer form
      • Testing the tasks list
    • Handling file attachments
      • Building a file manager class
      • Building the FileUpload user control
      • Building the FileDetailViewer form
      • Testing file upload functionality
    • Custom formatting and display in list controls
      • Building a collection sorter using the IComparer interface
      • Custom formatting and display in the list control
      • Using the History list control
      • Testing the History list control
    • Building the ProductList control
      • Using XML DOM to store and retrieve product selection
      • Using the ProductList control
      • Testing the ProductList control
    • Building a paged listing of accounts
      • Paging in SQL Server CE
      • Paging in Oracle Lite
      • Building a paging user control
      • Creating a context menu for the paging user control
      • Launching the accounts listing page
      • Testing the accounts listing page
    • Summary
  • Chapter 4: Building Search Functionality
    • A brief walk-through of parameterized search
    • Building the parameterized search feature
      • Creating the parameterized search query in SQL Server CE
      • Creating the parameterized search query in Oracle Lite
      • Encapsulating the retrieved Dataset using business objects
      • Building the parameterized search forms
        • Building the search form
        • Building the search results listing form
        • Trying out your code
    • A brief walk-through of full-text search
    • Building the full-text search feature
      • Creating the Keyword Extractor classes
      • A sample keyword extractor—the HTML Keyword Extractor
      • Indexing the file
      • Creating the full-text search query for SQL Server CE
      • Creating the full-text search query for Oracle Lite
      • Encapsulating the retrieved dataset using business objects
      • Creating the full-text search forms
      • Trying out the full-text search
      • Improving the full-text search engine
    • Summary
  • Chapter 5: Building Integrated Services
    • Sending SMS and e-mail from your application
      • Sending SMS and e-mail directly through code
      • Delegating to the default Windows Mobile Compose UI
    • Intercepting incoming SMS
      • Intercepting an SMS message
    • Placing phone calls from your application
    • Detecting incoming phone calls
    • Populating the History tab in the sales force application
      • Creating the data tier functions to insert historical records
      • Encapsulating SMS functionality
      • Encapsulating phone functionality
      • Intercepting incoming SMS messages and phone calls in the background
      • Handling outgoing SMS messages and phone calls
      • Testing your code
    • Synchronizing with Windows Mobile Contacts
    • Synchronizing with Windows Mobile Tasks
    • Sharing an account between two devices
      • Sharing an account between two devices using Infrared (IrDA)
      • Sharing an account between two devices using Bluetooth
    • Capturing handwritten input using the Smart Device Framework
    • Summary
  • Chapter 6: Data Synchronization
    • Overview of the different data synchronization methods available for Microsoft SQL Server CE
      • SQL Remote Data Access (SQLRDA)
      • Merge replication
      • Microsoft Synchronization Services
    • Overview of the different data synchronization methods available for Oracle Lite
      • Oracle Mobile Server
    • A quick comparison between the various Synchronization frameworks
    • Using Microsoft Synchronization Services
      • Setting up Microsoft SQL Server and Microsoft Synchronization Services
      • Creating the CRMLive server tables
      • Creating the WCF service
      • Configuring the WCF service library
        • Setting filters for the Sync
      • Configuring the client project
      • Writing the sync code
      • Conflict resolution
    • Using Oracle Mobile Server
      • Installing Oracle Database Enterprise 11g and Oracle Mobile Server
      • Creating an Oracle Mobile repository
      • Creating the CRMLive server tables
      • Creating a new publication using the Mobile Database Workbench
        • Creating a new mobile project
        • Adding publication items to your project
        • Adding sequence items to your project
        • Adding a publication to your project
      • Publishing the mobile application to the mobile server
      • Setting up application users using the WebToGo portal
      • Registering the mobile device with the mobile server
      • Synchronizing with the mobile server
    • Synchronizing files with the server
    • Creating network-aware synchronization modules
    • Summary
  • Chapter 7: Optimizing for Performance
    • Measuring performance
      • Measuring .NET CF code performance
      • Capturing application performance statistics
    • Optimizing database performance
      • Data caching
      • Using database indexes to boost search performance
      • Other database optimization tips
    • Optimizing data transfer performance
    • Managing better code
      • Managing better strings
      • Managing better Winforms
        • Using BeginUpdate and EndUpdate
        • Using SuspendLayout and ResumeLayout
        • Load and cache forms in the background
      • Managing better XML
        • Using XMLTextReader and XMLTextWriter
        • XML serialization and deserialization thesis
      • Managing better files
    • The .NET Compact Framework garbage collector
    • Summary
  • Chapter 8: Securing the Application
    • Encrypting the database
      • Encrypting the SQL Server CE database
      • Encrypting the Oracle Lite database
    • Authenticating the sales force application
      • Performing one-way encryption using SHA256
      • Writing the code for authentication
      • Loading the login form
    • Encrypting data for inter-device transmission using AES
    • Summary
  • Chapter 9: Globalization
    • Supporting double-byte languages
      • Supporting Japanese character input in Windows Mobile
      • Supporting Unicode at the application level
    • Designing culture-sensitive forms
    • Retrieving culture information
    • Summary
  • Chapter 10: Building the Dashboard
    • An overview of the dashboard
    • Creating the web service
    • Creating the dashboard smart client
      • Connecting to the web service
      • Creating the line chart
      • Creating the round gauge
      • Creating the bar chart
    • Summary
  • Chapter 11: Building the Support Case System
    • Introduction to MSMQ and the support case system
    • Setting up MSMQ on your mobile device
    • Writing your first MSMQ application
    • Setting up MSMQ on your server
      • Creating a queue on the server manually using the computer management panel
    • Sending a message from the server to a remote mobile device
      • Sending data to a remote queue
      • Creating the server-side application
      • Creating the client-side application
    • Sending a message from the mobile device to the server
      • Writing the client-side code
      • Writing the server-side code
    • Summary
  • Chapter 12: Testing and Debugging
    • Overview of Power Toys for .NET CF 3.5
      • Installing Power Toys for .NET CF 3.5
    • Using the Remote Performance Monitor and GC Heap Viewer tool
      • Memory leaks and their causes
      • A sample application with memory leak
      • Using the Remote Performance Monitor tool to view application statistics in real time
      • Using PerfMon to graphically view runtime performance statistics
      • Using the GC Heap Viewer tool to detect memory leaks
      • Resolving the memory leak
    • Using the CLR Profiler tool
      • A sample application with bad performance
      • Launching the application with the CLR Profiler tool
      • Inspecting the Histogram view
      • Inspecting the Allocation Graph
      • Inspecting the Time Line view
      • Inspecting the Call Tree view
    • Using the App Configuration tool
    • Using the ServiceModel Metadata tool
    • Using the Remote Logging Configuration tool
    • Using the Network Log Viewer tool
    • Summary
  • Chapter 13: Packaging and Deployment
    • Deploying your solution as a CAB file
      • Adding the SalesForce application files to your CAB project
      • Configuring other miscellaneous settings
    • Deploying your solution as an MSI file
      • Creating an INI file
      • Creating the custom action DLL
      • Creating the MSI installer project
    • Creating an automated update service
      • Creating the server-side web service
      • Creating the client-side updater tool
    • Summary

Edmund Tan

Edmund Tan is the CTO and co-founder of a leading e-forms and workflows solution vendor based in Singapore. He holds more than 8 years of experience building performance-critical .NET e-forms and workflows solutions for smart devices on top of Oracle and Microsoft SQL Server databases for large companies and governmental institutions located in Singapore.

Edmund is also a regular public speaker in various conferences held in Singapore and Malaysia on the topic of on-the-go BPM (Business Process Management) hosted on smart device technologies.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

.NET Compact Framework 3.5 Data Driven Applications +    Oracle WebCenter 11g PS3 Administration Cookbook =
50% Off
the second eBook
Price for both: $45.60

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Build data-driven mobile applications using .NET CF 3.5 on top of the SQL Server Compact and Oracle Lite databases
  • Explore many advanced features of the platform such as GDI+, marshalling, and so on with the help of real-world case studies
  • Exploit the Smart Device Framework 2.3 (SDF) library to interface with various functions of the mobile device
  • Access device features such as telephony, SMS, email, Address book, Bluetooth, and Infrared technologies using .NET CF
  • Perform data synchronization on SQL Server Lite and Oracle Lite databases
  • Optimize application/database performance and resource utilization for your data-driven applications on .NET CF 3.5 through advanced memory management techniques
  • Take full advantage of the Power Toys for .NET Compact Framework 3.5 to streamline the development and testing processes of your mobile applications
  • Build and integrate powerful search functionality into your enterprise mobile applications
  • Get to know various design patterns that you can use in various real-world business application scenarios

In Detail

The new .NET CF 3.5 framework provides enterprise application developers with a whole arsenal of possibilities at their disposal, but without proper guidance on developing performance-critical enterprise applications, it is easy to make the wrong design and technology decisions.

This book guides you to build each part of a robust enterprise application by illustrating the .NET CF 3.5 framework with the help of real-world business applications. It will not only help you to master basic .NET CF skills, but also outlines the best methods, techniques, and tools available to create high-impact and performance-critical data-driven enterprise mobile applications. It provides a solid set of guidelines to aid .NET CF developers to understand how best to apply the features of the .NET CF 3.5 framework.

The bulk of the book illustrates the basic concepts of .NET Compact 3.5 Framework programming by walking the reader through 3 different kinds of mobile applications:

  • A thick-client mobile sales-force application
  • A thin-client mobile dashboard and reporting application
  • A customer support case management application

Both the SQL Server Lite and Oracle Lite mobile databases are covered in detail, from data access to data synchronization. The book explains how device features such as Bluetooth, SMS, telephony, Infrared, and Windows Contacts can be accessed via .NET CF in a real-world example, namely the mobile sales-force application. It also explains.NET CF's GDI+ features that can be used to create rich charts and reports. You learn to synchronize the mobile application with remote datasources and communicate via web services and WCF services. The book outlines performance optimization and memory management techniques on the mobile platform. It also outlines the tools and techniques available for testing, performance-tuning, deploying and debugging .NET CF enterprise applications (including Power Toys for .NET Compact Framework 3.5 from Microsoft).

This book will teach you to build robust, feature-rich enterprise applications using the .NET Compact Framework 3.5, with the help of an end-to-end real-world example of a mobile sales force application.

Approach

The book walks you through three different real-world mobile applications from head to toe to provide a practical, hands-on experience on how to use .NET CF. It provides you with code snippets (in both VB.NET and C#) from real-world business scenarios. A summary at the end of each chapter explains how these code snippets work together as a part of the larger whole. It also makes use of diagrams to explain core concepts and helps you decide on which design patterns to use in different enterprise application scenarios.

Who this book is for

This book is written for developers who are acquainted with the basics of .NET Compact Framework and want to create enterprise-level mobile applications. It is for developers who have worked with the .NET CF Framework before but would like to learn how to utilize its advanced features and deploy leaner and faster business applications.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software