Click here to Skip to main content
14,978,669 members
Everything / Database Development / SQL Server / SQL Server CE

SQL Server CE

SQL-CE

Great Reads

by Tamer Oz
PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.
by Enrique Albert
Azure WebSite and W8 Store App using SQL-CE, Azure SQL, Mobile Services, SignalR, EF, WebAPI and integration to Bing Maps
by Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
by DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine

Latest Articles

by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
by Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
by Neeraj Prasad Sharma
This article deals with performance difference with literal values
by NightWizzard
Handling for hex expressions and the trailing '}'

All Articles

Sort by Score

SQL Server CE 

Please Sign up or sign in to vote.
7 Sep 2009
Tamer Oz
PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.
Please Sign up or sign in to vote.
19 Dec 2007
Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
Please Sign up or sign in to vote.
8 Oct 2015
DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
Please Sign up or sign in to vote.
16 Apr 2009
MiamiCoder
How to create a real-world BlackBerry application.
Please Sign up or sign in to vote.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Please Sign up or sign in to vote.
28 Apr 2013
JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.
Please Sign up or sign in to vote.
24 Jun 2012
Patrick Kalkman
A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration
Please Sign up or sign in to vote.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
Please Sign up or sign in to vote.
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
Please Sign up or sign in to vote.
21 Sep 2009
Apriorit Inc, Oleksandr Dodatko
This article describes the process of initial configuration and basic work with Palm Web OS on the lower level than it's described in Palm SDK docs.
Please Sign up or sign in to vote.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
Please Sign up or sign in to vote.
3 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
Please Sign up or sign in to vote.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
Please Sign up or sign in to vote.
18 Oct 2013
Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
Please Sign up or sign in to vote.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Please Sign up or sign in to vote.
26 Jun 2008
johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
Please Sign up or sign in to vote.
1 Aug 2008
Jammer
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
Please Sign up or sign in to vote.
13 Jul 2010
Md. Marufuzzaman
Overview of SQL server stored procedure
Please Sign up or sign in to vote.
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
Please Sign up or sign in to vote.
28 May 2013
Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
Please Sign up or sign in to vote.
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
Please Sign up or sign in to vote.
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
Please Sign up or sign in to vote.
4 Jul 2010
Amit Kumar Tiwari
This code sends automatic SMS to birthday boys/girls :) from phone
Please Sign up or sign in to vote.
23 Jan 2005
Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
Please Sign up or sign in to vote.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
Please Sign up or sign in to vote.
9 Nov 2012
Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
Please Sign up or sign in to vote.
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
Please Sign up or sign in to vote.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
Please Sign up or sign in to vote.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
Please Sign up or sign in to vote.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Please Sign up or sign in to vote.
30 May 2012
Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
Please Sign up or sign in to vote.
9 Sep 2011
ray_mayukh
User friendly query designer and data manipulation tool for SQL Server CE
Please Sign up or sign in to vote.
19 Dec 2012
Enrique Albert
First draft version of the model, repository, and services.
Please Sign up or sign in to vote.
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Please Sign up or sign in to vote.
17 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
Please Sign up or sign in to vote.
30 Oct 2009
mstruys, dougturn
Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.
Please Sign up or sign in to vote.
23 Jan 2014
Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
Please Sign up or sign in to vote.
25 Mar 2008
Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
Please Sign up or sign in to vote.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Please Sign up or sign in to vote.
7 Sep 2016
Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
Please Sign up or sign in to vote.
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
Please Sign up or sign in to vote.
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
Please Sign up or sign in to vote.
16 Feb 2015
DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
Please Sign up or sign in to vote.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
Please Sign up or sign in to vote.
28 May 2009
Matt Sollars
How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.
Please Sign up or sign in to vote.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
22 Aug 2011
RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
Please Sign up or sign in to vote.
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers
Please Sign up or sign in to vote.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
Please Sign up or sign in to vote.
9 Nov 2013
Damijan Vodopivec
Sample Code First project with SQL CE 4.0 database
Please Sign up or sign in to vote.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
Please Sign up or sign in to vote.
10 Dec 2007
Le Sourcier
How to use LINQ to SQL
Please Sign up or sign in to vote.
19 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
Please Sign up or sign in to vote.
28 Jul 2009
Slava Khristich
How to deliver GPS data asynchronously to the server over the internet without queues.
Please Sign up or sign in to vote.
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
Please Sign up or sign in to vote.
3 May 2007
Pete O'Hanlon
These articles are on prioritizing and improving query performance in SQL Server.
Please Sign up or sign in to vote.
22 May 2013
Tadeusz Kaliszewski
A small .NET class library for maintaining SQL CE database schema written in C#.
Please Sign up or sign in to vote.
11 Aug 2014
Afzaal Ahmad Zeeshan
This article explains how you can use ASP.NET (C#) and search for related queries in your Database.
Please Sign up or sign in to vote.
2 Mar 2003
CT CHANG
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
Please Sign up or sign in to vote.
20 Jun 2008
JustChiragPatel
No need to create web service for SSIS package call
Please Sign up or sign in to vote.
18 Jun 2007
Bruce Chapman DNN
Using data driven unit tests with SQL Server CE for DotNetNuke private module development.
Please Sign up or sign in to vote.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
Please Sign up or sign in to vote.
25 Oct 2004
Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.
Please Sign up or sign in to vote.
14 Dec 2005
Florence FZ Li
This article shows how to convert a text file to PDF.
Please Sign up or sign in to vote.
8 Jul 2013
JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
Please Sign up or sign in to vote.
14 Oct 2010
Ganesan Krishnan
Data Synchronization in SQL Express
Please Sign up or sign in to vote.
15 Mar 2006
FlorentinB
This article describes complex issues about sending emails in .NET 1.1 (such as using a SMTP server that requires authentication).
Please Sign up or sign in to vote.
30 Mar 2008
r.stropek
software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.
Please Sign up or sign in to vote.
11 May 2009
Ladislav Nevery
Native MySql Client not requiring any special driver or library
Please Sign up or sign in to vote.
27 Jul 2009
Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
Please Sign up or sign in to vote.
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
Please Sign up or sign in to vote.
30 Jun 2004
João Paulo Figueira
Managing large data types on SQL CE databases and the ATL OLE DB Consumer Templates.
Please Sign up or sign in to vote.
31 Jan 2013
Enrique Albert
EF Code First implementation of generic repository and unit of work. With deployment to Azure web sites using SQL Compact.
Please Sign up or sign in to vote.
25 Jan 2007
orinoco77
How to decode a URLEncoded URL with T-SQL
Please Sign up or sign in to vote.
27 Aug 2008
Shivprasad koirala
ASP.NET interview questions: Part 1.
Please Sign up or sign in to vote.
11 Jun 2008
Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
Please Sign up or sign in to vote.
26 Apr 2005
Nick Kopp
Presents a generic method of saving and reloading the status of a Form's controls using XML.
Please Sign up or sign in to vote.
15 Dec 2007
craigd
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
Please Sign up or sign in to vote.
20 Mar 2010
Svante Seleborg, Alphons van der Heijden, Dave Shaw, katakana2
A Windows Mobile C# reader for the popular Password Safe archive files.
Please Sign up or sign in to vote.
5 Feb 2009
Santosh Ingawale
Register a reference mobile number, and receive a reference message on SIM change.
Please Sign up or sign in to vote.
23 Dec 2007
james.wren
How to add a modified on column in SQL Server using triggers.
Please Sign up or sign in to vote.
19 Jul 2009
Md. Marufuzzaman
Get SQL Table Information
Please Sign up or sign in to vote.
1 Sep 2009
NeoPunk
This article shows how to bind relational data model with object design model
Please Sign up or sign in to vote.
6 Feb 2005
João Paulo Figueira
Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.
Please Sign up or sign in to vote.
31 Jan 2008
Muigai Mwaura
Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database
Please Sign up or sign in to vote.
4 Apr 2007
Fitim Skenderi
Very Lightweight Data Access Layer in C# and .NET 2.0
Please Sign up or sign in to vote.
11 Jan 2009
6opuc
Fast and easy to use data access class library.
Please Sign up or sign in to vote.
6 Jul 2005
Vitaly Tomilov
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
Please Sign up or sign in to vote.
3 Jul 2011
Alexander Galkin
Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.
Please Sign up or sign in to vote.
12 Nov 2005
JacobEgholm
This article is about making a package containing a Pocket PC application and a SQL Server CE. The package will be of type MSI. When you click it, it will first install SQL Server CE 2.0 and then it will install the Pocket PC application.
Please Sign up or sign in to vote.
14 Jul 2004
Girish Nurani Sankaranarayanan
An article describing the implementing of Custom actions in Pocket PC application Setup packages.
Please Sign up or sign in to vote.
13 Sep 2003
Garth Tissington
After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain
Please Sign up or sign in to vote.
9 Nov 2012
Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
Please Sign up or sign in to vote.
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
Please Sign up or sign in to vote.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
Please Sign up or sign in to vote.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
Please Sign up or sign in to vote.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Please Sign up or sign in to vote.
30 May 2012
Kieran Maltz, Cayen Systems
This article describes database communication using a generic Fluent NHibernate implementation.
Please Sign up or sign in to vote.
9 Sep 2011
ray_mayukh
User friendly query designer and data manipulation tool for SQL Server CE
Please Sign up or sign in to vote.
19 Dec 2012
Enrique Albert
First draft version of the model, repository, and services.
Please Sign up or sign in to vote.
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Please Sign up or sign in to vote.
17 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
Please Sign up or sign in to vote.
30 Oct 2009
mstruys, dougturn
Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.
Please Sign up or sign in to vote.
23 Jan 2014
Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
Please Sign up or sign in to vote.
25 Mar 2008
Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
Please Sign up or sign in to vote.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Please Sign up or sign in to vote.
7 Sep 2016
Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
Please Sign up or sign in to vote.
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
Please Sign up or sign in to vote.
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
Please Sign up or sign in to vote.
16 Feb 2015
DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
Please Sign up or sign in to vote.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
Please Sign up or sign in to vote.
28 May 2009
Matt Sollars
How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.
Please Sign up or sign in to vote.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
22 Aug 2011
RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
Please Sign up or sign in to vote.
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers