private void SetLien(Sale sale)
 {
     if (sale.HasLien)
     {
         sale.LienholderNormalizedName = sale.Lienholder.Name.ToUpper();
         Lienholder lienholder = _context.Lienholders.Include(x => x.Address).FirstOrDefault(x => x.NormalizedName == sale.LienholderNormalizedName);
         if (lienholder != null)
         {
             lienholder.Update(sale.Lienholder);
             sale.Lienholder = null;
         }
     }
 }
        protected override void OnModelCreating(ModelBuilder builder)
        {
            builder.Entity <IdentityRole>().HasData(new IdentityRole
            {
                Id             = "2301D884-221A-4E7D-B509-0113DCC043E1",
                Name           = "Admin",
                NormalizedName = "ADMIN"
            });

            Dealership.Address.Id = 1;
            Lienholder dealership = new Lienholder
            {
                Name           = Dealership.Name,
                AddressId      = 1,
                NormalizedName = Dealership.Name.ToUpper()
            };

            builder.Entity <Car>().HasIndex(x => x.IsListed);
            builder.Entity <UserAccount>().HasKey(x => new { x.UserId, x.AccountId });
            builder.Entity <Address>().HasData(Dealership.Address);
            builder.Entity <Lienholder>().HasData(dealership);
            builder.ConfigurePersistedGrantContext(OperationalStoreOptions);
            base.OnModelCreating(builder);
        }