Delete from table
I am trying to use LINQ to delete from a table. I try to execute the following statement
LED_HILTON_HONORS.Delete(a => a.LEAD_ID == 10012539)
But on executing the statement I get - OracleException: ORA-01031: insufficient privileges.
I can delete using the same DB with Oracle SQL Developer so I have the permission. I am not sure if there is some extra permission check with either the driver or LINQPad?
Also once this is resolved I was wondering if there is an implicit "COMMIT"? When I delete using SQL Developer I have to remember to explicitly commit or else the deletion does not persist.