well i went to that page http://erikej.blogspot.com/2009/04/sql-compact-3rd-party-tools.html there is a lot of tools there but its not clear which one will do the job right so any help? ...
hi i tried a select query that contains an left outer join on SQL Server CE and its taking like 30 seconds to execute. and then i changed the same query to be an inner join and its taking less then 1 second. the same outer query is very fast on SQL server 2008. does anyone knows why is that? also what is the fix for this performance pro...
I've got two form fields from which the user submits a 'category' and an 'item'. The following code inserts the category fine (I modified it from the WebMatrix intro PDF) but I've no idea how to then insert the 'item' into the Items table. I'll also need to add the Id of the new category to the new item row. This is the code that's wor...
well i think the title say it all :) and i am asking this because it dont work in my sql server 2008 R2 ...
I need to create an application where i can update the data once in a while. I'm trying to figure out the best way so I can create the schema...should i create a database with the tables i need and just copy from the modified database i have? but then i lose relationships that should make my life easier inside the application. Or create ...
I'm fairly new to the MS Sync framework and have been beating my head against the wall for about four hours now to no avail. I'm simply trying to sync my databases (one "master" SQL Server 2008 with a SQL Server CE, the client) with: Dim syncAgent As DataCacheSyncAgent = New DataCacheSyncAgent() Dim syncStats As Microsoft.Synchronizati...
i want help how to solve this sql problem. suppose i have 3 tables Movie ID Name Genre ID Name Movie_Genre (this one is the link for many to many) FK_MovieID FK_GenreID i want to select all the movies that are of genre 1 and genre 3 how is this possible? i can only select the movies of 1 genre but not the movies...
well this problem is general in sql server ce i have indexes on all the the fields. also the same query but with ID IN ( list of int ids) is pretty fast. i tried to change the query to OUTER Join but this just make it worse. so any hints on why this happen and how to fix this problem? ...
I have an sqlce 3.5 local db file in my VS2010 solution used with an EF4 Model. I need to protect my db with a password but do not serialize it in app.config. I also need to set up the maximum database file size to it's maximum allowed value which is 4091 MB when I try to set the connectionString in code, I can't find a way to set the 'M...
Hello everybody ::- ). I'm having a weird issue concerning Microsoft SQL Compact Edition. In a Windows.Forms application, I try to modify a database which was created by the same (.Net 2.0) application. The database gets sent to a Windows Mobile Phone later, but this is not important. What's important is that on the normal regional setti...
Hi, I'm using SQLCE database and Entity Framework 4 as my Data Access in a Winforms project. Create a class library to store all my Queries, Inserts, Updates, Deletes. I want to work in a disconnected environment without change tracking or contexts loaded, so i use code like this for a query (example): public List<UserPlaylists> GetUse...
I am designing an application for a library. Not a large scale library, but a very small scale library where my primary task is to just keep information about the books. But this library application should be able to adapt to any professional's private library. For an example, for a lawyer, apart from the basic information about the book...
Hello Everyone.. How to Install SQL CE 3.5 SP2 Silently... We are Using NullSoft. Thanks... ...
I'm building an application which will use some settings and a local SQL Server. My question is, when it comes time to update the application; will the settings or data be overwritten? What happens if I want to change some tables around in the future? ...
hi, i am trying to use SQLCE in windows service on Windows 2008. when ever i try to open connection to sqlce database i am getting an error "Database File not found"... i am amazed Database file is present there no issue with that part... any ideas? SQL Server Compact encountered problems when opening the database. [ Internal Error Numb...
The following codes that disables tracking works fine: SqlCeConnection loSqlCeConnection1 = new SqlCeConnection(Global.ConnectionStringSdf); loSqlCeConnection1.Open(); SqlCeChangeTracking loTracker1 = new SqlCeChangeTracking(loSqlCeConnection1); loTracker1.DisableTracking("ActivityLog"); loSqlCeConnection1.Close() However th...
SQL Server CE (3.5) doesn't appear to support the IsNumeric function. What are some alternatives to achieve the same functionality? Specifically, how would you test whether a CAST from a string to a DECIMAL datatype will succeed in SQLCE without IsNumeric? ...
Coming from an extensive SQL Server T-SQL background, I'm having trouble finding any specific documentation describing the differences in T-SQL support between SQL CE and full blown SQL Server. What are some of the differences you've run into? Is there a side-by-side T-SQL comparison somewhere? I've seen the MSDN documentation here, b...
I'm trying (SQL Server Compact) to add primary key constraint on existing table that has some rows in it. While adding primary key I'm getting the error: "A duplicate key cannot be inserted into a unique index" I don't what this is, can anyone help me with this? ...
Is there a way to implement data paging with sql ce? It would be for windows mobile app. Currently using the sql compact edition 3.5. Also using the Microsoft Sync Framework ADO.net v1.0 for device. ...