SQL Server express and SQL Server compact applications

Ms provides two free versions of SQL Server express and SQL Server compact in the SQL server product family. Users can download, develop, and deploy these two versions for free. Therefore, this is a good choice for database solutions.

 

The purpose of using these two databases

Using SQL Server Express can save costs. Because SQL Server Express is compatible with all functions of SQL Server Standard and SQL Server Enterprise in data processing, such as data storage, log processing, and stored procedures, in terms of development, You can seamlessly upgrade to standard and enterprise versions. It is recommended to use web applications.

 

SQL Server Compact can be applied to mobile devices and desktops for free.ProgramAnd even in Web applications, since SQL Server Compact is an in-process database engine, no additional installation or maintenance is required. The SQL Server compact and Microsoft SQL Server product families share common APIs. In. NET development, you can use the common ADO. Net APIs and support the LINQ and Entity Framework. SQL Server compact does not support stored procedures, but supports a subset of the T-SQL that can replace access in desktop applications to facilitate upgrades to other SQL Server versions.

 

Download and install SQL Server Express

SQL Server express 2005 is a http://www.microsoft.com/express/2005/ SQL /download/default.aspx

The first component is the Database Service (SQL Server 2005 express Edition), The second is the management tool (SQL Server Management studio Express).

Microsoft SQL Server 2005 express Edition

SQL Server Management studio Express

Select the mix authorizaiton mode during installation, so that you can use the SA user to log on during development.

Download and install SQL Server compact

SQL Server Compact comes with Visual Studio. vs2005 comes with SQL Server compact 3.0, while vs2008 comes with SQL Server compact 3.5. At the same time, SQL Server compact 3.5 can be downloaded at the following address, SQL Server compact downloads. SQL Server Compact is an in-process database, so you do not need to install it. You only need to copy it to the target directory.

 

SQL Server Express. Net Development

SQL Server express uses the system. Data. sqlclient namespace to access ado.net, which is no different from standard and enterprise. SQL Server express-based applications can be directly upgraded to standard and enterprise.

 

SQL Server compact. Net Development

SQL Server compact uses system. data. when using the sqlserverce namespace to access ado.net, note that different SQL Server compact versions use unused DLL versions. the SQL Server compact 3.5 library generally corresponds to the following directory c: \ Program Files \ Microsoft SQL Server compact edition \ v3.5 ado.net DLL, the SQL Server compact 3.0 library generally corresponds to the following directory c: \ Program Files \ Microsoft Visual Studio 8 \ smartdevices \ SDK \ SQL Server \ Mobile, which is incompatible with each other.

If you use SQL Server compact to connect to an ASP. NET application, set the sqlservercompacteditionunderwebhosting attribute to true.

 

Appdomain. currentdomain. setdata ( " Sqlservercompacteditionunderwebhosting " , True );

 

Modify the Directory attribute of the database file at the same time. Set IUSR _ * And IWAM _ * to full control.

IUSR _ * (built-in account for anonymous access to Internet Information Services)

IWAM _ * (built-in account for Internet information services to start out of process applications)

 

Have fun with free SQL Server.

References

Microsoft SQL Server compact 3.5 books online and Samples

Compare SQL Server 3.5 compact and SQL Server express edition features