I have a database table which has IsActive attribute. Only one row in the table can have True for IsActive at a time. What's the appropriate solution to this problem in ADF?
In the ADF side, I have a button called Activate, when the button is clicked, I can set IsActive to true of selected row but I need to set false to other rows. Should I iterate all of the rows? or is there a better solution?