Add Reference to System.Data.SQLite[WP7 phonegap 2.2.0]

[Constant Seeker]

Hi Everyone,

  I am building app for Windows phone 7 using phonegap. As WebSql is not supported in Windows Phone, I have Added reference to " Community.CsharpSqlite.WP.dll "  and writing plugin to perform all DB Operations.

Issue is: I am not able to use SQLiteDataReader for reading data but not able to import System.Data.SQLite. I tried to Add reference to System.data.sqlite.dll but prompts the following Error:

"System.Data.SQLite.dll was not built using Windows phone runtime. Windows phone projects will work only with windows phone assemblies. " Below attached image is showing the exact error. 

There are few resources which suggests to use using Mono.Data.Sqlite;  If anybody has used this, kindly guide me the process how to use this namespace. 

I just want to use SQLiteDataReader for reading data using C# [i m writing plugin for specific db requirements in c#]. 

Kindly help, stuck on a bad node. 

Thanks in Advance !

[Madhur Trivedi]

Attached image is showing error.

--
-- You received this message because you are subscribed to the Google
Groups "phonegap" group.
To post to this group, send email to phon...@googlegroups.com
To unsubscribe from this group, send email to
phonegap+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/phonegap?hl=en?hl=en
 
For more info on PhoneGap or to download the code go to www.phonegap.com
 
To compile in the cloud, check out build.phonegap.com
---
You received this message because you are subscribed to a topic in the Google Groups "phonegap" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/phonegap/bQQtduzC3E0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to phonegap+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Jesse]

Are you sure that library supports Windows Phone 7, it looks like it might be WinPhone ... I would ask your question on their mailing list as well.

@purplecabbage

risingj.com

You received this message because you are subscribed to the Google Groups "phonegap" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phonegap+u...@googlegroups.com.

[Madhur Trivedi]

Jesse,
Sorry, didn't understood exactly. Is there a difference bw WinPhone & Windows Phone 7. I m using windows phone sdk with wp7.1.

Well I did gave reference to SQLiteClient dll i.e. Community.CsharpSqlite.WP and Create, insert and delete ops are working fine. But not able to select data as SQLiteDataReader not present. Just need to use System.Data.SQLite .

There are examples I had seen where people are using DataReader, Like the one it is shown here : http://zetcode.com/db/sqlitecsharp/read/

Thanks !