entity framework - How to determine reason for slow inserts SQL Server Compact Edition 4.0? -

entity framework - How to determine reason for slow inserts SQL Server Compact Edition 4.0? -

i have application using code first model entity framework 6.1 , sql server compact edition 4. inserting simple table id, 1 datetime 2 singles, 2 doubles, , 3 ints slow, ranging 8 15 inserts per sec on scheme ssd.

what best tools , techniques track downwards reason slow inserts in sql server ce 4?

entity framework not designed fast inserts, can utilize sqlcebulkcopy library fast inserts, , pass collection of ef objects

entity-framework sql-server-ce-4