Support Update...Where

[worldspawn]

• Linq Expression Parser
• T-Sql Language Processor
• Postgres Language Processor
• Query Api

[worldspawn]

Add support for deleting of entities that match a set of criteria. You do not to hydrate anything to use this.

In otherwords:

UPDATE [Entity]
Set Foo = 'Bar'
WHERE ...

as well as

UPDATE [Entity]
Set Foo = 'Bar'
FROM [TEntity]
JOIN ...
WHERE ...

I think this can run on top of the query system. The simple example might be:

session.Update<Order>((o) => o.DateCreated < DateTime.UtcNow, (o) => o.Foo = "Bar", (o) => o.Bar = "Foo");

or

session.Update<Order>((o) => o.DateCreated < DateTime.UtcNow, (o) => new Order { Foo = "Bar", Bar = "Foo" });

With joins

session.Update<Order>((ot) => ot.Join<OrderItem>((o, oi) => oi.OrderId == o.Id).Where(o => o.DateCreated < DateTime.UtcNow), (o) => new Order { Foo = "Bar", Bar = "Foo" });

In relying on an object constructor the entity would need a parameter-less constructor... or would it? I guess any constructor would be ok. Its parameters would be ignored?