Inserting multiple objects using EntityFramework?

Question

I build up stuff that I need into an IEnumerable and then I need to insert the collection into the database, but can't figure how. Please take a look at my code snippet:

public void CopyPonyJetpacks(Pony p_s, Pony p_d)
{
    try
    {
        using (var scope = new TransactionScope())
        {

            var assocs = from x in p_s.Pony_Jetpacks
                         select new Pony_Jetpacks()
                         {
                             Id=Guid.NewGuid(),
                             JetpackId=x.JetpackId,
                             PonyId=p_d.Id
                         };

            data.Pony_Jetpacks.AddObject(assocs); //This doesn't work, what to do?

            data.SaveChanges();
            scope.Complete();
        }
    }
    catch (Exception e)
    {
        throw e;
    }

}

It would be really sad if I had to convert the 'assocs' into list and then insert one by one.

Slauma · Accepted Answer · 2011-09-01 00:05:30Z

1

You don't need to convert your assocs IEnumerable<T> into a List<T> but yes, you need to insert it one by one:

foreach (var assoc in assocs)
    data.Pony_Jetpacks.AddObject(assoc);

answered Sep 1, 2011 at 0:05

Slauma

177k60 gold badges407 silver badges424 bronze badges

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

Collectives™ on Stack Overflow

Inserting multiple objects using EntityFramework?

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