Search this Site powered by Google
Home | About Us | Blog | Link to Us | Contact Us  Shop at Our ASP.NET Store!

Powered by ASP.NET

In association with Amazon.com
Store

See larger picture

SQL Server CE Database Development with the .NET Compact Framework
by Rob Tiffany - Apress

List Price: $49.99
Price at Amazon.com: $40.45 (Save 19%)

Buy from Amazon.com

Availability: Usually ships in 24 hours
Shipping rates and policies

  • Average Customer Review: Based on 14 reviews.
  • Amazon.com Sales Rank: 730689


Product 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.


Featured Customer Reviews

Got me Through SQL CE, January 28, 2006
This and another book got me through the limitations of the .net compact framework. This book helped me understand and code my first .Net Compact Framework PDA application. I used it to build an actual application. This is a down-to-earth-make-it-happen book. I hope no one else buys it so that I am one of the few that can use SQL CE effectively!

SQL CE BIBLE, September 12, 2005
SQL CE is a very tough topic with plenty of pitfalls, this is the book you need to navigate the terrain and ship your product on time. Beginner to Advanced, this book covers it all.

Design of a successful mobile system isn't necessary intuitive, this book guides you through various subtle differences in mobile development issues. The deep dive in the replication is very valuable.

A few nuggets and a lot (!) of padding, June 14, 2005
This book is padded with reference materials that you can easily find in SQL's users manual. Huge amounts of space are used to show full source examples (in both C# and VB) of incredibly simple concepts. There is a 45 page chapter on Operator Reference which includes three whole pages on using the plus sign, and another three on the minus sign. Yes SQLCE can do addition and subtraction. Similar excessive detail is given to SQL command syntax (SELECT, INSERT, UPDATE, etc.) and SQL function references.

The first three chapters are essentially how to use Visual Studio, how to use Active Sync, and how to use Query Analyzer. All are covered accurately, but no real insight on any of them.

So 311 pages into the book I finally get to something meaningful, Remote Data Access. Sorry, the chapter walks me, with full page screenshots, through the steps of the wizard to set up RDA. It then gives full source code (in C# and VB) to a simplistic example. Unfortunately, in all of that bulk, there are some important concepts which are essentially lost in the noise, such as why we use uniqueidentifier and timestamp columns.

OK, so maybe the next chapter on Replication will be good. Again, a highly pictoral walk through of the SQL Replication Wizard screens, and another application in full source code (in C# and VB). Oh wait! It's the same application as the previous chapter but with a replication button.

So keep reading there has to be meat here somewhere. Nope, we've hit the Appendix. And somehow we have again found a complete waste of pages. The Appendix contains a class listing of the Compact .NET Framework. I don't understand the point of this at all. It's just a listing of all the objects and their types. No descriptions, no properties, no methods. I don't know what anyone would use this for.

If the source code examples were paraphrased (and provided in full online) and the pointless references were removed, this book would be about 40 pages long. It might be a very good book at that point, although not one worth $49.99.

Great SQLCE Resource, March 25, 2005
This book is a great overview for someone starting SQL Ce development. It is also a great reference book for those familiar with CE development. The book starts by going over some of the basics of SQL CE. Examples are easy to follow and a good foundation for starting development.

I found the chapters on Remote Data Access and Merge Replication the most useful. Detailed setup and installation instruction on what is needed to use either of these technologies. Overall book was an easy read and the examples were very useful providing a great starting point to extend on.

A good reference, December 03, 2004
I found this book to be a valuable reference and the chapters on replication have saved my hours of banging my head on my desk.

What do you get...
- You get the rundown of SQL CE and its limitations.
- Some reference material on the subset you must work in.
- Numerous examples.
- Complete walkthroughs of RDA and Merge replication, including how to secure the data being transfered.

Overall I am happy with the book.
I hope in the next edition it covers some topics like best practices for design, and performance enhancements.


You might also be interested in these items...

Home | About Us | Link to Us | Contact Us
Privacy Statement © 2004-2008 ASPNETWorld.com