before all I must say Telerik OpenAccess is amazing ORM! I love to work with it.
But... now I have problem with object deletion. I have three tables in MS SQL 2008 database in N:M relation. Files, Baskets and BasketFiles table. I'm sending screenshot from Visual Designer where is realtion clear.
When I want to delete row from BasketFiles table, row is deleted, but still persists in cache. Another attempt to delete this object causes error. When I shut down L2 cache, everything is all right.
Here is code causing problems (it is called in ItemCommand of RadGrid) I made code a little more verbose for clarity:
basketFileToDelete = (From q
dc.BasketFiles Where q.BasketFileId = basketFileToDeleteId).FirstOrDefault
Can you, please, tell me, where could be problem? I tried also clear cache with dc.Cache.Release and dc.Cache.Release(BasketFiles) command, but with no luck.