Using SQL ManagementStudio 2008 I created SQL 3.5 Compact DB (TestCompact.sdf) and I have created subscription to existing Publication. Using SQL Management Studio it is working. I have transfered TestCompact.sdf to Windows Mobile 5 emulator device and with QueryAnalyzer for Mobile I could query existing tables in TestCompact.sdf. I don'...
I don't know if it is just me, but searching on google didn't reveal me answer to my question "How to install QueryAnalyzer for SQL Compact 3.5 DB on Windows Mobile 6.5 Professional emulator device". Does somebody knows how to do it? ...
Is it possible to use the Logging block of the MS Enterprise Library with SQL Server Compact Edition? Reason is that I want a hassle - free installation of the application, I can't require the users to install SQL Server Express Edition, sadly. Also, I want to use the Enterprise Library, because it seems to be the highest quality produ...
I have a CSV file which I wish to manipulate using SQL Server Compact (CE) 3.5 How can I bulk insert the data into a temporary table? ...
I have a sqlce database table that I am entering data every day. Date No Meter_1 Meter_2 Meter_3 12-05-2010 1 1234 3456 4567 12-05-2010 2 3423 4567 0987 13-05-2010 1 2345 7654 7654 13-05-2010 2 7676 8765 5643 14-05-2010 1 ...
I have following code and I can filter data on grid but when I pick same date in 2 datepicker it shows nothing. How can I fix the problem. Any help will be appreciated. con = New SqlCeConnection(constring) con.Open() cmd = New SqlCeCommand("SELECT * FROM tblMeter WHERE (Date >= @startDate) AND (Date < @endDate)", con) Dim p...
I am trying to make a WPF application with a SQL Server CE database. I am following the tutorial SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet and Visual C#.NET, but in my Visual Studio 2010, all components under the Data-section of the Toolbox are disabled. Why are my Data components disabled? And how can I enab...
I would like to create a WPF application that is using a local database. I have created a simple database and added it so I can see my database NameDB.sdf in my Solution Explorer. How do I connect to it from my application? I have tried with an empty application that just tries to connect to the database: ... using System.Data.SqlServ...
I am successfully "querying" data in a Sql Server CE database using the TableDirect CommandType thanks to a tip from ctacke. (The performance increase is very real.) I am able to query using Index Names well. (I am creating the column via "Id int IDENTITY(1,1) PRIMARY KEY". I see the crazy index name that Sql Server CE generates, but I...
hi friends. Recently i downloaded SQLServer Compact 3.5 from Microsoft web site, and i have already installed Visual Studio 2008. When i make a new Smart Device project and try to connect some Dataset to local database, the following error rises : "Error 1 Custom tool error: This operation requires a reference to SQL Server Compact 3....
I have a SQL Compact Edition Database that I update periodically (via web services). The part where I write to the database is taking way too long. I am currently doing it with Linq to Datasets (as seen in this question). I have heard that if I do it with with SQLCeResultSet that it will work faster. So, given that I have a table lik...
I am developing a desktop application that will need to collect data (from the user) and store it locally in a secure fashion. It will need to synchronize this data with a central database when an internet connection is available. The application is WPF and I would like to take advantage of the new data-binding features of WPF. I really ...
Why this code throws a System.NotSupportedException telling that The specified method 'int? DateDiff(string, DateTime?, DateTime?)' on the type 'System.Data.Objects.SqlClient.SqlFunctions' cannot be translated into a LINQ to Entities store expression, though DateDiff has EdmFunction attribute? context.Users.Where(f => System.Data.Object...
I need to move my Sql Server CE database into MS Access, so my users who are familiar with Access can run queries on the data. Is there a free way to do that? Thanks! David ...
Does it exist a Microsoft tool or a sql query for import/export XML data into SQL Server Compact Edition ? Like this for SQL Server : http://msdn.microsoft.com/en-us/library/ms191184.aspx#binary_byte_stream ...
I am trying to deploy a simple windows forms application using the standard Publish option in Visual Studio. I am using a SQL server compact file (.sdf) as my database. When I deploy the app and install it on a test computer, I get this error: The Path is not valid. Please check the directory for the database. and then it shows me the ...
I am trying to setup a merge replication from SQL Server 2005 to SQL Compact 3.5 sp2. My environment: - Server: Windows 2008 R2 64bit - SQL Server 2005 installed on server - IIS 7 installed on same server with IIS6 compatibility components installed - SQL Server Compact 3.5 SP2 Server Tools installed on server I create the publication ...
I'm using Visual Studio 2008 Pro. I'm probably missing something very obvious here, but I've been trying to get the CTP for Sql Server compact 4 to work in my asp.net mvc application. I can find next to no instruction on how to set this up or a working example application. My goal is a private install so I can just include it in my web ...
I have an application with multiple SqlCeResultSets, and a combobox and a datagrid on one form. I have setup the ResultSets to return subsets of the same SQL CE table, using statements like: "SELECT * FROM DLH WHERE STATUS = 'A'" "SELECT * FROM DLH WHERE STATUS = 'D'" "SELECT * FROM DLH" Which return ResultSets named DLH_A, DLH_D and ...
Does anyone know where I can find a list of supported features for SQL Server Compact Edition? I am interested in using the new version with my web app but am trying to determine if it can do what I need? specifically I want to know if it can support views and stored procedures but the microsoft site was futile. thanks in advance Edit:...