.NET Compact Framework 3.5 Data-Driven Applications -- Table of Contents -- .NET Compact Framework 3.5 Data-Driven Applications -- Credits -- About the Author -- About the Reviewer -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 9. Globalization -- Supporting double-byte languages -- Supporting Japanese character input in Windows Mobile.

Supporting Unicode at the application level.