System.Data.Entity.Infrastructure.DbUpdateException #641

10 Answer(s)

• 

  0

  hikalkan created 8 years ago

  Support Team

  Hi,

  Actually, it says the reason: "Foreign key violation [IpProperties :: CountyId]. The key value [3] does not exists in the referenced table [IpCounties :: Id].." Have you checked it?

  Save Cancel
• 

  0

  nipunjoshi created 8 years ago

  Hi, Actually those values are there. Really strange.What could be the other reason for this ? Please see the images.

  

  

  Save Cancel
• 

  0

  hikalkan created 8 years ago

  Support Team

  Unit tests does not run in the real database. It works in-memory database. So, probably this data does not exists in your initial test data.

  Save Cancel
• 

  0

  nipunjoshi created 8 years ago

  It's there on the seed data also. Then why's that ? Please see that below. Thanks.

  Note : the exception happens here in the below class : _context.SaveChanges();

  InitialPropertiesCreator.cs

  public class InitialPropertiesCreator
      {
          private readonly IpDbContext _context;
  
          public InitialPropertiesCreator(IpDbContext context)
          {
              _context = context;
          }
  
          public void Create()
          {
              var dist1 = _context.Properties.FirstOrDefault(p => p.Dist == "dist1");
              if (dist1 == null)
              {
                  _context.Properties.Add(
                      new Property
                      {
                          IsVacant = true,
                          IsPropertyToConsider = false,
                          Dist = "dist1",
                          Sec = "sec1",
                          Blk = "blk1",
                          Lot = "lot1",
                          Lot2 = "lot2",
                          Mls = "mls1",
                          Priority = "priority1",
                          Tfmv = "Tfmv1",
                          Fmv = "Fmv1",
                          Construction = "Construction1",
                          Bid = "Bid1",
                          ListingPrice = 12.25m,
                          Contact = "Contact1",
                          DeedDate = DateTime.UtcNow,
                          TransferTax = 12.9m,
                          OriginalPurchasePrice = 45.6m,
                          Taxes = 85.3m,
                          TotalValuation = 41.2m,
                          Ev = 47.3m,
                          BuyBackAmount = 50.2m,
                          CountyId = 3,
                          PropertyClassId = 1,
                          SchoolDistrictId = 1,
                          StatusId = 1,
                          Address = new Address
                          {
                              StreetName = "1st Street",
                              StreetNumber = "1581",
                              CityId = 1,
                              StateId = 1,
                          },
                          PurchasedById = 1,
                          ShowId = 1,
                          CodeId = 1,
  
                      });
              }
  
              var dist2 = _context.Properties.FirstOrDefault(p => p.Dist == "dist2");
              if (dist2 == null)
              {
                  _context.Properties.Add(
                      new Property
                      {
                          IsVacant = true,
                          IsPropertyToConsider = false,
                          Dist = "dist2",
                          Sec = "sec2",
                          Blk = "blk2",
                          Lot = "lot2",
                          Lot2 = "lot3",
                          Mls = "mls2",
                          Priority = "priority2",
                          Tfmv = "Tfmv2",
                          Fmv = "Fmv2",
                          Construction = "Construction2",
                          Bid = "Bid2",
                          ListingPrice = 12.25m,
                          Contact = "Contact2",
                          DeedDate = DateTime.UtcNow,
                          TransferTax = 12.9m,
                          OriginalPurchasePrice = 45.6m,
                          Taxes = 85.3m,
                          TotalValuation = 41.2m,
                          Ev = 47.3m,
                          BuyBackAmount = 50.2m,
                          CountyId = 4,
                          PropertyClassId = 2,
                          SchoolDistrictId = 2,
                          StatusId = 2,
                          Address = new Address
                          {
                              StreetName = "2nd Street",
                              StreetNumber = "1582",
                              CityId = 2,
                              StateId = 2,
                          },
                          PurchasedById = 2,
                          ShowId = 2,
                          CodeId = 2,
                      });
              }
  
              _context.SaveChanges(); // it gives the exception here
          }
      }
  

  InitialCountiesCreator.cs

  public class InitialCountiesCreator
      {
          private readonly IpDbContext _context;
  
          public InitialCountiesCreator(IpDbContext context)
          {
              _context = context;
          }
  
          public void Create()
          {
              var county1 = _context.Counties.FirstOrDefault(p => p.Name == "Orange");
              if (county1 == null)
              {
                  _context.Counties.Add(
                      new County
                      {
                          Name = "Orange",
                          State = "NY",
                      });
              }
  
              var county2 = _context.Counties.FirstOrDefault(p => p.Name == "Ulster");
              if (county2 == null)
              {
                  _context.Counties.Add(
                     new County
                     {
                         Name = "Ulster",
                         State = "NY",
                     });
              }
          }
      }
  

  Save Cancel
• 

  0

  nipunjoshi created 8 years ago

  Other issue is according to the above exception where it checks the data on the tables also no (i.e "IpProperties" and "IpCounties" are my physical tables) ? Am I right ? Here it is :

  NMemory.Exceptions.ForeignKeyViolationException : Foreign key violation [IpProperties :: CountyId]. The key value [3] does not exists in the referenced table [IpCounties :: Id]..
  

  Save Cancel
• 

  0

  hikalkan created 8 years ago

  Support Team

  There is only 2 Country in your seed data (InitialCountiesCreator.cs) but you are trying to set CountryId = 3. So, there is no country with CountryId = 3.

  Save Cancel
• 

  0

  sampath created 8 years ago

  Yes,You're right.I have done as above where I removed some bad data on the above tables and after that I didn't Reseed the PK values.It is working fine with the real db.But not working with the Fake db.But when I changed it back to 1 and 2 then it works.Thanks.

  Save Cancel
• 

  0

  sampath created 8 years ago

  Hi, Is there any way to explore the data on fake db ? Any tool or like that ? Thanks.

  Save Cancel
• 

  0

  hikalkan created 8 years ago

  Support Team

  I don't know, since it's dynamic and in-memory. But, trying to investigate a unit test manually may not be a good practice.

  Also, I don't suggest to write hard-coded Id values. Why don't you just query it when you need? Thus, you can check if it's exists.

  Save Cancel
• 

  0

  sampath created 8 years ago

  Thanks a lot.Sure I'll follow those guidance :)

  Save Cancel