How to save table's multiple rows in database

Rameez Javed

Hi, I want to insert selected rows from table into database, It's asp.net core 3.1 application.
I'm my view I've populated table from excelsheet now I want to insert the tables data into database, I've a checkbox column to select specific record.
What I'm doing is creating JSON objects and inserting it in database, but issue is when i have large data the JSON object goes null in controller (I'm using ajax post method here). May be it is due to JSON object length size, below is the query I've made on stackoverflow.

Now I want to insert the selected bulk data in database, any efficient way to acheive this?

https://stackoverflow.com/questions/66924661/max-length-for-json-object-asp-net-core-3-1?noredirect=1#comment118304264_66924661

Thanks in advance.

3 Replies

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

Jignesh Kumar5y ago
Hi Rameez,

Please refer this link which will help you,
https://www.c-sharpcorner.com/article/efficient-data-modification-with-entity-framework-core/
https://stackoverflow.com/questions/5940225/fastest-way-of-inserting-in-entity-framework
Rameez Javed5y ago
added this code in startup file, still having the same issue....
Mario Scheeren5y ago
public void ConfigureServices(IServiceCollection services)
{
    services.Configure(options =>
    {
        // Set the limit to 256 MB
        options.MultipartBodyLengthLimit = 268435456;
    });
}
public static IHostBuilder CreateHostBuilder(string[] args) =>
    Host.CreateDefaultBuilder(args)
        .ConfigureWebHostDefaults(webBuilder =>
        {
            webBuilder.ConfigureKestrel((context, options) =>
            {
                // Handle requests up to 50 MB
                options.Limits.MaxRequestBodySize = 52428800;
            })
            .UseStartup();
        });