There are no ads in this search engine enabler service. GitHub blocks many GitHub Wikis from search engines. ℹ️About GitHub Wiki SEE, a search engine enabler for GitHub Wikis as ⚠️ ** Fallback** ⚠️ 🗂️ Page Index for this GitHub Wiki For example, if UserDto also had a list of BoatsDto, only the CarDto list or the BoatsDto list can be loaded and mapped with one query.

FetchOneToMany cannot be used to fetch nested one-to-many relationships, or multiple one-to-many relationships.

In the above example this might be x => x.CarId. This should return the property of the primary of the many object.

If you are using an outer join for your query and you are expecting that some of the many's will not be populated, make sure to use the second lambda in the FetchOneToMany call.

If you are mapping to objects that are also used for inserting data then you will need to make sure you ignore the List property using the or attribute.

In this example the query specifies u.* then c* which maps to. It must align with the order of the generic parameters defined.

The order of the columns is extremely important.

The first parameter to this method is a lambda expression which identifies the unique property of the first object.

This will give you a list of UserDto objects and for each of these the list of CarDto's will also be populated.

TableName(" Person" ) PrimaryKey(" Id" ) pu. My code looks a bit like this, and it works. 'select u.*, c.* from Users u inner join Cars c on u.UserId = c.UserId order by u.UserId ') I am using IncludeMany and the Reference attribute to get a table with the related list. IDatabase db = new Database( 'connStringName ')

Npoco idatabase updateasync