I am doing an InserAsync and the SQL query returns the generated Id but the entity has zero for its integer identity column.
Why is it not updating the identity column? It works when it's Insert but not when it's InsertAsync. Such is life...
I used Insert without Async and returned Task.FromResult(0);
from the method.
Boom, that will learn 'em.