SharpHadoop facilitates access to WebHDFS from .Net.
The library can easily be dependencies and solely relies on the .net standard library

Features:

1) Upload Download large files/from HDFS.
2) Can be used with .Net Framework 3.0 and 4.0, may be older versions as well.
3) Can be used with SSIS with help of Script task.

Upcoming Features:-

1) Hive Wrapper.