Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-3.5]

74 questions
0
votes
1 answer

Query two separate SQL Compact databases from SQL Server Management Studio

I have two different SQL Server Compact (sdf) database files and I want to use SQL Server Management Studio to update a table in one of the sdfs with rows from the other. With traditional SQL Server mdf databases, it's possible to refer to two…
FuzzyDuck
  • 1,492
  • 12
  • 14
0
votes
2 answers

What do I need to install on a WP8 device that capable it to run my app writen by wp8 and SQL Server CE 3.5?

Please give me link of program that can capable phone wp8 run my application that written by Wp8 and VS.net 2013 and SQL Server CE 3.5. Please give me link of software that I need to install on the phone.
Rashed DIP
  • 57
  • 8
0
votes
1 answer

display result as 1 row in transposed/pivoted result of sub query in SQL Compact edition

I have a table MonitorLocationDetails which looks like below lid LoclColumn LocDescription 1 MP1 MP-1 descr 2 MP2 MP-2 descr 3 MainGate Main Gate descr I should get the rows of LocDescription and transpose it like pivot…
Nish
  • 19
  • 7
0
votes
1 answer

Microsoft SQL Server Compact edition insert query return select @@identity

I am trying to create a function which inserts a record into a Microsoft SQL Server Compact edition 3.5 database and returns the id of the newly inserted row. Here's my code: upit = "insert into Crtez (Ncrteza, ProjID, lilu, lide, dubinaRova, d1,…
Krkec
  • 121
  • 1
  • 4
  • 14
0
votes
1 answer

Embedding SQL Server Compact 3.5 in the application

I am confused about embedding the sql server compact 3.5 files in my application. I have included 7 files in the setup but application fails to run on some computers. Is there some version problem? I wish to embed both (32 & 64 bit) as I do not know…
Furqan Sehgal
  • 4,917
  • 33
  • 108
  • 167
0
votes
1 answer

Conversion nvarchar to decimal

SELECT NOM ,Sum(CAST(SOLDE AS float)) AS _solde FROM tab WHERE NUM_CLIENT='550322' GROUP BY NOM I have a result without comma ,SOLDE is something like that 66,11 i want a result respecting a comma .
user3658555
  • 17
  • 1
  • 5
0
votes
1 answer

sqlCeDataAdapter.update, Update requires a valid UpdateCommand when passed DataRow collection with modified rows

**strong text* hi all this is my code : for(int i =0 ;i
user3658555
  • 17
  • 1
  • 5
0
votes
1 answer

What approach should I take to synchronize a mobile SSCE database with Access?

The target machine is a Datalogic Skorpio X3 hand held scanner. The references say it is CE 6.0 with no mention of Windows Mobile. I am replacing an older app for older hardware that ran Pocket Access and used ActiveSync to upload from the…
Rich Shealer
  • 3,362
  • 1
  • 34
  • 59
0
votes
1 answer

Explicit construction of entity type ### in query is not allowed

I use a Windows phone 8, MVVM + SQL Server CE 3.5 database In folder model I have a declaration of table In folder ViewModel have this code for getting the collection. public IEnumerable GetTblCollections() { …
John Brush
  • 177
  • 11
0
votes
1 answer

The specified table does not exist. [ table_Name] error

Hi all I have an small application to add the expense of the day. For this I am using SQL compact database (CE). While inserting the record into a table name Expenses I am getting error The specified table does not exist. [Expenses] Insertion…
Ashok
  • 1,868
  • 6
  • 36
  • 70
0
votes
1 answer

Why does creating a SQLServer Compact table in Server Explorer not create an .SDF file on disk?

I created an .sdf database in Visual Studio 2008 (not programmatically - using the MS Access-like wizard); I can see it, along with the one table that's in it, and that table's columns, in the Server Explorer, yet my project failed on trying to…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Entity Framework 3.5 + SQL Server Compact 3.5, slow performace because of cast

I'm using VS2008, .NET 3,5, Entity Framework 3.5, Sql Server Compact 3.5 SP2. SQL SC 3.5 is accessed using EF, with Database first approach. I'm using a simple query (linq and EF) that should use an existing compound index for columns StanjeId…
Core Zero
  • 3
  • 2
0
votes
1 answer

Does Sql Server Compact Edition 3.5 query timeout?

I just realized that SqlCeConnection and SqlCeCommand objects timeout properties are readonly with default value set to 0. Does this mean queries to SqlCe database never timeout?
rageit
  • 3,513
  • 1
  • 26
  • 38
0
votes
1 answer

Problems faced in keeping SQL Compact Edition Database on another machine in same network

I am using SQL CE 3.5 for one of my project, the front end is WPF application which process the given files and dumps the data to SQL CE database. Presently application and DB is on same machine. Client wants that he should be able to run the…
Deepesh
  • 5,346
  • 6
  • 30
  • 45
0
votes
1 answer

Linq Query returns 0 results, but should return 1

I have a SQL Server Compact Edition version 3.5 for a winforms app that is used as to store order information, but I have had a complaint from someone who is having issues where the detail isn't showing up after it has been finished and submitted,…
Charles380
  • 1,269
  • 8
  • 19
1 2 3
4
5