C# To Hold SQL Results

Question

How via C# can I query a SQL table for carName and store all results in a C# string Array variable?  So something like:
(I know this isn't actual syntax) -- just needing an example of how to perform this action
string[] carName = "Select carName from OnsiteCars";