Having trouble working with UserManager<IdentityUser>

0

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; }
        
       
    }
c#
asked on Stack Overflow Aug 2, 2020 by Raphael Simfukwe • edited Aug 3, 2020 by Raphael Simfukwe

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0