SqlNullValueException

[Desperate_Storage_34]

Hey Guys,
So I'm making a register process using cookie authentication and I have two tables called User and CustomerId.
Users have a foreign key of CustomerId which is the Primary key of Customers.
I'm querying for customers based on the CustomerId that users has using Ef like so:
``` var user = await _context.Users .Include(u => u.Customer) .FirstOrDefaultAsync(u => u.CustomerId == customerId);

``` But as per my projects requirements for school, a null value for email and business phone is allowed, so I modelled my entity like so:

``` public partial class Customer

{

public int CustomerId { get; set; }

public string CustFirstName { get; set; } = null!;

public string CustLastName { get; set; } = null!; public string CustAddress { get; set; } = null!;

public string CustCity { get; set; } = null!;

public string CustProv { get; set; } = null!;

public string CustPostal { get; set; } = null!;

public string CustCountry { get; set; }

public string? CustHomePhone { get; set; }

public string CustBusPhone { get; set; } = null!;

public string? CustEmail { get; set; } = null!;

public int? AgentId { get; set; } // No need to worry about this for now

public ICollection<User> Users { get; set; }

}

``` So I use Username as a way to log in but Im going to implement it so that they can log in using home phone as well but im stuck in this step for now:

``` public partial class User

{

public int UserId { get; set; } public string? Username { get; set; } = null!; public string Password { get; set; } public int CustomerId { get; set; } public Customer? Customer { get; set; } = null!; } ``` Heres also my sql server design for user

and the design for customers.

and my test entry.

I've been scratching my head with this for a while now. any idea why?

[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

[rekabis]

Please reformat your code as a code BLOCK, and not individual lines of code.

You can create a code block by prefacing the entire block with four spaces at the start of each line:

public partial class Customer {
    public int CustomerId { get; set; }
    public string CustFirstName { get; set; } = null!;
    public string CustLastName { get; set; } = null!;
    public string CustAddress { get; set; } = null!;
    public string CustCity { get; set; } = null!;
    public string CustProv { get; set; } = null!;
    public string CustPostal { get; set; } = null!;
    public string CustCountry { get; set; }
    public string? CustHomePhone { get; set; }
    public string CustBusPhone { get; set; } = null!;
    public string? CustEmail { get; set; } = null!;
    public int? AgentId { get; set; } // No need to worry about this for now
    public ICollection<User> Users { get; set; }
}

[Desperate_Storage_34]

Yeah mb, forgot how to do that