To give you the answer how to use batching with fluent: 1) on the colleciton HasMany<MyEntity>(x => x.Entities) .BatchSize(100); 2) on a class level public MyEntityMap() { Id(x => x…. … BatchSize(100); This corresponds with the 19.1.5. Using batch fetching
No, it can’t be done (yes – i weep also). EF does not support batch operations, LINQ-SQL had (has) the same problem. You’ve got a few options: Stored Procedures Classic ADO.NET or EntitySQL Triggers I’ve gone with option 1 and 3 in the past. The problem with all three approaches is you lose the EF … Read more
The Replace dialog can handle extended characters like EOL. Just change “Search Mode” to “Extended”, and you can work with EOL (\r\n in Windows or \n in Unix), tabs (\t), etc. You can also use the Find in Files tab of the dialog to do the replace across multiple files.
One thing you could do (this of course depends on what you are trying to accomplish) is: Store the necessary information (i.e. like a loop counter) in a spreadsheet or another permanent store(i.e. ScriptProperties). Have your script terminate every five minutes or so. Set up a time driven trigger to run the script every five … Read more
Create a .BAT file with the following command: for %%G in (*.sql) do sqlcmd /S servername /d databaseName -E -i”%%G” pause If you need to provide username and passsword for %%G in (*.sql) do sqlcmd /S servername /d databaseName -U username -P password -i”%%G” Note that the “-E” is not needed when user/password is provided … Read more
There are two open source projects allowing this: EntityFramework.Extended and Entity Framework Extensions. You can also check discussion about bulk updates on EF’s codeplex site. Inserting 100k records through EF is in the first place wrong application architecture. You should choose different lightweight technology for data imports. Even EF’s internal operation with such big record … Read more
How do you convert an entire directory with ffmpeg?