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

sqlsce connection from visual studio 2013 server explorer

I am trying to add connection to a sqlsce 4.0 sdf file from visual studio ServerExplorer. I right click dataconnections, and click "add connection" The dialog "Choose Data Source" comes up. But in the list of available data sources a SQLS CE is not…
Manolo
  • 1,597
  • 4
  • 21
  • 35
0
votes
1 answer

SyncFrameworkToolkit + SqlServerCE + Entity Framework Example

I'm looking for a very simple example of SyncFrameworkToolkit with a SQL Server CE local database synchronizing with the templated web service and provisioned remote sql server. Seems like a rather simple concept but after days of searching I can…
cesara
  • 842
  • 1
  • 7
  • 19
0
votes
0 answers

Does EF6 and SQL Server CE 4.0 work with VS2012 Express in 64bit?

When I attempt to: Add a new ADO Entity Data Model Select EF Designer from database Select an existing database connection, include the connection string, and save it to app.config Do NOT copy/modify the connection (I tried this with the copy and…
James
  • 954
  • 2
  • 13
  • 27
0
votes
2 answers

Using COUNT For Comparison in SQL Server CE 4.0

I'm attempting to combine the logic for some of my SQL queries, and I can't seem to figure out this problem. Obviously SQL Server CE has many limitations compared to SQL Server or mySQL, but surely there's a way to solve this. I want to do a count…
Daniel Simpkins
  • 674
  • 5
  • 18
0
votes
2 answers

Attempt to insert a row in database table fails

I'm trying to put anything into my DB. Message Box is showing that I did put 1 row to DB, but when I check it - nothing happened. Anybody know the cure? SqlCeConnection cn = new SqlCeConnection(@"Data Source = Database1.sdf"); try { …
user1798039
  • 31
  • 1
0
votes
1 answer

MVC - HTMl.begin form - create an event record and automatically create x number of records in another table?

So ive linked a database controller in visual studio, and via browser i can create, edit, delete etc. im in the process of building a ticket website project, and wondering how you would go about creating one event - and then on submit it will…
user3330281
  • 1
0
votes
1 answer

Converting nvarchar(50) column to datetime in SQL CE 4.0

I'm new to SQL and have inherited a database which uses nvarchar(50) as the data type for the "Date" column. I want to convert this column into datetime format but I cannot figure out how to do so as I am using SQL CE 4.0 and can only find solutions…
Hayley Guillou
  • 3,953
  • 4
  • 24
  • 34
0
votes
1 answer

Error trying to add data to a SQL Server Compact database

After setting up a database in SQL Server Compact 4.0 and when trying to add data with the 'Show table data' I get the following error Executed SQL statement SELECT Title, ID, Plot, Cast, Genre, Year, Rated, Length, Book, Page. Slot FROM…
user3233883
  • 1
0
votes
1 answer

Sql Server Compact Limitations -- design decision or work in progress?

I'm using Sql Server Compact for automated integration tests of our web application, which runs the latest version of Sql Server (large? uncondensed?). The idea was to use a more lightweight database to mimic our own, which would be easy to create…
DMac the Destroyer
  • 5,240
  • 6
  • 36
  • 56
0
votes
0 answers

SQL Server CE with entity framework code first issue

I want to use code first with SQL Server CE but after run update-database command database file not created. But console show run successfully. this is my connection string:
b24
  • 2,425
  • 6
  • 30
  • 51
0
votes
2 answers

How bad is to create indexes

I have a SQL Compact 4.0 database with a table that has about 20 columns and about 1,000,000 rows. The problem I have is with performance which because users might use these 20 columns to filter the result the query will take a lot of time to…
mrtaikandi
  • 6,753
  • 16
  • 62
  • 93
0
votes
2 answers

how to build a Comma seperated list from a table in SQL CE?

how to build a Comma seperated list from a table in SQL CE ? I have table named Group and it has two columns ID and Name I want to select a one comma seperated string from Group table. So IF I have 3 records as follows in group table ID | Name…
user3030035
  • 143
  • 1
  • 8
0
votes
0 answers

SQL Server CE v4 on Windows 8

I built the app using SQL Server CE 4.0 and it runs just fine in Windows 7.0 dev machine, but got the following error message running it in Windows 8 (x64 version, Lenovo All-In-One Horizon 27' HW platform): Is not a valid Win 32 application…
Alexander Bell
  • 7,842
  • 3
  • 26
  • 42
0
votes
1 answer

Unable to work with SQL Server CE 4.0

I try to work with a SQL Server CE 4.0 database with my simple console app but it is not working on one of my machine. OS: Windows Server 2003 Enterprise x64 Edition with Service Pack 2 I have also installed Microsoft SQL Server Compact 4.0 and…
user1370468
  • 47
  • 2
  • 3
  • 8
0
votes
1 answer

How to do a null check in a LINQ to Entities with SQL CE 4.0

I have a LINQ query: Dim result = DataContext.Items.Select(Function(p) New With { .Category = If(p.Category IsNot Nothing, p.Category.Name, String.Empty) .Name =…
just.another.programmer
  • 8,579
  • 8
  • 51
  • 90
1 2 3
…
16 17