sql-server-ce
Convert SQLCE database to SQL Server 2008 with WebMatrix when database size > 256Mb
I have a website with a SQLCE database which has grown to around 500Mb.There were errors with the website when the database exceeded 256Mb, which were circumvented by applying \'Max Database Size = 10[详细]
2023-04-13 05:52 分类:问答Link one row to multiple rows in another table SQL CE
okay I\'ll be as clear as I possible can, we have a supplier list that is quite frankly endless, therefore I decided to do a small app with combo boxes (C#). The app is set up such that the first com[详细]
2023-04-13 03:46 分类:问答Synchronizing Entire Databases using Microsoft Sync Framework 2.1
I need the ability to sync multiple remote databases, upload and download, with my main database. However, the problem lies in the fact that I need to sync the entire database, and the database schem[详细]
2023-04-12 13:04 分类:问答Cannot Update/Insert on a replicated table
I have defined a unidirectional publication of a table on SQL Server. On the subscriber side(SQL Compact), I need to be able to retrieve the contents of the table and modify them, BUT these modificat[详细]
2023-04-12 09:57 分类:问答SQL Compact 3.5 database - winforms app is trying to open database as read-only on 64bit machine
I have a simple winforms app (c# .net 4.0) that reads from and updates data to a sql server compact 3.5 database.[详细]
2023-04-11 18:44 分类:问答Converting a sqlite database to sdf file
Is there any tool or method present to convert my s开发者_如何学编程qlite database to (*.sdf)? I need this for porting a iPhone project to WP7.This morning a new tool (SQLite2CE) was released which ha[详细]
2023-04-11 10:32 分类:问答Create sql server compact file in appdata folder
I am developing a simple piece of software which uses Entity Framework code first and sql server compact 4. At the moment this setup works. Entity framework creates the sql server compact file if it d[详细]
2023-04-11 00:05 分类:问答What is Select 'X'?
sSQL.Append(\" SELECT \'X\' \"); sSQL.Append(\" FROM ProfileInsurancePlanYear \"); sSQL.Append(\" WHERE ProfileID = \" + profileid.ToString() + \" AND CropYear = \" + cropyear.ToString());[详细]
2023-04-10 15:55 分类:问答How to migrate schema from SQL Server 2008 to SQL Server CE 4?
Yes, the title is correct the app now needs a local database which is going to be ssce4.0 开发者_运维技巧and hence...[详细]
2023-04-10 15:48 分类:问答SQL Server CE Enterprise Library 5 Cannot pass parameters
I have an SQL CE(.sdf) database which I am trying to access from MVC3 application using MS Enterprise Library 5.0. I have referenced the SQLCE dll for Compact Edition 4.0.[详细]
2023-04-10 10:44 分类:问答