O'Reilly logo

Windows® Phone 8 Unleashed by Daniel Vaughan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Compact

The database used on the phone is based on SQL Server Compact Edition (SQL CE). SQL CE shares a common API with the other Microsoft SQL Server editions. Each SQL CE database resides in a single .sdf file, which can be up to 4GB in size. The .sdf file can be encrypted, using a password, with 128-bit encryption for data security.

Note

On Windows Phone, the database filename is required to use the .sdf file extension. A NotSupportedException is raised if you attempt to create a database with a name not ending in .sdf.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required