Hello, I'm writing a standalone application and I thought using Entity Framework to store my data. At the moment the application is small so I can use a local database file to get started. The thing is that the local database file doesn't have the ability to auto generate integer primary keys as SQL Server does. It's not a problem de...
Can I reuse an existing result set to filter? Lets say I have a result set that contains all data. Then I want to filter that resultset. Can I just execute the sqlcommand on the same resultset? I tried and it didn't seem to work. Does someone know the reason? So the only way to make it work was to create a new resultset and execute...
Hello, Our team is currently working on a WPF Desktop application with ActiveRecord and SQLCE 3.5 for backend. We've been experiencing some strange performance issues when executing queries or creating/updating records. In some cases opening a form which has a few grids and data elements that need to be populated, can take around 2 seco...
I'm using the Microsoft Sync Framework version 2 to synchronize data between a server database running SQL Server 2008 and a SQLCE 3.5 database on an occasionally connected WPF app. This is working fine for the most part, but rows from a particular table don't seem to be getting pushed back up to the server database when inserted on the...
From what I can see the drivers for SQL Server CE 3.5 for .Net and below do not support system.transactions. Has this changed for the new version of SQL CE version 4. ...
Hi All Does anyone know a way of viewing and editing an existing SQL CE 4.0 databse? I've tried using SQL Server 2008 but it looks as if it only supports version 3.5. I read on Scott Guthrie's blog that you can use WebMatrix but I can't figure out how. The blog article is located here: http://weblogs.asp.net/scottgu/archive/2010/07/1...
How do I deploy SQL CE 4.0 with EF4 to a shared hosting provider for ASP.NET MVC 2.0? I've included System.Data.SqlServerCe.dll, and the amd64 + x86 directories in my bin folder, but keep getting a ".net provider not found". I realize it's currently in CTP, but this is just for testing purposes. My project + host is configured for .net ...
I have a .Net 3.5 mobile project which i try to run on a casio DTX-30 machine. But when my CacheCollections function is running, the database file is corrupted. My function contains these codes: Friend Sub CacheCollections() If Not cachedCollections Then CustomerRevenueTypeFacade.FillAllItems(CustomerRevenueTypeCollection) ...
I have some code that needs to be able to find the version number of an assembly, given a string saying where it's located. I can't get this to work: Assembly assembly = Assembly.LoadFrom("\\Program Files\\Microsoft SQL Server Compact Edition\\v3.5\\sqlcecompact35.dll"); throws a System.IO.IOException: File or assembly name '\Progra...
I would like access a sql express db in multiple projects, a dynamic data project to administrate the data and a console application which fetches the data from the db, is there an option to do this? or should I use a SQL CE for this kind of scenario? ...