CSV File data validation
The solution parses multiple csv files, each containing rows of data (each of a particular type T) into a .NET collection. It performs three kind of validations of data, whichever files pass the validation have to be persisted in a database.
Types of validations:
- File validations - covers standard issues (File doesn't exist, File is empty, File has only header etc.)
- Format validations - which shall check for issues like Incorrect datatype, Null or Empty value etc.
- Business validations - business logic validation
Note: You can use files from 'Tested Files' folder for testing the solution