OpenNETCF.ORM Framework

    [Entity(KeyScheme = KeyScheme.Identity)]
    public class Author
    {
        [Field(IsPrimaryKey = true)]
        public int ID { get; set; }

        [Field]
        public string Name { get; set; }

        [Reference(typeof(Book), "AuthorID")]
        Book[] Books { get; set; }
    }

    [Entity(KeyScheme = KeyScheme.Identity)]
    public class Book
    {
        [Field(IsPrimaryKey = true)]
        public int ID { get; set; }

        [Field]
        public int AuthorID { get; set; }

        [Field]
        public string Title { get; set; }
    }

// insert an author
var dumas = new Author() { Name = "Alexadre Dumas" };
store.Insert(dumas);

// insert a couple books.
// note that we're inserting the foreign key value
store.Insert(
    new Book()
    {
        AuthorID = dumas.ID,
        Title = "The Count of Monte Cristo"
    });

store.Insert(
    new Book()
    {
        AuthorID = dumas.ID,
        Title = "The Three Musketeers"
    });

// now get the authors back, telling ORM to fill the references
var authors = store.Select<Author>(true);

// at this point you will have 1 Author instance, with the Books property hydrated and containing two Book instances