MicrosoftSQL Server 2005 compact Edition(SQL Server CE), you can create, manage, and maintain local databases on supported devices. You can also synchronize the local database with the Microsoft SQL Server database to exchange data between devices and servers.
Use. NET Compact framework
Microsoft. NET Compact framework is used to quickly develop applications for devices.Program.. NET Compact framework contains two main components:
Public Language Runtime
The runtime of a common language is an environment. It provides core thread services and memory management to manage application programs.Code. Code designed for runtime is called managed code, while code that does not use Runtime is called unmanaged code or local code. Local applications for smart devices are generated using Microsoft Visual C ++ for devices, while hosted applications use a. netProgramming Language(Including Microsoft Visual Basic and Microsoft Visual C.
. NET Compact framework class library
The. NET Compact framework Class Library provides reusable classes, from user interface development to thread management, to database access. These classes can shorten development time and simplify many common programming tasks.
For database access, the. NET Compact framework includes the system. Data namespace. It enables you to access SQL Server and SQL Server compact edition databases using ADO. net. Since ADO. NET provides consistent access to multiple data sources, developing SQL Server compact edition applications is similar to developing applications using many other database sources. When accessing the SQL Server compact edition database, you usually need to use the system. Data. sqlserverce namespace.
Note:
To develop applications for. NET Compact framework, you must install Microsoft Visual Studio 2003 or Microsoft Visual Studio 2005. In Visual Studio, you can use Microsoft C #, Microsoft Visual Basic, or both to develop applications.
Getting started
The system. Data. sqlserverce namespace provides the functions required when writing. NET applications using SQL Server compact edition.