Is there any gui/tool which allows you to edit the data in the ssce db file ?? like the sql server management studio which allows you to the select a table in sql express+ and edit-add/update/delete the data in that table using a grid interface ! ...
Is there a way to generate the sql statement for tables in sql server compact ? same as for sql server express+ ? Essentially a create table( .... ) statement as output ? ...
Does anyone know the best way to create a SqlCe (Compact 3.5) table based on the schema of a DataTable at runtime? I don’t want to have to formulate a “CREATE TABLE” statement based on all the different possible data-types, etc. As a bonus – do you then know how to fill it directly from a datatable? ...
Hello , in the past hour i have been trying different variants of this query but i get error at the username , and the username is just a normal string with username that i get from xml file containing no special characters or whatsoever I'm using SLQ compact 3.5 P.S i tried to use ? instead of @username also not working all feild...
I developing new application and I would like using SubSonic and SQL Server Compact. But when I run my simple app (for trying SubSonic) I get exception "Unable to find the requested .Net Framework Data Provider. It may not be installed." Anyone have some advice for me, how solve this? I have reference to System.Data.SqlServerCe UP...
I would like use Repository Pattern and MS SQL Compact Edition in my project. My question is which framework or technology do I use for it? Linq2Sql hasn't data provider for SQL CE SubSonic hasn't support for SQL CE NHibernate looks huge for this, I think. I would like use my POCOs. ...
i am trying to write a data iterator for SQL, it looks like the best approach is to cook up some dynamic sql for this problem. I want the iterator to support paging, sorting, and filtering of the data, and ideally not iterate over a memory copy but to not even select the data in the first place, perhaps LINQ to SQL or Entity Framework w...
I am aware of other solutions like System.Data.Sqlite or Firebird through Dblinq, but since nothing beats SQL Compact Edition (integration-wise) with Visual Studio, I would like to use it and to know if its license allows its usage in Open Source projects. Thanks. ...
Is there even a need to periodically compact SQL CE databases? Will auto shrink suffice? Our average database size is about 100Mb, with large users hitting 400-500Mb (but those are very rare). If we do have to compact manually, how do we tell when we should? Is there a way to tell the fragmentation level or percent of wasted space progra...
Hello , another sql problem of mine .. this time the reader doesn't work properly ( I think so ) I use this code and I get only 1 record added and my db has 100`s of records .. public void addPosts() { string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\...
As the Silverlight team worked through the betas, one glaring pain point that is existing in the realm of Silverlight 3 is the ability to have an offline database, so that you can right-click on the SL application, install it locally, and then be able to manipulate data in a local setting, without the Internet. I've read a few articles ...
In an ASP.NET web application I have to dynamically create a SQL Compact 3.5 database for a Windows Mobile Compact Framework application from a data source (SQL Server). I have to create the database file, needed objects (tables, ...) and fill the tables with data. The client application (Windows Mobile device ) will download that gene...
Are there any tools available (prefer if free) to transfer tables and data from SQL Express 2005 to SQL CE 3.5? I have a small app that uses SQL Express and since it is using Linq-to-SQL I want to change it to use SQL CE 3.5 so that users don't need to install the DB engine in order to use it and to simplify backups having them only cop...
My company is looking at using SQL Server Compact Edition 3.5 as a datastore for a few programs that have been developed over the last several years. Most of these programs are were written in C++ and are installed on some older machines with Windows 2000, XP, or Vista installed. Does SQL Server Compact Edition 3.5 depend on the .net fra...
I am writing a wpf destop application, and would like to use SQL Server CE as a backend. I'm trying to come up with a good way to do efficient data paging. In SQL Server Express, I can do something like this: Select ID, FirstName, LastName From (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS Row, ID, FirstName, LastName From TestTable ...
Scenario: Client (Mobile) - .Net CF 2.0, SQL CE 3.0 Server - .Net 2.0, SQL Server 2005, Web Service Client and Server database schemas differ. From server - only certain columns from certain tables need to be synced. From client - everything will need to be synced once client has made changes. Client will continually poll a web ser...
I am using NHibernate with a SQL CE desktop database, and I'm getting an odd error when I try to do an update. SQL CE is throwing Error 25026: "A foreign key value cannot be inserted because a corresponding primary key value does not exist." The exception occurs when performing a cascading update of a collection property of an entity ob...
I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions(Differences Between SQL Server Compact and SQL Server) but I would like to keep everything else. I have tried this app, SQL Server to SQL Server Compact Edition Database Copy but it errors out on me. I have the source and ...
I am having a WPF desktop application that uses SQL CE (compact edition 3.5 ) and using the Entity Framework as a Datalayer. As It turned out in (http://support.microsoft.com/default.aspx?scid=kb;en-us;958478&sd=rss&spid=2855 ) and (http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/b6bac277-cf66-4c74-a0b3-e48abedbd161/...
Hi, I am trying to learn the basics of Windows Mobile development against SQL CE and have come across a basic problem. I have two tables. One called Customers that stores customer info and has an identity column called ID as the primary key. The other table is called Orders which has a column called CustomerID (the FK constraint is p...