jeudi 25 juin 2015

Serializable data types in SQLite.net

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 now I don't store that property in the DB but use another property as workaround.

[Ignore]
public Date Date { get; set; }

[PrimaryKey]
public DateTime DateInternal
{
    get { return Date.ToDateTime(); }
    set { Date = new Date(value); }
}

While this works fine I feel this is not the best way to do that.

Actual Question: How can I improve that. I.e. How can I store a serialized version of Date directly. It should be in a way so that Date can be used as primary key. It is not important to me to have all the properties in Date available in single columns in a table. I want to store Date itself in just one column.

Current Research: In an attempt to Google for an answer I stumbled upon SQLite.net's ISerializable interface but I'm unsure how to use it as it only has a serialize method but no deserialize method.

namespace SQLite.Net
{
    public interface ISerializable<T>
    {
        [PublicAPI]
        T Serialize();
    }
}

Aucun commentaire:

Enregistrer un commentaire