database - Windows phone 8 Sqlite setup -
i started setting windows phone 8 sqlite , worked out great. installed sql windows phone extension. proceeded on adding solution (sqlite.vcxproj). after added files sqlite.cs , sqliteasync.cs. referenced sqlite windows phone in add reference , seemed fine. added use_wp8_native_sqlite build properties. (i followed -> this guide)
first had problems sqlite3 missing namespace fixed after manually adding community.csharpsqlite.sqliteclient.wp.dll, community.csharpsqlite.winphone.dll, system.data.ersatz.winphone.dll.
problem is, when insert code:
private async void createdatabase() { sqliteasyncconnection conn = new sqliteasyncconnection(path.combine(applicationdata.current.localfolder.path, "people.db"), true); await conn.createtableasync<person>(); }
i keep getting namespace name sqliteasyncconnection not found (are missing directive or assembly reference?) errors.
is happening because cannot add sqlite3 dll manualy ?( pesky "a reference higher version or incompatible assembly cannot added project" error). sqlite windows phone added reference tho.
sqliteasyncconnection conn = new sqliteasyncconnection(path.combine(applicationdata.current.localfolder.path, "people.db"), true);
next open connection
await conn.openasync(); string emppersionallinfo = "create table if not exists empinfo" + "(no int," + "name varchar(20))"; await conn.executestatementasync(emppersionallinfo);
Comments
Post a Comment