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
4
votes
3 answers

ASP.NET MVC 3 app, BCrypt.CheckPassword failing

I'm working on implementing security in an ASP.NET MVC 3 application, and am using the BCrypt implementation found here to handle encryption and verification of passwords. The user registration screen encrypts the password the user provides just…
Bob Yexley
  • 2,704
  • 4
  • 24
  • 35
4
votes
2 answers

LINQ to Entities StringConvert(double)' cannot be translated to convert int to string

Problem Need to convert int to string using EF4 + SQL CE4. The recommended option of using SqlFunctions.StringConvert(double) still gives me errors. Option 1 (original). This gives me error: public static IEnumerable…
Nestor
  • 1,969
  • 4
  • 25
  • 30
4
votes
1 answer

Entity Framework 4.0 with Sql Compact Edition 4.0 - Not Implemented Exception

I have this LINQ query: var children = DataContext.Entities.Nodes .Where(n => n.Parent.Name == node.Key) .OrderBy(n => n.SortOrder); foreach (var child in children) var childNode =…
Alfero Chingono
  • 2,663
  • 3
  • 33
  • 54
4
votes
2 answers

Ado connection to SQL Server Compact Edition 4.0

I want to connect to SQL Server Compact Edition 4.0 from an old asp-classic site but i always get the error: "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default…
Yots
  • 1,655
  • 6
  • 17
  • 25
4
votes
1 answer

Using GetUTCDate in SQL Server CE 4

Consider a SQL Server CE 4 table with a non-nullable column: FooDate. The goal is to have the current UTC datetime as the default. The function is not recognized by SQL Server Compact. Name of function GetUTCDate. The function GetDate() works as…
p.campbell
  • 98,673
  • 67
  • 256
  • 322
4
votes
2 answers

Using Entity Framework 6 with SQL Server Compact 4

I'm trying to create a SQL Server Compact database from the code using code-first scenario, utilizing Entity Framework. Everything worked until I realized I have installed SQL Server 2014 Express and it was using it (instead of local .sdf file,…
user969153
  • 568
  • 8
  • 25
4
votes
2 answers

SQL Server Compact 4.0 DbProvider - No

I'm using the SQL Server Compact/SQLite Toolbox for Visual Studio by ErikEJ. Environment is Windows 7 x64 with Visual Studio 2013.5 I'm following along in the example on the blog…
Alan
  • 306
  • 2
  • 10
4
votes
0 answers

ATL OLEDB and Threading

I am currently using SQL Server CE 4.0 and accessing the database using the ATL OLEDB C++ API. I am using a shared connection (CDataSource object) across threads with a separate CSession object per thread. In my queries, I am providing table lock…
rohitsan
  • 1,001
  • 8
  • 31
4
votes
1 answer

Good way to check for duplicates and remove them from a DataTable, against a database table?

I have a populated DataTable in my code: I'm using SQL Server CE 4.0 and to get around performance issues, I'm using SqlCeBulkCopy: SqlCeBulkCopyOptions options = new SqlCeBulkCopyOptions(); options = options |= SqlCeBulkCopyOptions.KeepNulls; //…
JL.
  • 78,954
  • 126
  • 311
  • 459
4
votes
1 answer

Deploying MVC 4 application to localhost gives HTTP Error 404

Using Visual Studio 2012 Express on Windows 7, From MVC 4 internet application template I created a new project, then used the simple membership and tested successfuly the authentication. Then to try the simplest deployment way, as first step I…
Sami-L
  • 5,553
  • 18
  • 59
  • 87
4
votes
1 answer

Authentication from Asp.Net Mvc4 Project to Another Asp.Net Webapi Project, backed by SQL Server CE 4

I've been searching for an answer to my question for a while now, but can't find what I'm looking for so I hope someone can help me :) Scenario: 3 Projects: Asp.net Web Api Project (SQL Server CE 4 database + Asp.Net Membership) Windows Phone 7.5…
Gert C.
  • 133
  • 5
4
votes
1 answer

How to detect if SQL Server CE 4.0 is installed

I develop some application that needs SQL Server CE 4.0 installed. I do all job under Windows 7 64-bit so I have installed SQL Server CE 4.0 64-bit. How I can do some checking if there is installed SQL Server CE 4.0 32-bit/64-bit when I start the…
NoWar
  • 36,338
  • 80
  • 323
  • 498
3
votes
3 answers

how to fix this query performance on SQL Server Compact Edition 4

i have the following SQL Query which runs on SQL Server CE 4 SELECT [Join_ReleaseMinDatePost].[FK_MovieID] FROM ( SELECT [FK_MovieID], MIN([DatePost]) AS [ReleaseMinDatePost] FROM [Release] GROUP BY [FK_MovieID] …
Karim
  • 6,113
  • 18
  • 58
  • 83
3
votes
1 answer

SQL Server Compact 4.0 chokes on INSERT statements

I'm trying to create a SQL Server Compact 4.0 database in code, and I would like to create some system lookup tables and fill them with values. Therefore, I have a SQL script as an embedded resource in my project, which looks like this: CREATE TABLE…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
3
votes
2 answers

SQLCE: Why I get "duplicate value" error? The field is identity enabled?

In my query I don't use primary key field because identity setting is enabled. string sql = @" INSERT INTO [tblTemplates] (personID, hash, data) VALUES (@personID, @hash, @data)"; cmd = new…
Nime Cloud
  • 6,162
  • 14
  • 43
  • 75
1 2
3
…
16 17