markrendle/Simple.Data — Issue #156: UpdateAll based on child table criteria
Author: morganjohnston
Created: 2012-02-22 09:49:50+00:00
State: open

UpdateAll seems to fail when part of the criteria contains a child table.

For example: db.Customer.UpdateAll(db.Customer.Order.TotalValue > 0, Status: "Active");

The generated SQL doesn't join on the child table so the statement has no idea what the order table is. The actual error message returned is: Simple.Data.Ado.AdoAdapterException : The multi-part identifier "dbo.Order.TotalValue" could not be bound.