Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-3.5]

74 questions
1
vote
1 answer

How can I connect to a SQL Server Compact 3.5 file as a data source in Visual Studio 2012?

Visual Studio 2012 comes with SQL Server Compact 4.0. I have installed SQL Server Compact 3.5 from http://www.microsoft.com/en-GB/download/confirmation.aspx?id=5783 However I still only have the option of making a new data connection to a SQL Server…
dumbledad
  • 16,305
  • 23
  • 120
  • 273
1
vote
1 answer

Windows CE 6.0 SQL Server Compact 3.5

I would like to programatically create a database under Windows CE 6.0. It should use SQL Server Compact 3.5. The problem is, that I don't know how to start here. I cannot find proper examples of creating and managing SQL Server database under…
Mariusz
  • 143
  • 1
  • 13
0
votes
2 answers

How to save decimals in SQL Server Compact Edition?

decimal is a .NET (also other frameworks, rdbms and languages) value type that stores floating point numbers with decimal precision, instead of a binary one. Is there any way of saving these values to a SQL CE database without using binary precision…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
0
votes
1 answer

Unable to persist Entities to SQL CE using entity framework

I am stating out with entity framework. I have created my ADO.NET Entity Model and mapped the entities to a local SQL CE database file (all done via the wizards). I have created a unit test to test the data access and see how things work. The test…
Renier
  • 480
  • 5
  • 13
0
votes
1 answer

Visual Studio 2008 SP1 assembly reference confusion

I am using Visual Studio 2008 SP1 on Windows XP SP3 to develop some .NET Compact Framework 3.5 SP1 solution for Windows CE 6. I want to use SQL Server Compact 3.5 SP2 in my solution, however I notice something very strange with how Visual Studio…
Kal
  • 1,707
  • 15
  • 29
0
votes
1 answer

Entity Framework 4.1 and Pre-Generating Views

I implemented the suggestion in this how to article from msdn, and my first initial entity framework query is still taking 3-4 seconds. The same query comes back instantly with a SqlCommand. Does pre-generating views work with entity framework…
mservidio
  • 12,817
  • 9
  • 58
  • 84
0
votes
1 answer

ADO.NET is looking for a DbProvider which I don't want to use

I have a project using SqlServerCe.3.5 with EntityFramework 6. I want to change the database to PostgreSQL so I changed the configuration From:
doodoroma
  • 157
  • 2
  • 11
0
votes
1 answer

How to package .sdf Database Application on CD and run without installing on machines

I am having a challenge that is specifically unique to me. I have browse the questions and answers catalog and what i found does not specifically address my scenario. I created Windows Application on C#.Net with SQL Server CE at the back-end. I…
goddy
  • 1
0
votes
1 answer

Storing a json string that is 10 kb in size in a SQL Server CE cell

I have a SQL Server CE database in which I have column that takes values of json strings. These json strings are above 9kb as a result of which I am unable to use varchar or char. I guess I could tackle this through the usage of ntext. But in SQL…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
0
votes
0 answers

Application crashes after installation on client machine

Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: log generator.exe Problem Signature 02: 1.0.0.0 Problem Signature 03: 57b811c0 Problem Signature 04: System.Data.SqlServerCe Problem Signature 05: …
tanmay gharat
  • 23
  • 6
0
votes
1 answer

SQL Server CE 3.5 Performance issue

We are currently using SQL Server CE 3.5 with many different bidirectional sync dbs (Syncframework 2.1) with server DBs, and .net 3.5 windows based WPF application. But down the line the performance of the application degrades and we regularly need…
Sundar
  • 655
  • 2
  • 7
  • 13
0
votes
1 answer

Get Float value with Comma separtor

Am new to Sql server ce. my table have float value. I want select float with comma separated and decimal position. like this table name table1 val 1220333 222 36535 I want result like this val 12,20,333.00 222.00 36,535.00 like indian…
Sathish
  • 4,419
  • 4
  • 30
  • 59
0
votes
0 answers

SqlCeException when attempting to delete rows from table in sdf database (Corruption?)

I attempt to delete a number of rows from a table in a SQL Server CE 3.5 database and I get a SqlCeException: An internal error occurred. [ ID = 3649 ] I've read that it means that the database is in a corrupted state and must be repaired…
Stavros Zotalis
  • 718
  • 4
  • 24
0
votes
1 answer

Opening a database on desktop then on PDA

I ran into a strange behaviour with a Microsoft SQL Compact 3.5 database. In the application on which I am working I need to create a SQL compact database on a desktop PC and send it to several PDA (running WinCE 5). The database is quite heavy (300…
Jihef
  • 3
  • 2
0
votes
0 answers

SQL Server CE connection string for OleDB

Connection string problem: I need to connect to SQL Server CE 3.5 using oledb as I want to use tabledirect function Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=D:\Projects\SQLCE\AisDT.sdf; Password=GMT786; Persist Security…
Khurram Sultan
  • 39
  • 7
1 2
3
4 5