0

Thanks to this excellent post, I was able to customize the set of OAuth2 tables for user security.

Now I need to implement DML triggers to these customized tables, such as when a user is created, updated or deleted. What I need to do is to update and manipulate certain values in these tables, and ideally through database scripts and not in VS code.

Under SSMS/IIS10, is it possible to do so? The triggers I defined are current not invoked when a user is created through the web API.

Thank you in advance for any suggestions.

Edited to add: The triggers I have in mind are INSTEAD OF INSERT, INSTEAD OF UPDATE etc.

Community
  • 1
  • 1
ltree
  • 43
  • 1
  • 1
  • 8
  • Providing more information, a scenario would be when a new user is being created, resulting in the following code called in `AccountController.cs`: `IdentityResult result = await UserManager.CreateAsync(user, model.Password); ` – ltree Dec 02 '15 at 15:59
  • So, am I missing anything and is there a way to make such a call trigger the DML trigger residing in the database? The alternative is to implement this in the C# code but this is less preferable with the existing architecture. – ltree Dec 02 '15 at 16:25

0 Answers0