I am getting error while update-database command to make tables related to Identity. column parameter or variable:cannot find data type datetimeoffset

Question

I try to update the database to make tables related to Identity, and I'm using Microsoft.AspNetCore.Identity, autogenerated public class IdentityUser, when I write the command, I recieve this error: Column, parameter, or variable #14: Cannot find data type datetimeoffset.

I'm using MVC .net 5 and SQL Management Studio 19

from the migration file: ' LockoutEnd = table.Column(type: "datetimeoffset", nullable: true),' here is the problem — Denisa-Maria, Jun 19 '23 at 19:20
Data Type DateTimeOffset is not supported. You must use datetime,LockoutEnd = table.Column(type: "datetime", nullable: true), — abolfazl sadeghi, Jun 19 '23 at 19:27

score 0 · Answer 1 · answered Jun 19 '23 at 19:28

0

You can just use datetime instead of datetimeoffset.

answered Jun 19 '23 at 19:28

JustSoni

13
3

I am getting error while update-database command to make tables related to Identity. column parameter or variable:cannot find data type datetimeoffset

1 Answers1