db.formscreators what kind of source is this, I am assuming you are firing a IQueryable query and using the EF or similar DB context. Now as per my understanding of your question:
I went to MySQL Workbench and delete a data from formscreators table
This data in the
formscreators is having either
fc.PropertyID == id ||
fc.PropertyID == 0, thus you expect it not to be seen on firing the Linq query.
Can you verify ?
- Does the database query runs an implicit transaction to ensure that DML is committed and there's no rollback or there's no FK constraint, which blocks the Record Deletion and does report an error.
- What kind of query does IQueryable executes on the MySql, a profiler will provide more details. Since first verification of the issue would be post deletion when you run the same query on My Sql directly, then also the same data shall be seen.
For a No Sql system like Mongo, where it works on eventual consistency, it could have been the case that a stale data appears, but that cannot be the case for ACID compliant RDBMS. Mostly there's a discrepancy in your data or query, please review the cases above to ensure data / query sanctity