Load(T, WhereT)

[mk3008]

Allows upper brain search conditions to be specified.
The return value will be a collection, so name the function "Loads".
The function definition assumes the following.

List<T> Loas <T, WhereT>(Predicate<WhereT>)

T is the starting type. WhereT is the upper layer type when viewed from T.

Usage example

List<book> Loads <book, author>(x => author_id == 1);

Generated SQL

select
*
from
book
inner join author on book.author_id = author.author_id
where
author.author_id = 1

WhereT does not need to be the immediate parent; it can be any number of layers above.
However, the search condition is restricted to the primary key.
(It's not necessary, but I'm mainly using key search)

After writing this, I thought that after loading, it is necessary to use Author for the saving process. If so, it is difficult to use if it is not returned as Author when reading. Therefore, I think the following functions are easier to use.

Usage example

author Load <author, book>(x => author_id == 1);

Generated SQL

select
*
from
book
inner join author on book.author_id = author.author_id
where
author.author_id = 1