How to add data into 2 different tables with EnityFramework

I would like to add new data rows with entityframworks to 2 different tables

I dont know how to do this problably because both tables Have the same Key Name

public async Task Create([Bind("ProductId,ProductTitle,ProductDiscription,Price,quantity,HeaderImage,MultipleImages")] ProductWithImages productWithImages)
{
Guid NewProductId = Guid.NewGuid();
string uploadPath = Path.Combine(_webhostenv.WebRootPath, "Images2");
if (ModelState.IsValid)
{
string FileName = Guid.NewGuid().ToString() + productWithImages.HeaderImage.FileName;
string FilePath = Path.Combine(uploadPath, FileName);
productWithImages.HeaderImage.CopyTo(new FileStream(FilePath, FileMode.Create));
ProductWithImagesDb newproduct = new ProductWithImagesDb()
{
ProductId = NewProductId,
ProductTitle = productWithImages.ProductTitle,
ProductDiscription = productWithImages.ProductDiscription,
Price = productWithImages.Price,
quantity = productWithImages.quantity,
HeaderImage = FileName,
};
_context.ProductWithImagesDb.Add(newproduct);
await _context.SaveChangesAsync();
// succesfully adds the newproduct data into the ProductWithImagesDb table
//---------------------------------------------------------------------------
if (productWithImages.MultipleImages != null)
{
int imgorder = 0;
foreach (IFormFile photo in productWithImages.MultipleImages)
{
imgorder++;
string filename = Path.GetRandomFileName() + "_" + photo.FileName;
string filepath = Path.Combine(uploadPath, filename);
await photo.CopyToAsync(new FileStream(filepath, FileMode.Create));
var productImages = new ProductImages();
productImages.ProductId = NewProductId;
productImages.ImagePath = filename;
productImages.ImageOrder = imgorder;
_context.ProductImages.Add(productImages);
await _context.SaveChangesAsync();
}
}
//once the productWithImages.MultipleImages is used
//it crashes because it is a different table but uses the same key (ProductId)
//-------------------------------------------------------------------------------------
return RedirectToAction(nameof(Index));
}
return View();
}

I know that once entityFramework sees the _context.add it tracks to that database table

Maybe I can remove the tracking so it can look for a new database Table

I dont know to do that or if that would even be a good idea

I am keep getting the same error saying:

InvalidOperationException: The instance of entity type 'ProductImages' cannot be tracked because another instance with the same key value for {'ProductId'} is already being tracked. When attaching existing entities, ensure that only one entity instance with a given key value is attached. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see the conflicting key values.

ProductWithImagesDb table and ProductImages(is a collection of Images) have the same Key value so i can connect all the images with the same productId as the productid in ProductWithImagesDb.

is it not allowed to use the same key value in the same controller action?. this is very confussion

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi,

Please refer this thread will giude you,

https://forums.asp.net/t/2163052.aspx?The+instance+of+entity+type+Invoice+cannot+be+tracked+because+another+instance+with+the+same+key+value+for+Id+is+already+being+tracked+When+attaching+existing+entities+ensure+that+only+one+entity+instance+with+a+given+key
osyris zosar5y ago
I am keep getting the same error saying:

InvalidOperationException: The instance of entity type 'ProductImages' cannot be tracked because another instance with the same key value for {'ProductId'} is already being tracked. When attaching existing entities, ensure that only one entity instance with a given key value is attached. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see the conflicting key values.

ProductWithImagesDb table and ProductImages(is a collection of Images) have the same Key value so i can connect all the images with the same productId as the productid in ProductWithImagesDb.

is it not allowed to use the same key value in the same controller action?. this is very confussion
Jignesh Kumar5y ago
Hi Osyris,

Please try to use transction,
https://www.c-sharpcorner.com/UploadFile/ff2f08/working-with-transaction-in-entity-framework-6-0/