Am trying to create login/registration functionality, I am using user manager but am having trouble figuring it out when my code hits the section where user manager is used I get this error Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AspNetUsers'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,, I have no idea what this means or implies, Ive tried looking at some resources but they've only amplified my confusion, if anyone can help or direct me I would be greatfull.
//Register method    
    public async Task<Authentication_result> RegisterAsync(string email, string password, string Username)
            {
                var exists = await _manager.FindByEmailAsync(email);
                
    
                if (exists != null)
                {
                    return new Authentication_result
                    {
                        Errors = new[] { "User with this email already exists" }
                    };
                }
    
                var newPerson = new IdentityUser
                {
                    Email = email,
                    UserName = Username
    
                };
    
    
                var Creation = await _manager.CreateAsync(newPerson, password);
      
                if (!Creation.Succeeded)
                {
                    return new Authentication_result
                    {
                        Errors = new[] { "Invalid user!" }
                    };
                }
    
                return Generate_Authentication_Result(newPerson);
            }
    
 //Login method
              public async Task<Authentication_result> LoginAsync(string email, string Password)
        {
            var exists = await _manager.FindByEmailAsync(email);
            if (exists == null)
            {
                return new Authentication_result
                {
                    Errors = new[] { "User does not exists" }
                };
            }
            var pass_validation = await _manager.CheckPasswordAsync(exists, Password);
            if (!pass_validation)
            {
                return new Authentication_result
                {
                    Errors = new[] { "f78wrvep034rf wrong" }
                };
            }
            return Generate_Authentication_Result(exists);
        }
//User module
 public class Users
    {
        [Key]
        public int Id { get; set; }
        [Required]
        public string FirstName { get; set; }
        [Required]
        public string LastName { get; set; }
        [Required]
        public string Email { get; set; }
        [Required]
        public string PreferredNet { get; set; }
        [Required]
        public string Password { get; set; }
        [Required]
        public string Number { get; set; }
        [Required]
        public int Inactive { get; set; }
        [Required]
        public int Active { get; set; }
        [Required]
        public int Max_Return { get; set; }
        public DateTime Time {get;set;}
    }
//DbSet
 public class DataContext:IdentityDbContext
    {
        public DataContext(DbContextOptions<DataContext> options):base(options)
        {
        }
        public DbSet<Users> users { get; set; }
        
       
    }
User contributions licensed under CC BY-SA 3.0