Enhancement: Enable the Anonymous Types and Query Objects on QueryMultiple

[mikependon]

Describe the enhancement

Currently, the QueryMultiple operation is type-coupled and even to the parameter passing. Let us say we have classes named Order and OrderItem and we would like to query all the orders and its corresponding order items via order Id, we do the following simple code.

using (var connection = new SqlConnection(...))
{
	var orderId = 10045;
	var result = connection.QueryMultiple<Order, OrderItem>(
		o => o.Id == orderId, oi => oi.OrderId == orderId);
	var order = result.Item1.FirstOrDefault();
	var orderItems = result.Item2.ToList();
}

Like with many other operations, it would be better to make it more dynamic by considering the passing of the anonymous types like below.

using (var connection = new SqlConnection(...))
{
	var orderId = 10045;
	var result = connection.QueryMultiple<Order, OrderItem>(
		new { Id = orderId }, new { OrderId = orderId });
	var order = result.Item1.FirstOrDefault();
	var orderItems = result.Item2.ToList();
}

And/or Query Objects (i.e.: QueryField and QueryGroup).

using (var connection = new SqlConnection(...))
{
	var orderId = 10045;
	var result = connection.QueryMultiple<Order, OrderItem>(
		new QueryField("Id", orderId), new QueryField("OrderId", orderId));
	var order = result.Item1.FirstOrDefault();
	var orderItems = result.Item2.ToList();
}

[mikependon]

The fixes to this will be available on the next version > RepoDB v1.10.12.