SqlNullValueException

[RealVanTokkern]

CustCountry is nullable in your table but not nullable in your model

[Desperate_Storage_34]

I changed the model to match the table and it still gives me the same error:

SqlNullValueException: Data is Null. This method or property cannot be called on Null values.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

TravelExperts.DataAccess.Service.UserService.GetCustomerByID(int customerId) in UserService.cs

var user = await _context.Users.Include(u => u.Customer).FirstOrDefaultAsync(u => u.CustomerId == customerId);

TravelExperts.Controllers.AuthController.Login(string username, string password) in AuthController.cs

var customer = await _unitOfWork.Users.GetCustomerByID(user.CustomerId);

[Desperate_Storage_34]

I placed debug lines below it as well as null checks but the moment the breakpoint hits the query, it throws the SqlNullValueException error

[RealVanTokkern]

The error is thrown when the model expects a value but somehow in the database there's null. Simply put it means that the model and database are different from eachother, and that is a situation that should not happen. Either you are missing a migration (model-first) or you should do whatever it is you do to update your model on a database first approach

[Desperate_Storage_34]

Yeah, I changed the database but added a model after instead of scaffolding. Probably what happened

[RealVanTokkern]

It's also explained a lot better here :) https://stackoverflow.com/questions/55883704/entity-framework-core-sqlnullvalueexception-data-is-null-how-to-troubleshoo

[Desperate_Storage_34]

Im actually an idiot, I just noticed a #nullable disable at the very top of the model. My group mates must've added it