jeudi 10 décembre 2015

SQLite-net: Duplicate column name when creating table

I'm trying to create a table in my local SQLite database made with the library found at http://ift.tt/N2Zw7h

I've managed to set up the database, but when I add a table by calling...

database.CreateTable<Session>();

...I get the following error:

[ERROR] FATAL UNHANDLED EXCEPTION: NUnit.Framework.Internal.NUnitException: Rethrown ---> SQLite.SQLiteException: duplicate column name: PersonNumber

Here's the class that I'm trying to store:

public class Session
{
    public Session()
    {

    }

    public Session(string personNumber, Order order, Orderlist orderlist)
    {
        PersonNumber = personNumber;
        Order = order;
        SerializedOrder = _orderSerializer.Serialize(Order);
        Orderlist = orderlist;
        SerializedOrderlist = _orderlistSerializer.Serialize(Orderlist);
    }

    [PrimaryKey]
    public int ID { get; set; }

    public string PersonNumber { get; set; }

    public string SerializedOrder { get; set; }

    public string SerializedOrderlist { get; set; }

    [Ignore]
    public Order Order
    {
        get
        {
            if (Order == null) Order = _orderSerializer.Deserialize(SerializedOrder);
            return Order;
        }
        private set { Order = value; }
    }

    [Ignore]
    public Orderlist Orderlist
    {
        get
        {
            if (Orderlist == null) Orderlist = _orderlistSerializer.Deserialize(SerializedOrderlist);
            return Orderlist;
        }
        private set { Orderlist = value; }
    }

    private static XmlStringSerializer<Order> _orderSerializer = new XmlStringSerializer<Order>();
    private static XmlStringSerializer<Orderlist> _orderlistSerializer = new XmlStringSerializer<Orderlist>();
}

Aucun commentaire:

Enregistrer un commentaire