how insert same record in multiple times using entity framework

Question

How to insert same record in multiple times without using for loop because its taking to much time I want to insert 10lack record at a time

              for (int i = 0; i < 1000; i++)
            {
                List<student> students = new List<student>
                 {
                   new Student{student_id = i,Name= "new"}
                 };
                db.Set<Student>().AddRange(students);
                db.SaveChanges();
            }

This above code taking to much time to inserting 10lack record.is it possible to insert same Name with different student_id multiple times without using for loop?

Student_id is different according to your code then, how you are saying you are inserting the same record ?? — Sunil Kumar
– Sunil Kumar, Commented Apr 18, 2019 at 7:23
yes u'r right but I need same name with different student_id is it possible without using for loop? — rama
– rama, Commented Apr 18, 2019 at 7:37
then according to me the loop is only the option.., you can improve your code by using SaveChanges() outside the loop area and declare the List<Student> before the loop. using this approach you can improve the performance of your code. — Sunil Kumar
– Sunil Kumar, Commented Apr 18, 2019 at 7:42

Paul Ballew · Accepted Answer · 2019-04-18 07:27:55Z

1

Did you try calling SaveChanges() after the loop? Also I recommend making the student ID an auto generated key and adding each student with an add directly to the set instead of an addrange with a list.

answered Apr 18, 2019 at 7:27

Paul Ballew

842 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kara · Accepted Answer · 2019-04-18 07:55:18Z

0

You need to move db code out of the loop:

//Declare the list object here
List<Student> students = new List<Student>();

for (int i = 0; i < 1000; i++)
{
    students.Add(new Student{student_id = i,Name= "new"});
}

db.Set<Student>().AddRange(students);
db.SaveChanges(); //Save changes to DB

edited Apr 18, 2019 at 7:55

kara

3,4854 gold badges23 silver badges39 bronze badges

answered Apr 18, 2019 at 7:42

LazZiya

5,7992 gold badges29 silver badges42 bronze badges

Collectives™ on Stack Overflow

how insert same record in multiple times using entity framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related