Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-4]

Microsoft SQL Server Compact version 4 is a SQL Server embedded database for building standalone and occasionally connected applications for mobile devices, desktops, and Web clients.

Use this tag if you encounter issues specific for version 4.0 of sql-server-ce. For not version specific issues use the generic tag .

The tag would be primarily used for questions addressing these features:

  • Using CE in combination with Microsoft WebMatrix
  • Designer and debugging capabilities in Visual Studio
  • Medium or partial trust environments in the web servers
  • Sit-by-site deployment
  • The SHA2 encryption algorithms for encrypting the databases
  • T-SQL syntax for OFFSET and FETCH
  • New APIs like SqlCeConnection.GetSchema
  • Server generated keys like identity, rowguid etc.

Taken from the download page

254 questions
0
votes
1 answer

SQL Server Compact Toolbox with disabled add connections options

The original problem is that I'm trying to use SQL CE 4.0 with Entity Framework 5. I have applied the service pack 1, applied different hot fix (as suggested in different forums and blogs). Now, I've read that SQL Server Compact Toolbox can manage…
Yanick Rochon
  • 51,409
  • 25
  • 133
  • 214
0
votes
1 answer

Using SQL Server CE 4.0 with Entity Framework on Windows Azure

I am using SQL Server CE 4.0 with WebApi on Windows Azure Websites. I have been successfully able to deploy SQL Server CE. The weird problem I am facing is that my site is able to log me in using the same DB but I am not able to use any of the…
Hemant
  • 411
  • 4
  • 15
0
votes
2 answers

Is there any ready-made tool available to generate Setup Scripts for Database Provider for Microsoft Sync

I am working with Microsoft Sync Framework 2.1, MS SQL Server 2008 * MS SQL CE 4.0 ... Is there any ready-made tool available to generate Setup Scripts for Database Provider for Microsoft Sync please visit below link so you come to know that what i…
Nitin
  • 11
  • 3
0
votes
3 answers

Ecrypt password in app.config

I am using Entity Framework to create a SQLServer connection of database with a password: connectionString="DataSource=|DataDirectory|DB.sdf;Password=abc How can I protect the password while using Entity Framework?
Alvin
  • 8,219
  • 25
  • 96
  • 177
0
votes
0 answers

Entity Framework, CTP5, SQLServerCompact, missing Database.SetInitializer

I've installed EFCodeFirst 0.8 (CTP5) and EFCodeFirst.SQLServerCompact 0.8.84821. I've updated the references to EntityFramework and System.Data.SqlServerCe.Entity.dll. My project compiles and runs, with one exception: I can not call…
Evgeny
  • 3,320
  • 7
  • 39
  • 50
0
votes
1 answer

File not found error when manually deleting a SQL Server Compact 4.0 file while using Entity Framework 4.3 Migrations

I am testing our application to use a SQL Server Compact 4.0 database. The application uses the database if it is there or builds it using Entity Framework 4.3 Migrations when it is absent. However, when I delete the file when the program is idle…
Dabblernl
  • 15,831
  • 18
  • 96
  • 148
0
votes
1 answer

.sdf file is giving error to open

This is my first ASP.NET MVC3 application and it is working and everything is fine except to open DB file (.sdf) in App_Data folder. I am getting error the operation could not be completed. Unspecified error. Things which is done from my side…
himanshupareek66
  • 766
  • 10
  • 22
0
votes
1 answer

Unable to generate Controller for Entity using SqlServer CE 4.0: ScaffoldingConnectionFactory Error

I am getting the feel of SqlServer CE 4.0 to use with MVC 3 without installation. Things are going fine. I have successfully integrated Troy Goode's MembershipStarterKit and also ErikEJ's SqlServerCEMembership provider. Both are working find. Now I…
TheVillageIdiot
  • 40,053
  • 20
  • 133
  • 188
0
votes
1 answer

Sql Server CE foreign key shows up as primary key

At least, that's how it looks to me. I'm using Sql Server CE 4.0 and Visual Studio 2010. This is the first time I've used Sql Server CE. For example, I have two tables. One is called Templates: TemplateID (int, primary key, identity) TemplateName…
Cynthia
  • 2,100
  • 5
  • 34
  • 48
-1
votes
1 answer

Password protecting an existing SQL Server Compact 4 database file

Can someone tell me how to password protect an existing SQL Server CE 4 file?
user1095973
-2
votes
1 answer

Entity Framework Seems to want to use Sql Server Provider despite needing Sql CE

I am using an SqlCe 4 database with an Entity Framework 6 code first data model. I set the connection string in the DbContext constructor like so: private static readonly string DATABASE_PASSWORD = "..."; private static readonly string…
Steven Wood
  • 2,675
  • 3
  • 26
  • 51
-2
votes
1 answer

Gettings started with EF (SqlServerCe)

I am creating an application in WPF, and I want connect to a database using SQL Server Compact 4.0. I add data base to project. And using NuGet I added System.Data.SqlServerCe System.Data.SqlServerCe.Entity In my app.config a connection string…
user1031034
  • 836
  • 1
  • 14
  • 38
-3
votes
1 answer

Why am I getting the count of column names and source expressions do not match on INSERT into table with Identity Column from C#

I know similar questions have been asked but here me out. As stated in the title, an exception is thrown when trying to add data to a table that has an identity column as its primary key. Identity is ticked for the table and it auto-increments. The…
LusunguPryme
  • 3
  • 1
  • 2
-4
votes
1 answer

Which version of SQL Server CE does SQL Server 2014 supports?

I'm using SQL Server CE for SQL Server 2008. But, now I must using SQL Server 2014, But SQL Server CE 3.5 SP.2 doesn't support SQL Server 2014. Which version of SQL Server CE does SQL Server 2014 support?
Zeynep Tosun
  • 1
1 2 3
…
16
17