bulk insert in linq

Hi Sandeep,

I suggest you if you are want to Bulk Insert use EFCore.BulkExtensions.

please refer below article it will help you alot.

https://www.c-sharpcorner.com/article/bulk-operations-in-entity-framework-core/

You want to insert data in bulk. So why you want to use in loop?

As I see public List UserAccessList {get; set;} you're all the data are in list. 

If you write code in for each, then there is no use of bulk insert. 

want to use for each one by one

You can write like this.

Need to create object of dbcontext.

async Task IPaperManager.InsertUserAccess(AddUserAccess Items)
{
    _ResponseStatus = new ResponseStatus();

    var createDate = DateTime.UtcNow.Add(new TimeSpan(+5, +30, +00));
		//you can write like this.
    dbcontext.BulkInsert(Items.UserAccessList);
    return _ResponseStatus;
}

this my model class

public class AddUserAccess
{   
    public List UserAccessList { get; set; }
}
public class UserAccessList
{
    public string Type { get; set; }
    public string Page { get; set; }
    public string Access { get; set; }
    public string UserId { get; set; }
    public string IsGranted { get; set; }
}

this my method ,what i have write in for each

async Task IPaperManager.InsertUserAccess(AddUserAccess Items)
{
    _ResponseStatus = new ResponseStatus();

    var createDate = DateTime.UtcNow.Add(new TimeSpan(+5, +30, +00));
    foreach (var UserAccess in Items.UserAccessList)
    {
     
    }
    return _ResponseStatus;
}

Hello Sandip

you can use N.EntityFramework.Extension

Install-Package N.EntityFramework.Extensions

Once you install it, you can simply use BulkInsert() method directly on the DbContext instance. It supports BulkDelete, BulkInsert, BulkMerge and more.

var dbcontext = new MyDbContext();  
var orders = new List();  
for(int i=0; i<10000; i++)  
{  
   orders.Add(new Order { OrderDate = DateTime.UtcNow, TotalPrice = 2.99 });  
}  
dbcontext.BulkInsert(orders);  

Refer : https://stackoverflow.com/a/63101773/3054222

Thanks

Naimish Makwana