EF Table not found

I am trying to get users from a mysql db hosted on aws using entity framework, db first

This is the code i am using

public List<UserModel> Users { get; set; } = (from u in ctx.Users.DefaultIfEmpty()                                                select new UserModel                                                {                                                    id = u.id,                                                    username = u.username                                                }).ToList();  

the error i am getting is

MySqlException: Table 'ProiectMDS.ProiectMDS.Users' doesn't exist  

The table exists and has data

It also looks fine in VS

I suspect ef messed something up with the mysql connector, i may be wrong

Had this problem for over 2 hours, getting tired of it :)

https://stackoverflow.com/questions/66467566/ef-table-not-found March 04, 2021 at 10:06AM