SQL Server 2005 Compact Edition Tutorial CRUD - (Create, Read …

Short Description
Can be run in a Windows, or in a Windows mobile application … For the purposes of simplicity for this tutorial, I gave a password of ‘password’. As you …

Website: www.c-solutions-inc.com | Filesize: 3541kb

Content
SQL Server 2005 Compact Edition
Tutorial:
CRUD - (Create, Read, Update, and Delete)
By: Chris Conley
cconley@c-solutions-inc.com
C Solutions, Inc
www.c-solutions-inc.com
O) (918) 307-0991
Copyright 2007For single tier applications, I love SQL Server Compact Edition 2005. It gives you the
database accessibility of SQL, all while not needing access to a server install of SQL
Server. Over the years Microsoft has offered a number of other ways to work with data
in single tier applications, but none have been nearly as comparable, nor effective for me,
and SQL Server compact edition. To name just a few of these previous data access
modes that were available by Microsoft, XML files, and access databases. Both of these
had their own limitations and frustrations. For XML files, querying them was a pain, not
to mention speed, or lack of security. While Microsoft Access forced you load on the
client computer the Microsoft Jet database. This database system, left a bit to be desired
in the security category as well.
SQL Server Compact Edition 2005 is a great leap forward in single tier applications. In
case you didn’t know, single tier applications are ones where the application interface and
data are on the same computer.
Some of the great leap forwards that SQL Server Compact Edition are:
?? The database files can be encrypted with RSA 128 bit…