<div>
Why does this need to be multi-threaded? &quot;Thousands&quot; is not very large in terms of DB processing.
</div>


Why does this need to be multi-threaded? "Thousands" is not very large in terms of DB processing.

<div>
It has to be multi-threaded because it will eventually grow to millions of records.
</div>


It has to be multi-threaded because it will eventually grow to millions of records.

<div>
...and also, if it's a remote SQL server, all the connections will be using the same network connection. &nbsp;So if it's a lot of data being transferred, that might present a bottleneck too. &nbsp;
</div>


...and also, if it's a remote SQL server, all the connections will be using the same network connection.  So if it's a lot of data being transferred, that might present a bottleneck too.  

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I need help writing a C# console application with SQL Server 2005 DB. &nbsp;The table I will be querying has thousands of records so It needs to be multi-threaded. &nbsp;The program needs two functions. &nbsp; <br />
One that calculates the Product of all ItemCost values by ItemCategory.<br />
The second function needs to calculate the Median value of ItemCost by ItemCategory.<br />
<br />
The name of my SQL table is &nbsp;INVENTORY with the fields ItemCost (float), ItemCategory (varchar).<br />
<br />
How can I do this?<br />
<br />
Thanks in advance,<br />
mrotor<br />

</div>
</div>


Hi Experts,
I need help writing a C# console application with SQL Server 2005 DB.  The table I will be querying has thousands of records so It needs to be multi-threaded.  The program needs two functions.   
One that calculates the Product of all ItemCost values by ItemCategory.
The second function needs to calculate the Median value of ItemCost by ItemCategory.

The name of my SQL table is  INVENTORY with the fields ItemCost (float), ItemCategory (varchar).

How can I do this?

Thanks in advance,
mrotor


I need help writing a C# console app.

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

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).