locked
Fastest Way of Inserting in Entity Framework. RRS feed

  • General discussion

  •  Hi all,

    I have to insert 250000 of records at a time. what is the best and fast way to handle this using EF and mysql. please guide me.


    • Edited by cmadu701 Wednesday, January 28, 2015 10:54 AM
    • Changed type Fred Bao Tuesday, February 3, 2015 7:58 AM The discussion is more suitable for this case
    Wednesday, January 28, 2015 6:31 AM

All replies

  • The fastest way is to use one of the Bulk Insert EF extensions, or avoid using EF, but use SqlBulkCopy or similar

    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Wednesday, January 28, 2015 6:56 AM
  • I am using mysql as a database bulk insert Ef not support for mysql.
    Wednesday, January 28, 2015 10:49 AM
  • The fastest way would be not to use an ORM for this
    Wednesday, January 28, 2015 2:41 PM