Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce]

3695 questions
23
votes
3 answers

SQL Compact 4.0 can't open/read sdf file

I've installed SQL Compact 4.0 CTP 2 via WPI and used NUPack to add SQLCE.EntityFramework in my project. It compiles and run perfectly but I can't open the SDF file in Visual Studio 2010's Server Explorer. When I try I always receive the following…
Andre Vianna
  • 1,713
  • 2
  • 15
  • 29
23
votes
1 answer

SDF file auto-created in Visual Studio projects?

I've recently been trying to save space on my machine and started using TreeSize to analyse folder structures / sizes This led me to the discovery that a lot of my Visual Studio projects have SDF files inside them. In one case, an app folder is…
roryok
  • 9,325
  • 17
  • 71
  • 138
23
votes
8 answers

How to get current identity number of specific table in sql server compact

I want to get current identity value of a specific table Like IDENT_CURRENT('table') in sql server
Hamid
  • 577
  • 1
  • 6
  • 15
22
votes
2 answers

How can I upgrade my Sql Server CE 3.5 sdf database to Sql Server CE 4.0?

I need to update my SqlCE3.5 database to 4.0. I get the following error message when I'm trying to access my 3.5 sdf/database using the new CE4.0 connection provide :- System.Data.EntityException: The underlying provider failed on Open. --->…
Pure.Krome
  • 84,693
  • 113
  • 396
  • 647
22
votes
3 answers

Would you use Sql Server Compact for a desktop application?

Does it make sense to use SQL Server Compact for a desktop application? How much data can it handle? Is it possible to use it with multiple users? What are the constraints? What happens when database files are broken? Is it possible to…
Serhat Ozgel
  • 23,496
  • 29
  • 102
  • 138
22
votes
6 answers

Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2

I'm using Visual Studio 2008 Pro. I'm probably missing something very obvious here, but I've been trying to get the CTP for Sql Server compact 4 to work in my asp.net mvc application. I can find next to no instruction on how to set this up or a…
jason
  • 2,219
  • 5
  • 33
  • 66
22
votes
1 answer

How to connect to SQL Server CE file using SSMS

I am using SSMS 2012 and trying to connect to the SDF created by Orchard. According to this answer, I should be able to select SQL Server Compact Edition as the Server type when connecting my object browser, but that isn't an option. Is there…
zimdanen
  • 5,508
  • 7
  • 44
  • 89
21
votes
2 answers

resolving corruption in SQL Server Compact Edition database files

This is not a query. Its a summary of our solution to get around the problem of corruption in SQL Compact Database files with (almost) definite success. SQLCE Corruption is a very common problem. We've received tremendous help from earlier posts in…
R D
  • 521
  • 5
  • 12
20
votes
4 answers

The limit of SQL CE 4.0

I'm planning to use SQL CE 4.0 in a small but production web site and I'd like to know how much load SQL CE 4.0 can handle: Number simultaneous connections, Number of rows per table, and The total DB size.
TheBlueSky
  • 5,526
  • 7
  • 35
  • 65
20
votes
5 answers

SQL Server queries case sensitivity

I have this database: abcDEF ABCdef abcdef if I write: select * from MyTbl where A='ABCdef' how to get: ABCdef and how to get: abcDEF ABCdef abcdef Thanks in advance forgot to write - sqlCE
Gold
  • 60,526
  • 100
  • 215
  • 315
20
votes
5 answers

Using Entity Framework with an SQL Compact Private Installation

I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of SQL Compact with my application, so that my installer can install SQL Compact without giving the user a second installation to do. It…
David Veeneman
  • 18,912
  • 32
  • 122
  • 187
20
votes
3 answers

How to change column width in DataGridView?

I have created a database and table using Visual Studio's SQL Server Compact 3.5 with a dataset as my datasource. On my WinForm I have a DataGridView with 3 columns. However, I have been unable to figure out how to get the columns to take up the…
Pallas
  • 1,499
  • 5
  • 25
  • 57
19
votes
3 answers

Error storing Image in SQL CE 4.0 with ASP.NET MVC 3 and Entity Framework 4.1 Code First

I'm trying to store/save an image in an SQL Compact Edition (CE) database. I declare the field in my Student model as: [Column(TypeName = "image")] public byte[] Photo { get; set; } The database is created with the image data type for the Photo…
Leniel Maccaferri
  • 100,159
  • 46
  • 371
  • 480
19
votes
5 answers

Increase the size of sql compact 3.5 .sdf file

I'm using Sql Compact3.5 as my DB with C# .NET what is the maximum size of sdf that I can give? Is there any way to programatically increase the maximum size of the sdf file? If so how?
Jankhana
  • 953
  • 4
  • 18
  • 29
19
votes
7 answers

Insert into one column by selecting another column in other table but how fill the second column

i have a table which has two columns i'd fill one of the columns by selecting other table column data but how can i fill the next column cause i can't use VALUE. Here's the code INSERT INTO Numbers(number, val) SELECT LaptopID FROM Laptop WHERE…
shervin -
  • 353
  • 1
  • 4
  • 12
1 2
3
…
99 100