TestDb.cs

using System;
using System.IO;

#if NETFX_CORE
class DescriptionAttribute : Attribute
{
    public DescriptionAttribute (string desc)
    {
    }
}
#endif

namespace SQLite.Tests
{
	[Table("Account")]
    public interface IAccount
    {
        int Id { get; set; }
        string Name { get; set; }
        DateTime CreatedOn { get; set; }
    }

    public class Account : IAccount
    {
        #region Implementation of IAccount

        public int Id { get; set; }
        public string Name { get; set; }
        public DateTime CreatedOn { get; set; }

        #endregion
    }


    public class Product
    {
        [AutoIncrement, PrimaryKey]
        public int Id { get; set; }
        public string Name { get; set; }
        public decimal Price { get; set; }

        public uint TotalSales { get; set; }
    }
    public class Order
    {
        [AutoIncrement, PrimaryKey]
        public int Id { get; set; }
        public DateTime PlacedTime { get; set; }
    }
    public class OrderHistory {
        [AutoIncrement, PrimaryKey]
        public int Id { get; set; }
        public int OrderId { get; set; }
        public DateTime Time { get; set; }
        public string Comment { get; set; }
    }
    public class OrderLine
    {
        [AutoIncrement, PrimaryKey]
        public int Id { get; set; }
        [Indexed("IX_OrderProduct", 1)]
        public int OrderId { get; set; }
        [Indexed("IX_OrderProduct", 2)]
        public int ProductId { get; set; }
        public int Quantity { get; set; }
        public decimal UnitPrice { get; set; }
        public OrderLineStatus Status { get; set; }
    }
    public enum OrderLineStatus {
        Placed = 1,
        Shipped = 100
    }

    public class TestDb : SQLiteConnection
    {
        public TestDb (bool storeDateTimeAsTicks = true) : base (TestPath.GetTempFileName (), storeDateTimeAsTicks)
        {
            Trace = true;
        }

        public TestDb (string path, bool storeDateTimeAsTicks = true) : base (path, storeDateTimeAsTicks)
        {
            Trace = true;
        }
    }

    public class TestPath
    {
        public static string GetTempFileName ()
        {
#if NETFX_CORE
            var name = Guid.NewGuid () + ".sqlite";
            return Path.Combine (Windows.Storage.ApplicationData.Current.LocalFolder.Path, name);
#else
            return Path.GetTempFileName ();
#endif
        }
    }
}