concept SQL Server Compact Edition in category sql

This is an excerpt from Manning's book SQL Server MVP Deep Dives.
William (Bill) Vaughn is an industry-recognized author, mentor, and subject-matter expert on Visual Studio, SQL Server, Reporting Services, and data access technologies. He’s worked in the computer industry for over 37 years. In 2000, after 14 years at Microsoft, Bill stepped away to work on his books, consulting, mentoring, and independent training seminars. He’s written over a dozen books, including Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker’s Guide to SQL Server Compact Edition. He and Peter Blackburn also wrote the critically acclaimed Hitchhiker’s Guide to SQL Server 2000 Reporting Services.
SQL Server Compact Edition is the smallest member of the SQL Server family and is optimized to be an embedded database for single-user applications running on the Tablet PC, Windows Mobile PDA, and desktop platforms. It’s designed to fit in your pocket with a disk footprint of less than 4 MB.
SQL Server Compact Edition doesn’t run as a Windows service that clients connect to via inter-process communication mechanisms. Instead, when an application wants to access a SQL CE database, it creates an instance of the database engine directly within the application process. Internally the database engine is a set of dynamic link libraries as demonstrated in figure 1.