The emulator is always reset when you close / start it. You may have noticed that also your "installed" apps are gone. This doesn't occure on real devices.
Bart you could use one of my projects posted that saves/loads the isolatedstorage associated to the app to the computer using WCF(there is also the source code) . Anyway Microsoft considered that app that sell on the Marketplace are more important than libraries so I don't have a real device for testing :(. Pretty disappointed but that's the way the cookie crumbles. I will buy one when it hits the market.
I got a problem about asia character in 'like' searching. I try to search a chinese word ,ex: select * from orders where customername like '陳志%' ,the result numbers always zero.but i try to execute the sql in visual studio (using the other ado.net sqlite provider) ,the result is work!! why? please help me!! thanks
How can I retreive data from db?? I use a SELECT... but, how I can insert the result of my query into some variable? In Desktop programming I use DataReader for example...
Great work!
ReplyDeleteDo you have any plans to completely implement a client? Or will this stay just a proof of concept?
When I shutdown the emulator and start it up again my database is gone. Have you experienced the same behavior on a real device as well?
ReplyDeleteI'm going to have a look at the code now to see whether I can track what the designed behavior is.
The emulator is always reset when you close / start it.
ReplyDeleteYou may have noticed that also your "installed" apps are gone.
This doesn't occure on real devices.
Yeah I noticed that too. It is sometimes quite annoying to test on the emulator. I would really like to have a real device to test on.
ReplyDeleteI would need a real device for implementing/testing otherwise there the library could be unusable on a real device (especially on the speed aspect)
ReplyDeleteBart you could use one of my projects posted that saves/loads the isolatedstorage associated to the app to the computer using WCF(there is also the source code) . Anyway Microsoft considered that app that sell on the Marketplace are more important than libraries so I don't have a real device for testing :(. Pretty disappointed but that's the way the cookie crumbles. I will buy one when it hits the market.
ReplyDeleteI'm afraid that it seems to be impossible for this version to open files in the latest emulator :(
ReplyDeleteThe problem seems to be that this plugin can't read SQLite databases correctly, only databases created with the library is working so far.
ReplyDelete@Sir.Haxalot, I too had this problem. But seems like on WP7, even "Select" statements work only when you copy the database to IsolatedStorage.
ReplyDeleteCopy it and then it is working properly now.
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteupdate query is not working, ie. executes successfully, but no change in table. why?
ReplyDeleteSame here. Is there an solution?
DeleteBest regards
Klaus
Are there any updates to this project? This rocks!
ReplyDeleteHi,
ReplyDeleteIs it possble to connect with this client to an online database?
I want to do some synchronazation with and online database, but I dont know kow to do that.
hi,dear sir:
ReplyDeleteI got a problem about asia character in 'like' searching.
I try to search a chinese word ,ex: select * from orders where customername like '陳志%' ,the result numbers always zero.but i try to execute the sql in visual studio (using the other ado.net sqlite provider) ,the result is work!! why? please help me!! thanks
How can I retreive data from db?? I use a SELECT... but, how I can insert the result of my query into some variable? In Desktop programming I use DataReader for example...
ReplyDeletehow i embed database file in windows phone application
ReplyDelete