C# - Parse Network Capture File

We would like a console application developed in C#, which can read network capture files. The file will be parsed for specific fields of data from each packet. The data will then be written to a MS SQL database. QoS Networking will supply the list of fields and a test network capture file to the developer. The developer will create a Visual C# console application to read the network capture file, parse the data and write the information to a SQL database. Task Definition 1. Create a C# console application 2. Implement the functionality to read a network capture file 3. Parse the data from each packet into class objects 4. Add the class objects to class lists 5. Validate data before writing to database 6. Write data to the Microsoft SQL Database 7. Package and deliver the final source code The C# console application should execute and display the progress of opening the network capture file, parsing the data and then writing the data to the database. The parsing method will add each class object to a class list. Once the class list is populated, a database method will be called to add the data contained in the class list to the database. It is critical that the application does not read the whole capture file before parsing the information. Capture files could be four gigabytes or larger and would cause memory issues using that process. Each frame should be read from the capture file individually, the information parsed and then the next frame is read and the process continues the same way until all of the packets have been parsed. Example of parsing TCP data: "Parsing TCP data ……. Parsing of TCP data has been successfully completed." On successful insertion of the database records, the console application should display "Records have been successfully inserted". Please have a look at the attached files, though the job entails saving the relevant data, please quote your price only for reading the network capture file and parsing the relevant data. We have a design in place for populating and inserting the relevant parsed data to the database. We will share this with the developer so they can implement the same design. The developer should maintain proper coding standards, and code (bug free, and should compile) and should be checked in our repository. The chosen developer shall be briefed on the integration aspect, as the parsing routine should seamlessly integrate in the main application. Coding should be done in Visual Studio 2013 Community Edition. [login to view URL] We have attached a zip file containing two files: 1) Database Tables and [login to view URL] – this document contains the information on what fields will be parsed from the network capture file. 2) [login to view URL]– this is the test network capture file. Note: The scope of this project is to parse one network capture and write the information to a MS SQL database. Previous experience developing applications that work with network capture files is desired. We will only look at proposals that include an amount and a strategy to complete the project. Thank You. Regards, QoS Networking