Addrenge option is not available in my Enity Framework

Question

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

Rajanikant Hawaldar · Answer

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 Vedpathak · Answer

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 Sahoo · Answer

hi [TestMethod] public void InsertEfAddRangeTest() { var context = new WebMonitorContext(); var users = new List (); var sites = new List (); for ( int i = 0; i { … users.Add(user); … sites.Add(site); } context.Users.AddRange(users); context.Sites.AddRange(sites); context.SaveChanges(); } Thanks and regards

Yogesh Vedpathak · Answer

Hi Rajnikant , Thanks for Quick reply could you please tell me how can i write Extension method for Add renge

Rajanikant Hawaldar · Answer

if not available try by writing extension method

Addrenge option is not available in my Enity Framework

Answers (5)