bulk insert in linq

Question

i want write a api for bulk insert,how can u help me

Vishal Yelve · Answer

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/

Naimish Makwana · Answer

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.

Naimish Makwana · Answer

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; }

Naimish Makwana · Answer

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 Refer : https://stackoverflow.com/a/63101773/3054222 Thanks Naimish Makwana

Sandeep Kumar · Answer

want to use for each one by one

Sandeep Kumar · Answer

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; }

bulk insert in linq

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)