Pig might work, I’m not an expert. Hive — no don’t use that for this use case.
Streaming refers to Hadoop streaming. It will allow you to use your .NET application in conjunction with Map/Reduce. This requires Hadoop on Windows. See http://www.nuget.org/packages/Microsoft.Hadoop.MapReduce/ — that’s all I know about it unfortunately.