seesharper/DbExpressions — Issue #1: Delete syntac
Author: seesharper
Created: 2011-11-22 14:28:01+00:00
State: open

Need to add more delete syntax tests as we are moving towards support for Oracle.

It turns out that Oracle can not handle joins as part of the delete statement unless they are wrapped in a sub query.

This means that something like:

```sql
delete from orderdetails od inner join orders o on o.Order = od.orderid and o.order = -1;
```

would need to be (re)written to something like:

```sql
delete from (SELECT od.* FROM orderdetails od inner join orders o on o.Orderid = od.orderid and o.orderid = -1)
```
The question is should we rewrite the expression tree or should we handle this in VisitDeleteExpression ?