SQL Server Compact Edition is a slimmed down version of SQL Server that you can use on Pocket PCs, Smart phones, Tablet PCs, and Desktops. With this book, you will learn how to build applications for resource constrained devices. You�ll discover how the SQL Server Compact Edition database can also be used as an embedded in-proc database for desktop-based applications. You�ll learn how to manage the SQL Server Compact Edition database using SQL Server Management Studio, Visual Studio, and Query Analyzer.

Laptops, Tablet PCs, and mobile devices enable information workers to access enterprise data from remote locations. With the step-by-step exercises provided in this book, you�ll learn how to synchronize data between SQL Server and SQL Server Compact Edition. You�ll also learn Remote Data Access�a lightweight method to exchange data between SQL Server and SQL Server Compact Edition. Also in this book are code samples to help you write database applications for mobile devices and for desktop PCs. Throughout the book you�ll find expert tips for building and deploying enterprise applications.

Understand how to�

Build mobile and desktop applications using SQL Server Compact Edition
Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition
Optimize performance and plan for security
Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer
Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition
Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio
Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition
Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access

Introduction 1

1 Getting Started with SQL Server 2005 Compact Edition 7

2 Platform Support and Installation35

3 Getting to Know the Tools 63

4 Managing the SQL Server 2005 Compact Edition Database 109

5 Defining Database Structure 131

6 Manipulating the Database 175

7 Programming SQL Server 2005 Compact Edition with ADO.NET 205

8 Introducing Native Access 247

9 Using Operators in SQL Server 2005 Compact Edition 279

10 Using the Built-In Functions 295

11 Upgrading from a Previous Version 327

12 Synchronizing Data with Merge Replication 345

13 Synchronizing Data with Remote Data Access 411

14 Securing the SQL Server 2005 Compact Edition Database 459

15 SQL Server 2005 Compact Edition Performance Tuning 505

Index 551

About the Author

Prashant Dhingra

Prashant Dhingra, Lead Program Manager at Microsoft, has been working in the software industry for the past 14 years. He has had a diversified experience working on mobile and embedded device applications to large enterprise applications. Prashant has used database extensively in his career ranging from Multi Terabyte Data warehouses for enterprises to a few MB of compact databases on mobile devices. At Microsoft, Prashant worked as Product Manager for SQL Server Mobile Edition Product from 2004 to 2005. Prashant has also architected one of the world�s largest mobile device implementations. His earlier career includes designing and developing compilers and enterprise applications. Prashant has published articles on MSDN and presented mobile device and database technology at conferences.

Trent Swanson

Trent Swanson, a program manager at Microsoft, is working with partners and customers to design, develop, and deploy solutions on the Windows Mobile Platform. He has gained experience and in-depth knowledge of Microsoft SQL Server Compact Edition by helping customers and partners migrate and design managed as well native mobile applications leveraging SQL Mobile.

"About this title" may belong to another edition of this title.

Store Description

ThriftBooks is a fully independent seller of used books, having sold more than 160 million used and new books since we started in 2003. Each quality used book is sorted, graded, shelved and shipped by hand by our team of dedicated employees in our seven warehouses across the US. We have the best selection of books, in the right condition and format, at everyday low prices. We also have a dedicated, US-based Customer Service team, ranked in the top three by Newsweek for Best Customer Service in 2018 and 2019, so you can shop with confidence. We support and invest in our employees, appreciate and value our customers, and truly believe in the power of the written word to educate, energize, and engage readers of all ages and interests.

Visit Seller's Storefront

Seller's business information

Thrift Books Global LLC
18300 Cascade Ave S, Seattle, WA, 98188, U.S.A.

Sale & Shipping Terms

Terms of Sale

We guarantee each book that we send you. If you have any problems, please contact
our dedicated customer service department. They will do everything possible to
ensure you are happy with your order.

Shipping Terms

All domestic Standard shipments are distributed from our warehouses by OSM, then handed off to the USPS for final delivery.

2-Day Shipping is delivered by FedEx, which does not deliver to PO boxes.

International shipments are tendered to the local postal service in the destination country for final delivery – We do not use courier services for international deliveries.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	4 to 8 business days	4 to 8 business days
First item	US$ 0.00	US$ 0.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.