I don't know why it's is error on SaveChanges(), i search in google, some body say using EF, the database's table such have primary key, i have this, but still error. The error message is not enough clear,it just throws System.Data.UpdateException. The Code: public static void AddAccount(int _acc_id,string _name) { dataEntities de =...
Hi all I'm developing a WPF application, and some guidance would be appreciated. The application needs to store some data locally. The data doesn't need to be shared, but multiple users can log into the application, each with a different profile. Can anyone advise me on the wisdom of using the Entity Framework 4.0 with SQLCE in this con...
What are the differences, other than a file size restriction in SQL Server Compact, and Windows only usage? ...
Hi can someone show me how I can use the SqlCeResultSet.Seek method with a composite index? I am trying to seek on orderno+product code my sqlce table has the following index: CREATE INDEX orderline_idx ON OrderLines ( orderno,item ) My seek code is public bool SeekDeliveryLine(string delnote,string item) { bool isF...
I know ways to script a SQL CE Database, but does anyone know a way to diff two databases and output a script sync one of them to the other (ie generate drops and inserts to make them the same). I am looking for a way that I can update my hand held applications without having to copy over the existing database. The first step is to be ...
Will SQL 4 have full-text search capabilities? Can't find anything in blogs (including Scott Gu). Thanks. ...
I've got a SQL Server CE 3.5 table (Transactions) with the following Schema: ID Transaction_Date Category Description Amount Query: SELECT Transaction_Date, SUM(Amount) FROM Transactions GROUP BY Transaction_Date; I'm trying to do a SUM(Amount) and group by transaction_date just so I can get the total amount for each day b...
Background - If I am building a WPF desktop application (VS2010 & .NET 4) and would like a lightweight database to use but without having to have a separate installation. SQLite would be OK from what I read however I was thinking it would be good to stick with the Microsoft bits and try to use SQL Server CE. Question - Does SQL Server ...
hi after i make some query's in my C# program (Windows-CE)-the program start to be heavy..... i use: dsView.dispose() and dsView.clear() or Cmd.dispose() after and still the program work's very slow after 20-30 query's ds = new DataSet(); SQL = "SELECT * FROM MyCount where Name = '" + txtMakat.Text.Trim() + "'"; ...
I want to execute the following query on compact but I know it doesn't have the collate function. I'm looking for another way to accomplish the below query with sql. select CHARINDEX('a','ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'COLLATE Latin1_General_CS_AS) I am very locked into this clients development tool an...
I am using SqlServer Compact 3.5 (2008) and am trying to return rows that have a datetime field that is today or previous. This is the code I am trying, but it is throwing an exception. (in the Where clause) I'm new to SQL so I'm having trouble with this one. Any ideas? If you need more data, let me know. string selectStatement = "S...
I'm trying to write to a data base, I have been working of the following site. In particular the LoadARow function. I have been getting the runtime error "System.IndexOutOfRangeException: A SqlCeParameter with ParameterName 'Value' is not contained by this SqlCeParamaterCollection. The error references the line "command.Paramet...
Dose windows mobile 6 SDK support sqlserverce database operations into MFC smart device application? I can create database on sqlserverce using COM components, but I dont want to use it instead will prefer windows mobile 6 SDK. Is it possible? ...
hi I have this database: abcDEF ABCdef abcdef if I write: select * from MyTbl where A='ABCdef' how to get: ABCdef and how to get: abcDEF ABCdef abcdef Thanks in advance forgot to write - sqlCE ...
I need to Export a table from SQL Server Compact 3.5 Table (*.sdf File) to an excel in Windows CE in a C# application. Can any one please help me? Is There Any easier way then querying all the data and then parsing it to an excel sheet? ...
hi i have 2 tables that has the same fields i need to combine 2 tables to 1 table how to do it in sqlCE ? thank's in advance ...
What to select in catalog in platform builder to include SQL CE in image for windows CE. I have selected Application and Services Development->Sql Compact but it is still giving following error. File or assembly name "system.data.sqlserverce version=3.5.0.0, culture..." or one of its dependencies, was not found While digging further...
I am working on Sql server CE 2005. I have created a Database in Sql server CE 2005 now I want to get the scripts so that can use that further??? Is there any way to get create scripts from SQL server CE 2005 dataBase.. ...
I am work on smartApplication, Here when am trying to connect to my SQL Server CE 2005 database, I get the exception The path is not valid. Check the directory for the database. [ Path = D:\SmartProject\DBFile.sdf ] My connection string is Data Source=D:\SmartProject\DBFile.sdf;Password=test123 and the code to connect is like stri...
I have a Desktop application that uses Linq To SQL as the DAL. It accesses a local SQL Express DB. If I have a SQL CE DB that has the Exact same schema(table structure) can I re-use the generated dbml with just giving it a different connection string? ...