Resolved ASP.NET CORE : unhandled SqlException: Invalid object name 'Users'.

[Socks93]

Hello, im currently getting to grips with ASP.NET Core and I've ended up having an issue with one of my functions within my UsersController class.

UsersController.cs

 public class UsersController : ControllerBase
    {
        private readonly IDBConnection _isqlConnection;
        private readonly DataContext _context; // here we have used dependency injection so that we can access the data from the DataContext class.
        public UsersController(DataContext context, IDBConnection connection)
        {
            _isqlConnection = connection;
            _context = context;
        }
 
        [HttpGet]
        public ActionResult<IEnumerable<AppUser>>GetUsers() // we are going to be returning a type of action result.
        {        
            return _context.Users.ToList();      
                 
        }

Startup.cs

private readonly IConfiguration _config;
        public Startup(IConfiguration configuration)
        {
            _config = configuration;
        }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<DataContext>(options =>
            {
                options.UseSqlServer(_config.GetConnectionString("DefaultConnection"));
            });
            services.AddScoped<IDBConnection, DBConnection>();
            services.AddHttpContextAccessor();
            services.AddControllers();
            services.AddSwaggerGen(c =>
            {
                c.SwaggerDoc("v1", new OpenApiInfo { Title = "API", Version = "v1" });
            });
        }

appsettings

{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=master;Integrated Security=True;Connect"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Information",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  }
}

DBConnection.cs

    public interface IDBConnection
    {
        SqlConnection GetConnection();
     
    }
    public class DBConnection : IDBConnection
    {
        public SqlConnection con = new SqlConnection(@"Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=DatingSite;Integrated Security=True");
        public SqlConnection GetConnection()
        {
            return con;
        }
    }

DataContext.cs

    public class DataContext : DbContext
    {
        public DbSet<AppUser> Users { get; set; }

        public DataContext(DbContextOptions options) : base(options)
        {
        }    
    }

AppUser.cs

    public class AppUser
    {
        public int Id { get; set; }
        public string Username { get; set; }
    }

Image of Error recieved

Does anyone have any Idea why this error might be occuring? Thanks

 

[Skydiver]

Looks like you marked the question as resolved. What what the resolution?

 

[Socks93]

Looks like you marked the question as resolved. What what the resolution?

The table that I had was named "AppUser" when it should of been "Users"