search

Paymentsense / Dapper.SimpleLoad

Dapper.SimpleLoad
MIT License
13 stars 4 forks source link

Add ability to tweak type of JOIN emitted by SimpleLoad #1

Open bartread opened 8 years ago

bartread commented 8 years ago

At the moment all AutoQueries result in the generation of LEFT OUTER JOINs. In many cases this is what you want for many CRUD situations, however there are obviously situations in which you many only want to INNER JOIN. For example, if you wish to take some action or perform some calculation/apply some business rule on the basis of some set of child objects.

I can't currently think of a reason why you'd want to RIGHT OUTER JOIN (or, even more unlikely CROSS JOIN or CROSS APPLY), although undoubtedly such situations exist.

It would be handy to have some way of indicating which type of JOIN (or possibly JOINs) you'd like SimpleLoad to generate.

bartread commented 8 years ago

Specific situation I had in mind (Paymentsense related) is calculating merchant status on the basis of their application statuses, but you obviously only care about applications where so far some status has been recorded.