Addrenge option is not available in my Enity Framework

Yogesh Vedpathak

Hi , I have used system.collection.Generic namespace but still not getting option of Addrenge to insert bulk data

can anyone guide me

5 Replies

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

Yogesh Vedpathak6y ago
Hi , I am getting below error while adding ...

Unable to cast object of type 'Common.Models.OneTimeItem' to type 'System.Collections.Generic.IEnumerable`1[Models.OneTimeItem]'.

created.ForEach(m => Items.AddRange((IEnumerable)m));
Laxmidhar Sahoo6y ago
hi
[TestMethod]
public void InsertEfAddRangeTest()
{
    var context = new WebMonitorContext();

    var users = new List();
    var sites = new List();

    for (int i = 0; i < 10000; i++)
    {
        …
        users.Add(user);

        …
        sites.Add(site);
    }

    context.Users.AddRange(users);
    context.Sites.AddRange(sites);

    context.SaveChanges();
}
Thanks and regards
Rajanikant Hawaldar6y ago
For example below AddRange method is extension method using System.Data.Entity.IDbSet, similerly you can try.
public static class R2VDbContextExtensionMethods
{
        public static IEnumerable AddRange(this IDbSet dbset, IEnumerable entitiesToAdd) where TEntity : class
        {
            return ((DbSet) dbset).AddRange(entitiesToAdd);
        }
}
Yogesh Vedpathak6y ago
Hi Rajnikant ,
Thanks for Quick reply could you please tell me how can i write Extension method for Add renge
Rajanikant Hawaldar6y ago
if not available try by writing extension method