I'm kind of new to this but I'll try to give as much detail as possible. This is my SQL table.

`Customers`

`Customers_Id (PK) | First | Last | Address | Phone | Tech_Id (FK) |
-------------------+-------+-------+--------------+----------+--------------+
 1 | Bob | Smith | 123 Fake St. | 3298492 | 1 |
 2 | John | Man | 123 Noe St. | 2930482 | 1 |
 3 | Tom | Lee | 123 Polk St. | 9308523 | 2 |
 ...`

`Tech`

`Tech_Id (PK) | First | Last | Phone | Customer_Count |
--------------+-------+-------+---------+----------------+
 1 | Tim | Bo | 9384027 | |
 2 | Andy | Wong | 9374927 | |
 3 | Jack | Help | 2183847 | |
 ...`

I'm trying to find the best way to count how many customer that each tech has either using SQL Query or C# coding. I was thinking of doing query with Count and then insert into the Customer\_Count in Tech table.

I'm using visual studio 2012 and SQL is created locally in visual studio. Please help!