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
1
vote
1 answer

SQL Server CE 4.0 with multiple connections across seperate processes

Is this possible? I have a web application the uses EF code-first and SQL Server CE 4.0. Can I have a Winforms app that also uses the same .sdf file?
Paul Knopf
  • 9,568
  • 23
  • 77
  • 142
1
vote
2 answers

SQLCE: How to join tables from different SQLCE databases programmatically in C#?

I keep tables on different .sdf files because it's easy to manage them, ie; back up only changed db file, etc, plus in future db size might bigger and there is -4GB limit- I need to join the tables and this will be my first -possibly LINQ- attempt.…
Nime Cloud
  • 6,162
  • 14
  • 43
  • 75
1
vote
3 answers

SecurityException: Request failed. - Entity Framework Code First (Sql Compact 4)

I created an assembly (dll) with the following classes: Person.cs [Table("People")] public class Person { [Key] public int ID { get; set; } public string Name { get; set; } } DataContext.cs public class DataContext : DbContext { …
ridermansb
  • 10,779
  • 24
  • 115
  • 226
1
vote
1 answer

Is SQL Server CE 4.0 able to handle few tables with many rows with acceptable performance?

I'm writing a relatively small single user winforms lottery application. Most of the time it will just fetch data (tickets) from a webservice and then, on saturdays, it will realize the lottery draw. As the balls are drawn, a query will run to…
Henrique Miranda
  • 1,030
  • 1
  • 13
  • 31
1
vote
1 answer

Entity Data Model wizard in Visual Studio 2010 SP1 lacks support for EntitySQLServerCompact 4.0 in non ASP.Net projects

I finally found some resources and a solution. I will share it here.
Dabblernl
  • 15,831
  • 18
  • 96
  • 148
1
vote
1 answer

WebMatrix SQL CE numeric type has zero precision

I created a column in SQL CE database with "numeric" type, precision 10 and scale 5 using WebMatrix. Then, I saved the table, and precision/scale suddenly changed to 0. When I try to edit them, I receive the following…
wizzard0
  • 1,883
  • 1
  • 15
  • 38
1
vote
1 answer

Is SQL Server CE 4 in a VS2010 WinForms application possible?

I'm trying to use SQL CE 4 via Entity Framework 4 in a WinForm application. Can anybody answer if this combination is possible?
ove orvarsson
  • 11
  • 2
1
vote
1 answer

Winforms dataset X sql ce 4

How can I use Windows forms dataset and sql server CE 4 ? I'm trying to drop tables from server-explorer to the dataset and getiing this message: Is there any workaround ?
Alexandre
  • 7,004
  • 5
  • 54
  • 72
1
vote
1 answer

EF 4.1 SQL Compact byte

I'm having a few performance bottlenecks in my queries. What happens is whenever i introduce a property as a byte in my entity, EF 4.1 casts it to an int prior to working with it. The given code will explain: var segmentQuery =…
Polity
  • 14,734
  • 2
  • 40
  • 40
1
vote
2 answers

Many-To-Many Relationship Basic Example (MVC3)

I have a MVC3 C# project that I have a model of FoodItem and FoodItemCategory. The two models are shown as follows: public class FoodItem { public int ID { get; set; } [Required] public string Name { get; set; } public string…
clockwiseq
  • 4,189
  • 9
  • 38
  • 61
1
vote
1 answer

Query analyzer or profiler for SQL Server CE 4

Is there any query analyzer or profiler for Microsoft SQL Server CE 4?
Ghooti Farangi
  • 19,926
  • 15
  • 46
  • 61
1
vote
1 answer

Where can I find my SQL CE 4.0 .sdf file when following the ASP.Net MVC 3 tutorial using Visual Studio Professional?

I am using the tutorial from the ASP.Net MVC site to upgrade my skills to ASP.Net MVC 3, Entity Framework, SQL CE 4.0 etc. However, I am using Visual Studio 2010 Professional, not Express. On this lesson the SQL CE 4.0 database Movies.sdf is…
Nissan Dookeran
  • 11
  • 4
1
vote
1 answer

EF 4.1 Code First SqlCe and DateTimeOffset

I have an entity like: public class EventItem { public int Id { get; set; } public int Vn { get; set; } public DateTimeOffset EventDate { get; set; } ... } ..and then use EF fluent API to construct the db: public class…
ozczecho
  • 8,649
  • 8
  • 36
  • 42
1
vote
4 answers

How to determine SQL server version number for Compact edition 4 up to full sql server 2008?

Lot's of people have asked and been responded to about how to determine the version of the sql server using things like @@VERSION, or SERVERPROPERTY('productversion') but none of these work with sql server compact edition 4. Is there some…
JohnC
  • 3,938
  • 7
  • 41
  • 48
1
vote
1 answer

Connection to .sdf database from sub dir of site in ASP.NET Razor

I have a small website that I am building using ASP.NET web pages Razor Syntax. It has an SQL CE 4 database in the App_Data folder. The connection and getting records from the database works fine in pages that are in the root directory and the…
nedlogan
  • 125
  • 1
  • 1
  • 8
1 2 3
…
16 17