Hands-On Mobile Development with .NET Core

SQLite.NET

SQLite.NET was one of the earliest implementations of SQLite on the Portable Class Library (PCL) platform, and it still remains one of the most popular cross-platform implementations (now targeting .NET Standard).

The implementation patterns with SQLite.NET are based on domain model entity attributes that define the entity indexes and other data columns:

public class Vehicle
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }    [Indexed]
    public string RemoteId { get; set; }    public string Color { get; set; }    public string Model { get; set; }    public int Year { get; set; }    public string AuctionId { get; set; }
}

Relationships between entities can be introduced using the attributes (for example, ForeignKey, OneToMany, and ManyToOne ...