Batch vice insert for large record for insert query

Question

Hello

I want to to insert in batch vice. Meance If I am trying to inserting suppose my changeset has 20000 records for insert then It should do insertion of batch of 500 records for each batch..

I am new in this field.. SO can you please explain me in details & help me how to do that?

Thanks

Regards

Vipul Langalia

Answer 1

Hi Vipul;

Linq to SQL does not support a Batch Insert and therefore can not do this.

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

Hi,

It is not possible in Linq to SQL as @Fernando said.

But perhaps, any of these other threads could be useful to you:

bulk insert with linq-to-sql

Bulk INSERT / UPDATE / DELETE in LINQ to SQL

Regards,

JA Reyes.

---

Please remember to Vote & "Mark As Answer" if this post is helpful to you.
Por favor, recuerda Votar y "Marcar como respuesta" si la solución de esta pregunta te ha sido útil.