Click here to Skip to main content
14,550,658 members

SQL-CE

Great Reads

by Unknown Author
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 Unknown Author
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 Unknown Author
This article deals with performance difference with literal values
by NightWizzard
Handling for hex expressions and the trailing '}'

All Articles

Sort by Score

SQL-CE 

19 Dec 2007
Unknown Author
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.
16 Apr 2009
Unknown Author
How to create a real-world BlackBerry application.
7 Sep 2009
Unknown Author
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.
7 Aug 2012
Unknown Author
This tip demonstrates how table data can be shared in two stored procedures.
24 Jun 2013
Enrique Albert
Azure WebSite and W8 Store App using SQL-CE, Azure SQL, Mobile Services, SignalR, EF, WebAPI and integration to Bing Maps
8 Oct 2015
DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
24 Jun 2012
Patrick Kalkman
A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration
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
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
21 Sep 2009
Unknown Author, Unknown Author
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.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
3 Feb 2009
Unknown Author
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
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!
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008
Unknown Author
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
1 Aug 2008
Unknown Author
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
28 May 2013
Enrique Albert
Patterns and best practices for the desing and development of rich client enterprise applications using WPF, WCF and NHibernate
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
4 Jul 2010
Unknown Author
This code sends automatic SMS to birthday boys/girls :) from phone
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
23 Jan 2005
Unknown Author
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
29 Apr 2009
Unknown Author
How to create Linked servers in a minute in an easy way
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
9 Sep 2011
Unknown Author
User friendly query designer and data manipulation tool for SQL Server CE
9 Nov 2012
Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
14 Aug 2012
Unknown Author
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
20 Apr 2008
Unknown Author
An article on a SQL IDE for different type of RDBMS databases
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
30 May 2012
Unknown Author, Unknown Author
This article describes database communication using a generic Fluent NHibernate implementation.
19 Dec 2012
Enrique Albert
First draft version of the model, repository, and services.
17 Oct 2009
Unknown Author
T-SQL script to generate the document of SQL 2000/2005 database
17 Apr 2005
Unknown Author
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
30 Oct 2009
Unknown Author, Unknown Author
Learn to access data through DataSets and SQLCeResultSets in your Mobile apps.
23 Jan 2014
Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
25 Mar 2008
Unknown Author
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
16 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
7 Sep 2016
Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
17 Mar 2008
Unknown Author
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
16 Feb 2015
DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
2 Oct 2008
Unknown Author
Explaining Database deadlocking to non-technical people
19 Sep 2009
Unknown Author
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
28 May 2009
Unknown Author
How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
22 Aug 2011
Unknown Author
DataBinding in WPF Browser Application using SQL Server Compact
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
19 Sep 2013
Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
9 Nov 2013
Unknown Author
Sample Code First project with SQL CE 4.0 database
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
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.
28 Jul 2009
Unknown Author
How to deliver GPS data asynchronously to the server over the internet without queues.
20 Jul 2009
Md. Marufuzzaman
How many records are there in your database?
3 May 2007
Unknown Author
These articles are on prioritizing and improving query performance in SQL Server.
22 May 2013
Unknown Author
A small .NET class library for maintaining SQL CE database schema written in C#.
11 Aug 2014
Unknown Author
This article explains how you can use ASP.NET (C#) and search for related queries in your Database.
2 Mar 2003
Unknown Author
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
20 Jun 2008
Unknown Author
No need to create web service for SSIS package call
26 Aug 2016
Unknown Author
This article deals with performance difference with literal values
18 Jun 2007
Unknown Author
Using data driven unit tests with SQL Server CE for DotNetNuke private module development.
25 Oct 2004
Unknown Author
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.
14 Dec 2005
Unknown Author
This article shows how to convert a text file to PDF.
8 Jul 2013
JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
14 Oct 2010
Unknown Author
Data Synchronization in SQL Express
15 Mar 2006
Unknown Author
This article describes complex issues about sending emails in .NET 1.1 (such as using a SMTP server that requires authentication).
30 Mar 2008
Unknown Author
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.
11 May 2009
Unknown Author
Native MySql Client not requiring any special driver or library
27 Jul 2009
Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
13 May 2009
Unknown Author
Passing an array as parameter to SQL server Procedure
30 Jun 2004
Unknown Author
Managing large data types on SQL CE databases and the ATL OLE DB Consumer Templates.
25 Jan 2007
Unknown Author
How to decode a URLEncoded URL with T-SQL
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.
11 Jun 2008
Unknown Author
How to handle an array parameter in a Stored Procedure [SQL Server].
26 Apr 2005
Unknown Author
Presents a generic method of saving and reloading the status of a Form's controls using XML.
15 Dec 2007
Unknown Author
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
23 Dec 2007
Unknown Author
How to add a modified on column in SQL Server using triggers.
20 Mar 2010
Unknown Author, Unknown Author, Unknown Author, Unknown Author
A Windows Mobile C# reader for the popular Password Safe archive files.
5 Feb 2009
Unknown Author
Register a reference mobile number, and receive a reference message on SIM change.
19 Jul 2009
Md. Marufuzzaman
Get SQL Table Information
1 Sep 2009
Unknown Author
This article shows how to bind relational data model with object design model
6 Feb 2005
Unknown Author
Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.
31 Jan 2008
Unknown Author
Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database
4 Apr 2007
Unknown Author
Very Lightweight Data Access Layer in C# and .NET 2.0
11 Jan 2009
Unknown Author
Fast and easy to use data access class library.
6 Jul 2005
Unknown Author
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
3 Jul 2011
Unknown Author
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.
12 Nov 2005
Unknown Author
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.
14 Jul 2004
Unknown Author
An article describing the implementing of Custom actions in Pocket PC application Setup packages.
13 Sep 2003
Unknown Author
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
28 Aug 2009
Unknown Author
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
29 Jul 2007
Unknown Author
I tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer to at your convenience.
5 Jan 2009
Unknown Author
This article shows you how you can get your saved data once you closed the Windows mobile emulator.
24 Mar 2008
Unknown Author
Do you want to know what your DB programmers are doing?
24 Apr 2006
Unknown Author
An article on how to configure a SQL Server 2000 and SQL CE on different PPC that syncronize their data with the SQL Server 2000
20 Aug 2008
Shivprasad koirala
Some caching interview questions: Part 1.
29 May 2008
Unknown Author
Simple destination script to use do updates with a sub query.
25 Aug 2009
Unknown Author
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
23 May 2007
Unknown Author
This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.
24 Mar 2009
Shivprasad koirala
4 steps to use readymade DAL component (Data application blocks)
9 Mar 2010
Unknown Author
SQL SERVER – Order of Columns in Update Statement does not matter
10 May 2008
Unknown Author
Article describes how to make backup and recovery plan of MOSS 2007.
17 Dec 2008
Unknown Author
Format Excel Sheet from DTS when Excel is not installed on SQL Server
27 Sep 2009
Unknown Author
Given date ranged data, adjust existing ranges on entry of a new ranged data.
31 Dec 2007
Unknown Author
This generates Basic linq codes just by giving necessary inputs
6 Jan 2008
Unknown Author
An HTML Native web Service on SQL Anywhere Database Server
17 Jun 2007
Unknown Author
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
2 May 2005
Unknown Author
How to write multiple filters on a WHERE clause on a sql sentence
17 Aug 2007
Unknown Author
Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server
1 Oct 2008
Unknown Author
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)
11 Mar 2008
Unknown Author
The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.
12 Dec 2007
Unknown Author
Simple bit of Transact SQL to help locate text in a database using cursors
20 Aug 2007
Unknown Author
Merge Replication using SQL 2000 or 2005 using Compact Framework
28 Apr 2013
JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.