Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-3.5]

74 questions
6
votes
3 answers

SQL Server CE - Unable to insert values in the BIT column

I have created a small table in SQL Server CE 3.5 Following is the table description: ROW_ID NVARCHAR(30), NAME NVARCHAR(30), TEST BIT I am using following query to insert record in the table: insert into EMP(ROW_ID, NAME, TEST) values('123',…
Nilesh Barai
  • 1,312
  • 8
  • 22
  • 48
5
votes
1 answer

Create view in SQL Server CE 3.5

I'm using SQL Server CE as my database. Can I create a view in SQL Server CE 3.5 ? I tried to create but its saying create view statement not supported. In my application I have table called Alarm with 12 columns. But I'm always accessing only three…
Ram
  • 913
  • 5
  • 17
  • 35
5
votes
4 answers

C# program is looking for sql server compact 3.5, but I'm using 4.0

Okay, this one is really puzzling me, and I apologize if the title of the question doesn't accurately describe what my problem is. I have a program made in C#, using Entity Framework and SQL Server CE. I developed it on Windows 7, and it works fine.…
Steven Jeffries
  • 3,522
  • 2
  • 20
  • 35
4
votes
2 answers

Getting Delphi 7 to play with SQL Server Compact 3.5

We have an old application that was written in Delphi 7. It is currently connected to an old Oracle Lite database that is being retired. The powers that be have chosen to move the data to a Microsoft SQL Server Compact database instead. After…
SteveO
  • 45
  • 1
  • 6
3
votes
1 answer

Entity Framework 6 with Sql Server Compact 3.5 SP2?

I have found lots of information about using Entity Framework 6 with Sql CE 4 and on using Entity Framework 4 with both Sql CE 4 and 3.5, but using Entity Framework 6 with Sql CE 3.5 is a different matter. As far as I can tell, CE 3.5 ships with a…
Dave Rael
  • 1,759
  • 2
  • 16
  • 21
3
votes
5 answers

Delete all data from all tables

Is there an elegant way to wipe all data in the database (removing every row from every table) without destroying the architecture and having to remove/read constraints? I could just delete data from each table but this seems tedious. I've seen…
Simon Johnson
  • 97
  • 2
  • 11
3
votes
2 answers

Delete all rows except 1 the most recent

Want to delete all rows from table except 1 that is the most recent. This query works fine with SQL Server 2008 Standard edition: DELETE S1 FROM StateLogs S1, StateLogs S2 WHERE S1.NodeId = S2.NodeId AND S1.NodeId = {0} AND S1.Modified <…
Didar_Uranov
  • 1,230
  • 11
  • 26
3
votes
4 answers

Synchronisation SQL Server Compact 3.5 in C#

In my project, I want to sync SQL Server Compact 3.5 with MSSQL Server 2008. I passed all steps in Visual Studio 2010 like adding New Item >> Local Database Cache >> Configure Data Synchronization etc. The connection was completed successfully. But…
user1372430
2
votes
1 answer

Entity Framework looks for ADO.NET provider SqlServerCe.3.5 instead of 4.0

I am using SQL Server CE 4.0 along with entity framework 6.0. Everythings work fine until I wanted to enable a N-Tier syncing mechanism with a remote database using a WCF service and the Sync Framework 2.1. I followed this tutorial and use the…
Benoit Patra
  • 4,355
  • 5
  • 30
  • 53
2
votes
1 answer

Limiting AutoIncrement to a specific range

I am trying to create an application for work. The app will be used internally and should allow us to assign some barcode numbers to our product SKUs. I am using Visual Studio / Basic 2010 Express to build this as my very limited and beginners…
AlexAshleighBurwood
  • 21
  • 2
2
votes
0 answers

What technology is Microsoft recommending to replace Microsoft Sync Framework?

I have an project where I want to scan data to a table using a handheld device. The device would be docked sending the batch of data to the PC to be processed using ActiveSync or Windows Mobile Device Center. The device in this case runs Windows CE…
Rich Shealer
  • 3,362
  • 1
  • 34
  • 59
1
vote
2 answers

SQL Server CE - Select random rows

How do you select a random rows from a table? For example, if there are 1000 rows in a table matching the criteria that I want, I want to select just 20 random ones. Like TOP, but random. Thanks, and this is for SQL Server CE 3.5!
Meowbits
  • 586
  • 3
  • 9
  • 28
1
vote
1 answer

The type initializer threw an exception

I'm writing an C# app using SQL Server CE. Evrtting works fine to now whem I get this exception: "The type initializer for 'VideoStoreManager.AppData.DataBaseManager' threw an exception." for this line of code:…
vladislavn
  • 388
  • 1
  • 8
  • 20
1
vote
2 answers

count only null values in SqlserverCe3.5

I'm working on asp.net website. I'm not able to count the only null values for particular id from the database Sqlserverce. suppose I have table called Alarm alarmid date 1 12/12/2010 2 Null 3 4/4/2010 5 12/05/2011 6 Null Here I…
Ram
  • 913
  • 5
  • 17
  • 35
1
vote
1 answer

SQL Server Compact Edition 3.5 gives "Multiple-step operation generated errors" error for simple query

I'm using a SQL Server CE database via Microsoft's OLEDB 3.5 SQL CE Driver. Here's my connection string: Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\Users\me\Desktop\test1.sdf This query works fine: SELECT Thing FROM OtherThing WHERE…
Karim
  • 18,347
  • 13
  • 61
  • 70
1
2 3 4 5