When I try to delete the rows with an specific Id, it executes without errors but in Database the row is still there, The delete method is the one inferred I just seek what id is what im going to delete
before that llines I delete from other tables with their proper delete method, and these works fine except for that table, the next step to that is delete from the AspNetUser tables and i cant do it because of that... any ideas to check?
When I have to delete or insert into many tables, I use the methods inferred, each one has his own transaction, but can i manage a transaction that cover all operations , pass a transaction object as reference I mean, with the methods inferred or I have to manage with new ones
We are not sure why the delete is not working for you. You can check if your database is requested from delete operation.
Such functionality is not supported out-of-the-box. If you need multiple operations with single method you can create your own custom method as per our documentation: Invoke method (Blazor)
Okm thks @enchev, now i have to find out How can i check if my database is requested from delete operation, it's so rare, every delete operation works fine...i dont know what about this table.
Hi @enchev , I did a profiler process in sql about to check the delete operation in that table, and when the debug from Visual Studio executes Delete operation, what trace shows its a SELECT sentence instead of DELETE. I check another page where i have delete operations, and the profiler shows DELETE sql sentence.
You know how or where do i have to change, because that method its inferred out-of-the-box.
I’m afraid that I don’t have any idea why SELECT is executed instead DELETE. To provide more info I’ll need an application and a database where I can reproduce the problem. You can upload it to a service like Google Drive and send us the link to info@radzen.com.