When using SQL Compact on Windows Mobile, do you store the sdf file on a storage card?

Posted by Michal Drozdowicz on Stack Overflow See other posts from Stack Overflow or by Michal Drozdowicz
Published on 2010-04-26T07:57:51Z Indexed on 2010/04/26 8:03 UTC
Read the original article Hit count: 226

Filed under:

sqlcompact

|

compact-framework

|

windows-mobile

Having had some Sql Compact db corruption issues in the past and gone through the article on these, I got the idea that storing the database sdf file on a storage card significantly increases the risk of data loss due to db corruption.

Do you store the sdf file on a storage card? Have you had any issues caused by it? What should I pay attention to when recommending a particular brand or model of an SD card wrt the stability and security for use with SQL Compact?

© Stack Overflow or respective owner

Related posts about sqlcompact

No SQLCompact Edition Support IN VS 2013

as seen on Programmers - Search for 'Programmers'
Firstly apologies if this is a poor question - I am an engineer not a programmer. I have spent time moving from Visual Basic to C#. I have started C#/SQL tutorials. I have noticed VS 2013 has stopped supporting the compact edition database normally used for standalone desktop apps. Somebody has kindly… >>> More
Get id when inserting new row using TableAdapter.Update on a file based database

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database table with one field, called ID, being an auto increment integer. Using a TableAdapter I can read and modify existing rows as well as create new ones. However if I try to modify a newly inserted row I get an DBConcurrencyException: OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft… >>> More
Using Entity Framework with an SQL Compact Private Installation

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of SQL Compact with my application, so that my installer can install SQL Compact without giving the user a second installation to do. It also avoids versioning hassles down the road. My development… >>> More
Linq to SQL and SQL Server Compact Error: "There was an error parsing the query."

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a SQL server compact database (MyDatabase.sdf), and populated it with some data. I then ran SQLMetal.exe and generated a linq to sql class (MyDatabase.mdf) Now I'm trying to select all records from a table with a relatively straightforward select, and I get the error: "There was an… >>> More
Open Connection to SQL Compact File, with other Extension than .sdf

as seen on Stack Overflow - Search for 'Stack Overflow'
I just can't open this connection, if the Extension is different than .sdf. It's there a workaround (Please do not suggest, changing the extension of the File temporarily) ? Thnk u very much. Javier >>> More

Related posts about compact-framework

Getting State of Modifier Keys Compact Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I get the state of a modifier key using VB.NET on the Compact Framework, in this case Windows Mobile 6.1. I want to be able to determine if the following keys are pressed or locked: Shift CTRL ALT and for the Psion Teklogix machines Orange Blue Although I may be able to work this out, if… >>> More
Windows mobile Compact Framework SqlCeConnection

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm hearing that is better to have one connection open upon app start up and closing it when the app shuts down. What kind of issue can occur having multiple connections ? Any articles out there that it is best practices to have one connection? What are your experience with sql ce? >>> More
C#: How to set AsyncWaitHandle in Compact Framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using a TcpClient in one of my Compact Framework 2.0 applications. I want to receive some information from a TCP server. As the Compact Framework does not support the timeout mechanisms of the "large" framework, I'm trying to implement my own timeout-thing. Basically, I want to do the following: IAsyncResult… >>> More
Has MSDN Dropped Compact Framework already?

as seen on Stack Overflow - Search for 'Stack Overflow'
MSDN Documentation used to indicate if a method was supported on the compact framework. But now I can't find that info anymore. I know that Microsoft has dropped Compact Framework like a hot potato, but I did not know that they had ripped it out of the docs. As examples of what I am talking about… >>> More
Is there compilation symbol to detect compact framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a compilation symbol to detect if it's running on a compact framework platform >>> More