Questions tagged [sql-server-ce]
3695 questions
1
vote
0 answers
Performance Issue with ATL/OLEDB
I am having a strange performance problem with ATL/OLEDB (C++).
When I iterate over a recordset, I use the MoveNext method to move to the next record. So when I measured the time it takes to execute the MoveNext method, the very last invocation…
rohitsan
- 1,001
- 8
- 31
1
vote
1 answer
Can you create a linked server from SQL Server (any version) to a SQL Server CE (3.5) database?
We've purchased a tool from Redgate called SQL Data Compare. I use it mainly for testing purposes to prove that my application is making the modifications to the database that I think it is, and not making any other changes.
My current application…
Scott Whitlock
- 13,739
- 7
- 65
- 114
1
vote
2 answers
Connect to an older version of SQL Server Compact database without upgrading
I am using VS2013 to connect to a .sdf database file and am getting this error:
The database file has been created by an earlier version of SQL Server
Compact. Please upgrade using SqlCeEngine.Upgrade() method.
Here is my code:
string…
user2985419
- 553
- 3
- 9
- 23
1
vote
1 answer
SqlServerCe does not exist in dll list
I tried to add System.Data.SqlServerCe reference to my winform project but it doesnot exist in my DLL list.
I tried this questions but does not work:
I don't have SqlServerCe assembly?
Cannot find namespace 'System.Data.SqlServerCe'
I have no idea…
HaMeD
- 349
- 1
- 14
1
vote
2 answers
In what format does SqlCeConnection expect its connection string arg?
I have a call to SqlCeConnection.Open() that's failing. The exception message I'm getting is pretty generic: "System.Data.SqlserverCe.SqlCeException" (more generic than pretty)
The pertinent code is:
private DBConnection()
{
try
{
…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
1
vote
0 answers
SqlCeReader hangs when query returns 0 rows
I'm developing for Windows Mobile 6.5, with Sql Compact Edition 3.5 SP2 (3.5.1, aka 3.5.8080.0).
When my query nets > 1 result, reader.Read() returns the expected non-zero value (allowing the while loop to proceed). But if there is no matching…
MattK
- 11
- 2
1
vote
1 answer
SQL Server CE 4.0 - Counting frequency of distinct values in multiple columns
I have a table with 20 columns and each row can have a value of 0-4 (integer) in each column.
I would like to count the number of 0's, the number of 1's, the number of 2's etc in each column for a given subset of the table which is specified in the…
user3259859
- 29
- 6
1
vote
1 answer
C# Entity Framework 6 with SQL Server Compact. AccessViolationException on save changes
Consider this scenario:
The repository:
public void Save(object entity) {
lock (static object) {
context.Add(entity);
context.SaveChanges();
}
}
The application:
//somewhere
new Thread(() =>…
user2957271
- 182
- 3
- 19
1
vote
0 answers
Is there a sleep function when using SQL Compact
I am trying to find a way of putting a pause of a few seconds into SQL being executed against an SQL Compact database.
Is there something equivalent to SQL Server's WAITFOR function?
Iain Hoult
- 3,889
- 5
- 25
- 39
1
vote
5 answers
The data provider required to connect to the local data file could not be found
I am looking to add a local database file (.sdf) into my .NET Project.
I right click on my project, click "Add" -> "New Item"
Select "Local Database" and rename it to what I want.
I click the "Add" button and get the following error
"The data…
Ben
- 3,926
- 12
- 54
- 87
1
vote
0 answers
How to execute .SQL script on SQL Server CE database
I'm trying to find out how to run a script in C# to create tables and data for a SQL Server CE database. I'm getting the following error when ExecutingNonQuery off of command:
There was an error parsing the query. [ Token line number = 1,Token line…
TMan
- 4,044
- 18
- 63
- 117
1
vote
1 answer
Why does __sysChangeTxBsn receive a value with local updates but not remotely?
I have provisioned a SQL Server CE database with Microsoft Sync Framework. When I insert a new record remotely, the __sysChangeTxBsn column remains empty. When I copy the database to my local computer and insert a record locally, the…
Shaun Luttin
- 133,272
- 81
- 405
- 467
1
vote
1 answer
How to change database after altering model in MVC?
I'm new to ASP.NET and I'm working on this project that uses MVC. It's a simple website development project, and it uses SQL Server CE (.sdf) as the database.
I would like to change a couple of the underlying models, but that causes errors in the…
user2902028
- 15
- 5
1
vote
1 answer
Connect to Sql Server Compact Remotely
I have a asp.net mvc with sql Server compact application which hosted in a shared-host, Now my question is: How i can connect to remote Sql ce which hosted in shared-host from my desktop and manage that? or execute entity framework migration…
user197508
- 1,282
- 2
- 18
- 31
1
vote
2 answers
SQL Server Replication Error
I have a SQL Server 2005 box set up for merge replication to SQL Server CE 3.0. The publication, publisher, distributor and IIS have all been set up.
In my application, I attempt to sync the databases using the following code:
//TODO: Change for…
Sesame
- 3,370
- 18
- 50
- 75