Data insertions without my request EF6

@Skernel
I created a project in the 4.6.1framework of VS19 and used EF6 with no re-insert item problem. It may not be a framework or entity incompatibility issue.
It may be database disconnection.When users use DbSet.Add，not only is the state of the root entity marked ”Added” but everything in the graph that the context was not previously aware of is marked ”Added” as well. Even though the developer aware that the object has an existing Id value, Entity Framework honors its EntityState (Added) and creates an Insert database command for the object, regardless of the existing Id. That’s to ensure Entity Framework will get back the Id value of the newly created object so it can set the value in the object instance. For more details ,you can refer to here.
It may also be that users are assigning an object to another object instance instead of the context, Entity Framework considers this to be an unrecognized entity and its default behavior for unrecognized entities with no state is to mark them as Added.And the object will be inserted into the database when SaveChanges is called. For more details ,you can refer to here.
For the blue screen problem, can you show me the details? (Here is a link with the blue screen: Blue Screen Data.Maybe it can help you.)

Hello @Hui Liu-MSFT , thank you for your answer.
I had already studied EntityState, but I don't think my problem comes from there.
To explain the context I am in:
I have made it so that for any request, I have to instantiate a new object (which I call DataService).
This DataService contains methods that open a connection, query or insert, return the data, and close the connection.
This is my problem:
Before the bug occurred, I send requested to databse and instantiated a list of the result.
After the bug, all the items that my list contained were reinserted.
But I developed absolutely no method to insert a list, and no method accepts a list as argument. And after testing my code, I still don't understand how EF6 managed to insert a whole list without developing the code. Do you think that a disconnection from the database could have done that?

As for the blue screen, I don't have details. When I go to the event viewer, I just have an information telling me that the shutdown of the computer was not normal, but I already suspected it... Also, I don't know if it has a direct link with my bug on EF6 or if it's a coincidence.

Hi,@Skernel ,
Based on your description, you have trouble in how to use ef6 to insert a list to the database currently.

First of all, I need to state that we have to connect to the database if we want to insert data to database.

Second, please check if the following steps are same with you.

1. Create the Application :EF6Sample(.NET Framework 4.6.1).
2. Install the Entity Framework NuGet package :select Project –> Manage NuGet Packages and install the EntityFramework(latest version6.4.4).
   3.Define a Model.
   Add a new Product class to the EF6Sample: public class Product
   {
   public int ProductId { get; set; }
   public string Name { get; set; }

           public int CategoryId { get; set; }  
           public virtual Category Category { get; set; }  
       }  
       public class Category  
       {  
           public Category()  
           {  
               this.Products = new List<Product>();  
           }  
   
           public int CategoryId { get; set; }  
           public string Name { get; set; }  
   
           public virtual List<Product> Products { get; private set; }  
   }  
   

Add Context:

public class ProductContext : DbContext  
    {  
        public DbSet<Product> Products { get; set; }  
        public DbSet<Category> Categories { get; set; }  
    }  

4.Insert Data.
cs code:

private ProductContext context = new ProductContext();  

private void Button_Click(object sender, RoutedEventArgs e)  
        {  

                List<Product> products = new List<Product>()  
                {  
                    new Product{Name="shirt" ,CategoryId=6},  
                    new Product{Name="cup" ,CategoryId=7},  

                };  

                List<Category> categorys = new List<Category>()  
                {  
                    new Category{Name="cloth",CategoryId=6},  
                    new Category{Name="fruit",CategoryId=7},  
                };  

                context.Categories.AddRange(categorys);  
                context.Products.AddRange(products);  

                context.SaveChanges();  


            this.categoryDataGrid.Items.Refresh();  
            this.productsDataGrid.Items.Refresh();  
        }  

For the blue screen problem, it may not be the influence of the code, but the computer problem.

Hello @Hui Liu-MSFT ,
I use EF6 with database first, my object classes are generated automatically by entity framework.
For data insertion, I also use the method you shared.
However, the list I am loading is read-only, I have not developed any method to insert this list in database. Entity Framework acted on its own.
The version of Entity Framework I had installed was 6.2.0, I updated it, I don't know if this is the cause of the problem.

@Skernel

You need to show some code here that contributed to the issue. I find it hard to believe EF acted on its own.