Write parser in C#

I have a pipe delimited file, see attached example. I need a parser written in C#. I don't just need this delimited, I need to be able to insert it into a SQL table into the correct columns. Start bid with your favorite color and a brief explanation of how you would parse the file.