Service:
public Cart AddProductToCart(Product product, Cart cart)
{
var productExist = _dbContexet.CartProduct.Where(cp => cp.ProductId == product.Id).FirstOrDefault();
var quantityOfCart = _dbContexet.CartProduct.Where(cp => cp.CartId == cart.Id).FirstOrDefault().Quantity;
CartProduct cartProduct = new CartProduct();
cartProduct.CartId = cart.Id;
cartProduct.ProductId = product.Id;
if (productExist != null)
{
cartProduct.Quantity = quantityOfCart + 1;
_dbContexet.Attach(cartProduct).State = EntityState.Modified;
}
else
{
cartProduct.Cart = cart;
cartProduct.Product = product;
_dbContexet.CartProduct.Add(cartProduct);
}
_dbContexet.SaveChanges();
return cart;
}
Full error:
InvalidOperationException:無法跟蹤實體類型“CartProduct”的實例,因為已在跟蹤另一個具有{CartId',ProductId}相同鍵值的實例。附著現有實體時,請確保僅附著一個具有給定鍵值的實體實例。考慮使用'DbContextOptionsBuilder.EnableSensitiveDataLogging'查看沖突的鍵值。
我有多對多和表CartProduct
我想檢查產品是否存在,如果存在只更新數量,但我得到這個錯誤?
Eddit:
Product:
public partial class Product
{
public int Id { get; set; }
public string Name { get; set; }
public decimal Price { get; set; }
public string Category { get; set; }
public decimal CostToMake { get; set; }
public decimal FinalPrice { get; set; }
//public int? OrderId { get; set; }
public virtual Order Order { get; set; }
public List<CartProduct> CartProduct { get; set; }
}
Cart:
public class Cart
{
public int Id { get; set; }
public int ProductCount { get; set; }
public AppUser User { get; set; }
public List<CartProduct> CartProduct { get; set; }
}
CartProduct:
public class CartProduct
{
public int CartId { get; set; }
public int ProductId { get; set; }
public Cart Cart { get; set; }
public Product Product { get; set; }
public int Quantity { get; set; }
}
FluentAPI:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.HasAnnotation("Relational:Collation", "Cyrillic_General_CI_AS");
modelBuilder.Entity<Day>(entity =>
{
entity.Property(e => e.Date).HasColumnType("date");
entity.Property(e => e.MostCommonCategory)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.MostCommonProduct)
.IsRequired()
.HasMaxLength(100)
.IsUnicode(false);
entity.Property(e => e.TotalMade).HasColumnType("decimal(18, 3)");
entity.Property(e => e.TotalSpent).HasColumnType("decimal(18, 3)");
});
modelBuilder.Entity<Order>(entity =>
{
entity.Property(e => e.Date).HasColumnType("date");
entity.Property(e => e.Status)
.IsRequired()
.HasMaxLength(100)
.IsUnicode(false);
entity.Property(e => e.Name).HasMaxLength(100);
entity.Property(e => e.Address).HasMaxLength(150);
entity.Property(e => e.PhoneNumber).HasMaxLength(20);
});
modelBuilder.Entity<Product>(entity =>
{
entity.HasIndex(e => e.OrderId, "IX_Products_OrderId");
entity.Property(e => e.Category)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.CostToMake).HasColumnType("decimal(18, 3)");
entity.Property(e => e.FinalPrice).HasColumnType("decimal(18, 3)");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50)
.IsUnicode(false);
entity.Property(e => e.Price).HasColumnType("decimal(18, 3)");
entity.HasOne(d => d.Order)
.WithMany(p => p.Products)
.HasForeignKey(d => d.OrderId);
});
modelBuilder.Entity<Cart>(entity => {
entity.HasKey(e => e.Id);
entity.HasOne(e => e.User)
.WithOne(e => e.Cart)
.HasForeignKey<AppUser>(e => e.CartId);
});
modelBuilder.Entity<CartProduct>()
.HasKey(e => new { e.CartId, e.ProductId });
modelBuilder.Entity<CartProduct>()
.HasOne(t => t.Cart)
.WithMany(t => t.CartProduct)
.HasForeignKey(t => t.ProductId);
modelBuilder.Entity<CartProduct>()
.HasOne(t => t.Product)
.WithMany(t => t.CartProduct)
.HasForeignKey(t => t.CartId);
OnModelCreatingPartial(modelBuilder);
}
您可以使用EF特性以不同的方式執行某些操作。