Create table in .net core.

Rohan

4y1.1kC#

Hello everyone I'm new in .net core. Please let me know how to create a table for userHistoryLogin. So Please let me know how to create this table using migration.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
There are multiple ways, and database has nothing to do with .NET Core/Framework.
so, simply on your users table create one trigger as
CREATE TRIGGER [update_history] ON YourUsertable
FOR UPDATE
AS
INSERT userHistoryLogin (id, ModifiedDate, action, userId)
SELECT id, GETDATE(), inserted.userId
FROM MyTable
    Join inserted
        On inserted.id = YourUsertable.id

INSERT userHistoryLogin (id, ModifiedDate, action, userId)
SELECT id, GETDATE(), userId
FROM inserted
Santosh Karanam4y ago
Please check
1. https://www.c-sharpcorner.com/article/understanding-entity-framework-core-and-code-first-migrations-in-ef-core/
2. https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/?tabs=dotnet-core-cli

Importent commands
dotnet ef migrations add UserLoginHistorydotnet ef database update