I have a simple select query in linq:
var forms = (from fc in db.formscreators
where fc.PropertyID == id || fc.PropertyID == 0
orderby fc.FormName ascending
I went to MySQL Workbench and delete a data from formscreators table; however, the LINQ still returning the delete data. Why is it happening? How can I fix it?