You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$10
For Premium members:
About SQLCE a embedded database from Microsoft for Desktop based application,Mobile Device and ASP.Net , its latest feature and how to .
Good news for small application developers, Microsoft released compact version of SQLSERVER (SQLCE 4.0) for desktop ,web as well as for mobiles and recently with rel 4.0 it support ASP.Net.This embedded database format is a huge relief from cumbersome and hectic installation of sql server .Although this was from long back but its reliability and features introduced in 4.0 is awesome. So this post is all about SQLCE , its latest feature and a small how to to end up.
Sql Server Compact Edition (SQLCE) is a embedded database with (1.7 to 2 Mb approx.) for Mobile, Desktop and Asp.Net based projects. Generally the target audience/project for SQLCE are
More detailed information can be found at SQLCE Team Blog
Latest Version: SQLCE 4.0 Download
As of Microsoft, SQL Server Compact 4.0 enables new scenarios and includes a host of new features, including the following:
Make sure that you have downloaded the latest version of SqlCE as mentioned above and installed.
To browse the Database, Right Click on Model.sdf and click Open. Then you will be able to get the table details. To add a new table Right click on Tables and click on Add table. In this case I have created 2 tables as shown in figure.
The System.Data.SqlServerCe namespace is the .NET Compact Framework Data Provider for SQL Server CE. WithSystem.Data.SqlServerCe, you can create and manage SQL Server Mobile databases on a smart device and also establish connections to SQL Server databases.
The following code performs simple Data retrieval from the SDF file based on the sqlcecommand.
Well as of today many of the open source CMS provider such as mojoPortal,umberco adopted the SQLCE as their database for its hassle free deployment. As its recent release 4.0 is ready for ASP.Net LOB applications it will find a place among the low end development.
The sample application stimulates a typical windows based application using sqlCE. This application consist of a wireframe database (model.sdf) which will be used to create other files and based on it the user can insert data and later retrieve it.
Introducing Microsoft SQL Server 2014