<div>
How would you have multiple processes without making it multi-threaded?<br />
<br />
Currently, I am porting SQL Server scripts to Oracle which simulate multi-threading, &nbsp;using several data tables which get created for this legacy port. It partitions the database into 500K record chunks by assigning them a unique process ID, and tracking the current status for each row.<br />
<br />
How could this work in EF6? I hoped to replace this whole complexity with EF6, but need to find how to use EF6 to help partition the large table so over a dozen instances can do the job in parallel.<br />
<br />
Thanks.
</div>


How would you have multiple processes without making it multi-threaded?

Currently, I am porting SQL Server scripts to Oracle which simulate multi-threading,  using several data tables which get created for this legacy port. It partitions the database into 500K record chunks by assigning them a unique process ID, and tracking the current status for each row.

How could this work in EF6? I hoped to replace this whole complexity with EF6, but need to find how to use EF6 to help partition the large table so over a dozen instances can do the job in parallel.

Thanks.

<div>
<div class="content wysiwyg-content">
I need to write an EF6 app that reads from Oracle and enables multiple instances of my app each to process a chunk of records, in parallel. &nbsp;This is because I assume it's faster to have perhaps 20 instances of my app running with each thread assigned perhaps 500K records rather than a single process handling 10 million records.<br />
<br />
Please give me some insight into what EF6 can do for me.<br />
<br />
Thanks!
</div>
</div>


I need to write an EF6 app that reads from Oracle and enables multiple instances of my app each to process a chunk of records, in parallel.  This is because I assume it's faster to have perhaps 20 instances of my app running with each thread assigned perhaps 500K records rather than a single process handling 10 million records.

Please give me some insight into what EF6 can do for me.

Thanks!

EF6, threading and large data sets

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).