Lab Sql

So I'm building a windows app, and as a result, I'm going to use SQL Server Compact instead… Read more How Do I Populate A Sql Server Compact Database?

I'm trying to insert a row and get back the new row's identity with something like this: IN… Read more Inserting A Row And Retrieving Identity Of New Row In Sql Server Ce

Sorting Alphanumeric field in SQL CE (Compact Edition) version 3.5 TreeNumber is a nvarchar field w… Read more Sorting Alphanumeric Field In Sql Ce (compact Edition) Version 3.5

How do I deploy SQL CE 4.0 with EF4 to a shared hosting provider for ASP.NET MVC 2.0? I've incl… Read more How To Deploy Sql Ce 4 Ctp To Shared Hosting?

I'm creating an application for a Windows Mobile 6.5 device, part of which is supposed to repli… Read more Unable To Access Database (sql Server Ce / Windows Mobile 6.5)

I've been getting this error when I try and use my model container: No connection string named… Read more Entity Sqlce Can't Find Connection String In App.config File

I am pulling the hair out of my head trying to figure this one out. I can't make Parameterized … Read more Sqlserverce Problem With Parameterized Queries From .net

I have an ASP.NET MVC project that uses a SQL Server Compact database. I have the following connec… Read more Where Is The Sql Server Compact File?

I have a database in SQL Server CE. When connecting several applications of different computers to … Read more How Do I Share A Sql Server Ce Database File (.sdf) For Multiple Processes?

I have some questions about SQL Server Compact Edition. Now we are using SQL Server 2008 and develo… Read more Sql Server 2008 To Sql Server Compact Edition?

Being new to working with Data, I hope I'm asking this properly. How can I select what columns … Read more How Can I Select What Columns Come In From A Dataset Into A Datatable?

I would like use the SqlCeResultSet like this tutorial in Visual Studio 2013. This is the code of … Read more Sql Server Compact Edition Data Access With The Sqlceresultset In Visual Studio 2013

I have following C# code in a console application. Whenever I debug the application and run the que… Read more Why Saving Changes To A Database Fails?

I'm using the async ctp and have a task that runs in the background. It works great but throws… Read more Gracefully Handle Background Task When App Tombstones

I wrote an little app in C# to keep track of customers and jobs but I get an error 'There was… Read more There Was An Error Parsing The Query Sql Server Ce / Vs 2010 Local Database

This is a kind of follow-up to my other question: Delimited string of ids as a field or a separate … Read more Conditional Insert?

Does anyone have a sample code that given the database file displays the names of all the user tabl… Read more Raw C++ Code To Display The Names Of Tables In An Sql Compact Server Using Ole Db

I'm using SQL Server CE as my database with asp.net. I'm querying the database as follows. … Read more How Can I Get Individual Results In Sql Server Ce

Is it possible to attach multiple DBs to SQL CE 3.5 (Compact edition) e.g. MasterData.sdf, Orders.s… Read more Sql Compact 3.5 Attach Multiple Db/ Cross-db Query?

My program has an online and offline mode. Online it connects to a SQL Server instance using the… Read more Select Scope_identity After Insert With Sqlcecommand