How to decrypt the SQLite database content in windows phone 7 application?

I am developing the window phone 7 application. I am new to the window phone 7 application. I am using the SQLite database in my application to store & retrieve the data. I am using the following link for database connectivity.

http://wirebear.com/blog/2010/11/12/using-sqlite-in-your-wp7-app

I have followed all the steps given in the article. In the coding section I am getting an error in the following function.

public List<T> SelectList<T>(String statement) where T : new()
        {
            Open();
            SQLiteCommand cmd = db.CreateCommand(statement);
            var lst = cmd.ExecuteQuery<T>();         
            return lst.ToList();
        }

At the lst.ToList(); statement I am getting the error that 'file is encrypted or is not in database'. Can you please tell how to decrypt this database file if it is encrypted ?. Can you please provide me any code or link through which I can resolve the above issue ? If I am doing anything wrong or misunderstood anything then please guide me.

For example in case of PhotoChooserTask class we copy the content into the isolated storage & then read it back but before that we decode it as follows

var fileStream = store.OpenFile("image.jpg", FileMode.Open, FileAccess.Read);
var imageAsBitmap = PictureDecoder.DecodeJpeg(fileStream);

Answers


That message is a standard error one when SQLite can't open the database file. It doesn't necessarily mean the database is encrypted, indeed it almost certainly isn't unless you've specifically tried to encrypt it. It just means the file you're accessing is not a valid normal SQLite database file.

Did you go wrong somewhere earlier, in creating the file or trying to open the wrong file path ?


Need Your Help

C how to “hide” macros from main scope

c inheritance struct scope unions

if have a routine like this which I want the main application to access...

Async query throws AssertionError first time (AppEngine, NDB)

python google-app-engine app-engine-ndb

When I use fetch_async() on a query it crashes with AssertionError the first time it is run. If I run it again immediately, it's fine.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.