I am trying to update my database and insert values into one of the columns "LongitudinalId", but as soon as I run the update-database command in my Package Manager Console, it gives me this error:
Cannot insert the value NULL into column 'LongitudinalId', table 'TruckDbWcf.dbo.Chassis'; column does not allow nulls. UPDATE fails. The statement has been terminated.
Here is the code where I am trying to insert the data:
            context.Chassis.AddOrUpdate<Chassis>(x => x.Name,
                new Chassis { Name = "DAIHATSU DELTA V116", LongitudinalId = context.StockItems.Where(x => x.StockCode == "SCH100").First().Id },
                new Chassis { Name = "DAIHATSU DELTA V116 PLUS", LongitudinalId = context.StockItems.Where(x => x.StockCode == "SCH100").First().Id },
                new Chassis { Name = "DAIHATSU DELTA V58", LongitudinalId = context.StockItems.Where(x => x.StockCode == "SCH100").First().Id },
                new Chassis { Name = "FAW", LongitudinalId = context.StockItems.Where(x => x.StockCode == "SCH100").First().Id },
                ... //It goes on for about 100 more lines
                new Chassis { Name = "VOLKSWAGEN VW 24-250 LWB (D AXLE)", LongitudinalId = context.StockItems.Where(x => x.StockCode == "SCH110").First().Id });
Now i've already checked that I am inserting data in every single line that requires the "LogitudinalId", but I can't figure out why it's giving me this much trouble and throwing the error that I gave above.
I have also tried to delete the database as well as to delete the current data that's already in that specific table, but I am getting no where. If anyone can help, I would be very greatfull! :)
EDIT- Class where I create the table with the LogitudinalId:
public class Chassis
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int? LongitudinalId { get; set; }
    [ForeignKey("LongitudinalId")]
    public virtual StockItem ChassisLongitudinal { get; set; }
}