Questions tagged [sql-server-ce-3.5]
74 questions
1
vote
1 answer
How can I get individual results in SQL Server CE
I'm using SQL Server CE as my database with asp.net.
I'm querying the database as follows.
SELECT DispatcherName, ActivityType, COUNT(ActivityType) AS Total
FROM Activity
WHERE (BeginTime >= '4/5/2011 12:00:00 AM') AND (EndTime <= '7/13/2011…
Ram
- 913
- 5
- 17
- 35
1
vote
0 answers
Accessing SQL Server Compact from SSMS 2008 R2
I am using SQL Server 2008 R2 with SSMS, and I want to connect to SQL Server Compact (sdf files) but the option is disabled (greyed out).
This is how it looks like:
I also installed SQL Server Compact 3.5 SP 2 and their tools, see the first 2…
1
vote
0 answers
DELETE FROM table get stuck in SQL Server CE
I have a Compact Framework application where I run this code:
SqlCeCommand cmd = new SqlCeCommand();
cmd.Connection = conn;
cmd.CommandText = "DELETE FROM Empresa";
cmd.ExecuteNonQuery();
The Empresa table has only 187 records, but that…
jstuardo
- 3,901
- 14
- 61
- 136
1
vote
2 answers
Using a different connection provider for Entity Framework on ASP.NET Core
I'm using ASP.NET Core 1.1 with Entity Framework 6 to connect to a SQL Server Compact 3.5 database. How can I configure what provider to use when creating the DbContext?
MyDbContext.cs
public class MyDbContext: DbContext
{
protected override…
Lucius
- 2,794
- 4
- 20
- 42
1
vote
2 answers
SQL query for SQL Server Compact Edition 3.5 - GROUP BY issue
SELECT BabyInformation.* , t1.*
FROM BabyInformation
LEFT JOIN
(SELECT * FROM BabyData
GROUP BY BabyID
ORDER By Date DESC ) AS t1 ON BabyInformation.BabyID=t1.BabyID
This is my query. I want to get the one…
GorillaApe
- 3,611
- 10
- 63
- 106
1
vote
0 answers
System.Data.SqlServerCe.SqlCeException: Bad Hash
I have an application that connects to an SQL Server Compact Edition 3.5 database. The application will randomly fail, throwing a SqlCeException with the message "bad hash." What is causing this exception and how can I prevent it? I can't find any…
Karl Dickman
- 43
- 1
- 6
1
vote
0 answers
OutOfMemoryException when Inserting larger images in SQL Server CE
Inserting smaller images work fine. However, when the image file gets bigger than about 2MB, I get an OutOfMemoryException.
I tried with SqlCeUpdatableRecord and a parameterized SqlCeCommand. Using the SqlCeCommand, the exception is raised at…
Havad Ostgaard
- 101
- 1
- 9
1
vote
2 answers
Create SQL Server Compact 3.5 from .net 4.5
I have a C# application compiled on net 4.5.
I need to create a SQL Server CE 3.5 database file because it will be used on a Windows CE 6 device.
When I create a database from code using
SqlCeEngine en = new…
Massimo
- 11
- 2
1
vote
0 answers
How to add Object in SQL Server Compact 3.5 using Entity Framework 4.0
I'm beginner to Entity Framework. I have VS 2010 installed. I'm able to access data from a SQL Server Compact 3.5 .sdf file, but I'm not able to write using Entity Framework.
This is the code I'm using:
db.Models.AddObject(new Model()…
timil
- 11
- 2
1
vote
0 answers
Show data of table using WP 8
How can i create gridview drillthrough table on windows phone 8?
I have a tables product (id,name,actual) on sql server compact 3.5.
i would like to show this table on the emulator and add new product from it
user3433797
- 45
- 4
1
vote
1 answer
drag and drop database table to form doesn't respond
I'm developing a Windows CE Mobile Application and using SQL Server Compact Edition as database server. However, I cannot drag and drop database tables from Server Explorer to a form's design view. It simply doesn't respond the drop. What could I be…
İsmet Alkan
- 5,361
- 3
- 41
- 64
1
vote
2 answers
How to make ISNULL not just return true or false
I am using SQL Server Compact Edition as database for my Windows Application. I am having a problem while using ISNULL. I wrote a query
SELECT
ISNULL(MAX(TransactionID) + 1, 100) AS TransactionId
FROM
TBLTransactionMain
But this query…
Arun Anand
- 325
- 7
- 15
1
vote
1 answer
C#, SQL Server Compact - optimize insert record speed
I am building application for windows mobile 6.5, on a resource restricted device Unitech PA690 and i am having speed issue when inserting records into my SQL server compact edition database...
Does anyone know the best and fastest method for…
Ivan Tadic
- 143
- 2
- 9
1
vote
1 answer
Does Windows 8 Desktop Applications (Not Metro or Store apps) support SQL Server CE 3.5?
Does Windows 8 Desktop Applications (Not Metro or Store apps) support SQL CE 3.5?
When I tried to work with SQL Server CE, I get the following error:
System.Data.SqlServerCe.SqlCeInvalidDatabaseFormatException
(0x80004005): The database file…
Rahnzo
- 737
- 2
- 7
- 20
1
vote
0 answers
SQL Server Compact Edition delete with inner join
Is it possible to use delete with inner join in SQL Server Compact Edition? What is the CE equivalent of this SQL Server query?
delete a from employee a inner join department b
on a.departmentID=b.departmentID where b.departmentStatus='closed'
aldebaran
- 695
- 8
- 20