Here I get to demonstrate my laughable understanding of Linq...

I added an owner to a workflow I created. That worked fine. Then I went back to edit the description, and got the "The name must be unique." error.

I took a look at ENTWFOwnerGroupData.IsNameUnique, to see what it was returning:

return (result.Single().CountOfNames == 0);

Shouldn't that line actually be return (result.Single().CountOfNames <= 1);?

Otherwise any update on an existing owner will fail.

Unless there's something else I'm missing?

Thanks.

Tim

I should have ran one more test - adding a new owner with an existing name.

That one crashed the program (violation of the unique constraint on the table's index) - because the IsNameUnique test returned true.

Now that I've shown my ineptitude :) - any ideas on what's going wrong in my code?

Thanks.

Tim

Ok...finally figured out the problem.

I was really confused as to why the ENTWFOwerGroupSelectCountByNameWorkflowId had ENTWFOwnerGroupId as a parameter, until I compared my version of the stored proc with Vince's.

My version had ENTWFOwnerGroupId = @ENTWFOwnerGroupId in the WHERE clause.

Vince's version had ENTWFOwnerGroupId <> @ENTWFOwnerGroupId.

I fixed my proc and it now works as advertised.

I hate simple mistakes like that....

Tim