ミ★ 𝘢𝘣𝘤𝘥𝘦𝘧𝘩 ★彡
ミ★ 𝘢𝘣𝘤𝘥𝘦𝘧𝘩 ★彡
PostsComments
CC#
Created by ミ★ 𝘢𝘣𝘤𝘥𝘦𝘧𝘩 ★彡 on 7/26/2024 in #help
EF - Cannot insert the value NULL into column 'Id'
I have this entity: 
public class Address
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; init; }

    public required string AddressLine1 { get; init; }
    
    public string? AddressLine2 { get; init; }
    
    public string? AddressLine3 { get; init; }

    public string? AddressLine4 { get; init; }
    
}

public class RiskAddress : Address;

public class CorrespondenceAddress : Address;
public class Address
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; init; }

    public required string AddressLine1 { get; init; }
    
    public string? AddressLine2 { get; init; }
    
    public string? AddressLine3 { get; init; }

    public string? AddressLine4 { get; init; }
    
}

public class RiskAddress : Address;

public class CorrespondenceAddress : Address;
I try to autofixture excluding the id but i dont think that works because its int so it will always default to 0 ? - fact check me pls but the db should be handling generating its id, why do i get this error running the following test ? 
[Fact]
    public async Task CanSaveEntityAsyncManual()
    {
        var policy2 = await SetupPolicyHybrid();
        await _dbContext.Policies.AddAsync(policy2);
        await _dbContext.SaveChangesAsync();

        List<Policy> savedPolicies = await _dbContext.Policies.ToListAsync();

        Assert.Equal(1, savedPolicies.Count);
    }
[Fact]
    public async Task CanSaveEntityAsyncManual()
    {
        var policy2 = await SetupPolicyHybrid();
        await _dbContext.Policies.AddAsync(policy2);
        await _dbContext.SaveChangesAsync();

        List<Policy> savedPolicies = await _dbContext.Policies.ToListAsync();

        Assert.Equal(1, savedPolicies.Count);
    }
Microsoft.Data.SqlClient.SqlException Cannot insert the value NULL into column 'Id', table 'pas.dbo.CorrespondenceAddress'; column does not allow nulls. INSERT fails. and here is the live auto fixtured entity copied in rider: 
CorrespondenceAddress = CorrespondenceAddress
 AddressLine1 = {string} "TestAddress"
 AddressLine2 = {string} null
 AddressLine3 = {string} null
 AddressLine4 = {string} null
 Id = {int} 0
CorrespondenceAddress = CorrespondenceAddress
 AddressLine1 = {string} "TestAddress"
 AddressLine2 = {string} null
 AddressLine3 = {string} null
 AddressLine4 = {string} null
 Id = {int} 0
6 replies