Insert random number in database column using linq in asp.net

Question

how to Update table column with random numbers using linq in asp.net. Please take a look at my code. same number is updated for all records in the list. what is going wrong in my code.

foreach(var item in list)
            {
                int rnd = 0;
                //item.RandomNumber = GetRandomNumber();
                Application app = new Application ();

                app.Id = item.Id;
                 rnd = GetRandomNumber();
                app.RandomNumber = rnd;
                listapp.Add(app);
            }

public int GetRandomNumber()
{
    int Random = 0;

    Random random = new Random();
    Random = random.Next(1, 99999);
    return Random;
}

It should update unique number for each list. but now column is updated with same number.

mdnghtblue · Accepted Answer · 2014-11-20 04:50:25Z

1

Define the Random object outside of the foreach loop. When you create it on each iteration of the loop, it is likely being seeded with the same value each time, which gives you the same "random" number each time.

answered Nov 20, 2014 at 4:50

mdnghtblue

1,1179 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Insert random number in database column using linq in asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related