What limitations are there on data types used in a class that will be used by SQLite-net to represent a table? Specifically, can I use this: public List<string> CoconutWaterBrands { get; set...

Introduction: In a SQLite.net powered SQLite database (on WP8.1 SL, but this shouldn't matter here) I'm adding data based on a given object. This object contains a custom type called Date. Until no...

I would like to know how to use reflection in C# to call the following method : public static List<T> GetAllWithChildren<T> (this SQLiteConnection conn, Expression<Func<T, bool&...

Hi I have a problem with retrieving datetime from SQLite database using sqlite-net library. Db column is of type DATE, example date in one of records is: 2013-08-02 I have a model: internal class...

We changed from sqlite-net to sqlite.net PCL edition. Our project worked fine with the old one - with the PCL edition, we now have to explicitely declare our platform by using. var conn = new SQLit...

I used to open my SQLiteConnection in my shared project as following: var conn = new SQLiteConnection("MyDb.db3"); The constructor has been changed to the following signature: public SQLiteCon...

I am using SQLite-Net PCL together with SQLite-Net extensions for the development of an application using Xamarin. In my model I have two entities, let us call them A and B, that are connected by ...

I'm having difficulty trying to implement an SQLite-Extensions example for Windows Phone 8.1 that features a OneToMany relation. I'd really like to use this feature but I'm pulling my hair out tryi...

I'm trying to port an iOS application that uses native Sqlite3 and makes heavy use of SqliteDataReader. On the target platform I use SQLIte-Net (https://github.com/praeclarum/sqlite-net) and there ...

Trying to develop a Windows 8.1 Store App. Amongst other difficulties, I need to retrieve records from a sqlite database with two parameters on the where clause. I can successfully query with one p...

I'm new to creating a Windows Store app and it requires a use of a database. I've settled for sqlite and am using the sqlite-net package. However, I'm unsure of how to create a m2m relationship bet...

I'm using SQLite in my project and to connect to DB I use sqlite-net library. I have created a model: internal class Product { [PrimaryKey, AutoIncrement] public int Id { get; set; } public st...

If I use SQL Server CE for windows phone I can select which properties of a class map to database tables. This allows me to have abstract properties on a class. for instance [Table] public clas...

I'm using SQLite-net (https://github.com/praeclarum/sqlite-net) for implementing a database using Mono on Android and have the following: public class DatabaseTestASync { private SQLiteAsyncConne...

I am currently writing a Windows Store Application for Windows 8 and I am using SQLite for the persistence on the embedded database in a class library for windows apps. I am trying to join data fro...

Using this code: public void InsertPlatypiRequestedRecord(string PlatypusId, string PlatypusName, DateTime invitationSentLocal) { var db = new SQLiteConnection(SQLitePath); { db.CreateTable<...

In the commented-out line below, PlatypusId is red/not recognized, although it does exist in the corresponding table. In the multi-line spanning assignment to queryResult, PlatypusId, where, and c...