SQL Server Ce Database Development with the . Net Compact Framework

Name: SQL Server Ce Database Development with the . Net Compact Framework
Price: 14.61 USD
Availability: InStock
ISBN: 9781590591192

ISBN-10: 1590591194

ISBN-13: 9781590591192

Edition: 2003

Authors: Rob Tiffany

List price: $49.99

This item qualifies for FREE shipping.

30 day, 100% satisfaction guarantee!

Buy new: $37.85

Marketplace

4 new & used from $14.61

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

SQL Server CE Database Development with the .NET Compact Framework is the only book of its kind for developers wishing to examine in detail all aspects of SQL Server CE 2.0 and the .NET Compact Framework, the most significantly updated area of Visual Studio 2003. Featuring in-depth information on SQL Server CE 2.0 and the .NET Compact Framework, this book illustrates how both Visual Basic .NET and C# can be used to build powerful database applications for the Pocket PC. While other .NET Compact Framework books try to broadly cover general programming issues, this book focuses strictly on database application development.

Book details

List price: $49.99
Copyright year: 2003
Publisher: Apress L. P.
Publication date: 9/26/2003
Binding: Paperback
Pages: 488
Size: 7.01" wide x 9.25" long x 0.39" tall
Weight: 2.002



Foreword


About the Author


About the Technical Reviewer


Acknowledgments


Introduction



Getting Started


What This Book Is All About


System Requirements


ActiveSync All Over Again


Smart Device Extensions Walkthrough


Security Considerations


Deployment


Conclusion



ADO.NET


Namespaces


The SqlCeConnection Class


The SqlCeCommand Class


The SqlCeDataReader Class


The SqlCeDataAdapter Class


Conclusion



Query Analyzer


Installation


Overview


The Objects Tab


The SQL Tab


Conclusion



SQL Server CE Data Definition Language


Creating a Database


Compacting a Database


Deleting a Database


Creating a Table


Modifying a Table


Deleting a Table


Creating an Index


Deleting an Index


Conclusion



Metadata


Information Schema


Building a Metadata Viewer


Connection


Tables


Table Constraints


Columns


Indexes


Key Column Usage


Provider Types


Conclusion



Data Manipulation Language


Inserting Data


Retrieving Data


Joining Tables


Filtering Data


Joining Query Results


Grouping Data


Filtering Grouped Data


Sorting Data


Updating Data


Deleting Data


Conclusion



Operator Reference


Arithmetic


Bitwise


Comparison


Logical


Unary



Function Reference


Aggregate Functions


Date/Time Manipulation


Mathematical Functions


String Manipulation


System Functions and Variables



Remote Data Access


RDA Architecture


Security Considerations


Installing the Server Tools


Securing Your Connection


Creating the Field Memo Database


Creating the RDA Client


Conclusion



Replication


Merge Replication Architecture


Creating a Publication


Making the Connection


Creating the Replication Client


Conclusion



The .NET Compact Framework Class Libraries


Microsoft.VisualBasic


Microsoft.VisualBasic.CompilerServices


Microsoft.WindowsCE.Forms


System


System.Collections


System.Collections.Specialized


System.ComponentModel


System.Configuration.Assemblies


System.Data


System.Data.Common


System.Data.SqlClient


System.Data.SqlServerCe


System.Data.SqlTypes


System.Diagnostics


System.Drawing


System.Drawing2D


System.Drawing.Imaging


System.Globalization


System.IO


System.Net


System.Net.Sockets


System.Reflection


System.Resources


System.Runtime.CompilerServices


System.RuntimeInteropServices


System.Security


System.Cryptography.X509Certificates


System.Security.Policy


System.Text


System.Text.RegularExpressions


System.Threading


System.Web.Services


System.Web.Services.Description


System.Web.Services.Protocols


System.Windows.Forms


System.Xml


System.Xml.Schema


System.Xml.Serialization


Index