I have a WinForms application that interacts with a SqlCe local database. I manage db operations using BindingSources, TableAdapters and typed datasets.I have several operations scattered through several methods in two different classes that I need to perform in a transaction and I was thinking of using System.Transactions.Transaction or...
When using the AJAX login services in a winform application; if it is set to cache the credentials, where are they stored? The connection string is: Data Source = |SQL/CE| ...
Hi Is there a way to list all sqlce database table indexes, or at least for individual tables? ...
Hi i have a ms sql database that is getting replicated to mobile sqlce databases. My question is the following: Are the indexes getting propagated to the sqlce database tables as well? ...
I have a mobile app that writes to a SQL Server CE database on the device. I want to write a desktop application that can read this data and export it in CSV format. I have been looking at RAPI (Remote Api), but I would prefer to do this entirely with managed code. Is there an alternative to RAPI? ...
In an ADO.NET Entity Framework object model, I'm running into some trouble with related tables. (Navigation Properties) My backend datastore is a SQL CE database. When I make changes directly to the related table, these changes don't show up through a higher level table ever after calling SaveChanges. My changes are saved perfectly ba...
I'm trying to do this in a SQL Server CE database, but the database engine keeps reporting errors. SELECT C.guid, C.name, C.updated, C.hddsize, C.hddavailable, C.hddfree, C.ramsize, C.profiles, C.cpu, (SELECT COUNT(D.id) AS numprogs FROM ComputerData AS D WHERE D.computer_id = C.id) AS numprograms FROM...
Hello, I have two tables, in a many-to-many relationship, with a junction table, as follows: Member MemberGroup Group ========= ============ ======= PK | ID PK | ID PK | ID | Name | Member | Name | Group | MemberSince I need to add all the member...
Deploying database(*.sdf) to Pocket PC WM 5.0. Via C# i am attempting to DELETE records. The DELETE query returns that 5 rows are affected(there are 5 rows). However, when i view database in Pocket PC under its Query Tool the rows remain. No error or issue arise at my code level. What is missing? It is the right database beca...
Hi I'm writing a WPF client app, using Linq to Sql with Sql Compact edition. The db is relatively small (3MB) and read-only. Bottom line is that The performance are not as good as I hoped them to be, and I'm looking for tips and practical ways to increase that. More facts: The schema contains around a dozen of entities with extensive r...
If you specify "Engine Default" when encrypting a SQL CE database, what specific type of encryption does it use? (Let's assume version 3.5) ...
Does SQL CE support clustered indexes? ...
I've tried select top 1 * from tbl select top(1) * from tbl select * from tbl limit 1 Nothing worked. Does SQL Server Compact Edition support getting the top x rows? ...
Once upon a time I installed SQL Server Compact Edition v3.1 on my box. As a result when I open SSMS 2005 (SQL Server Management Studio) and go to Connect to Server dialog, I see a "SQL Server Compact Edition" entry under the Server Type dropdown. I've uninstalled SQL Server Compact Edition v3.1, but the "SQL Server Compact Edition" en...
I've been searching for some time for a good solution to implement the idea of managing schema on an SQL Server Compact 3.5 database. I know of several ways of managing schema on SQL Server Express, SQL Server Standard, SQL Server Enterprise, but the Compact Edition doesn't support the necessary tools required to use the same methodolog...
I have inserted some rows into a data table with Set Identity_insert tblEvent on I then attempt to 'reseed' the Identity field int MaxId = this.MaxID()+1; string upgrade = "ALTER TABLE " + Table + " ALTER COLUMN ID IDENTITY("+ MaxId.ToString() +",1)"; System.Data.SqlServerCe.SqlCeCommand cmd = new System.Data.SqlServerCe.SqlCeCommand(...
I have a method that is run periodically to optimise my application's SQL Server Compact Edition (3.5) database. The existing code uses the Shrink() method: SqlCeEngine engine = new SqlCeEngine(dbConnectionString); engine.Shrink(); Today I noticed that there's also a Compact() method. Which is preferable for periodic m...
Hi I have a small windows app and am trying to use SQL CE for the local datastore. I have having a couple of problems deploying it. I am using ClickOnce deployment. First question: In the Publish properties -> Application Files I have it set to Data File(Auto), Required, Include. However it doesnt seem to be included? When I navigt...
I'd like a simple method to keep a SQL CE database (on Windows Mobile or CE) synchronized to SQL Server Express. My understanding is that SQL Express does not have replication which is what would normally be used. Are there any other ways to accomplish this? I'm working in C# with .Net 2.0. Thanks! ...
The string in question would be the description field of a (cooking) recipe, and the max length should be something that 99% of users should never run into. nvarchar(4000) seems like it's probably too limiting. Is a column in a SQL table even the appropriate place for this? It doesn't feel right for storing such a (potentially) large ...