Adding .csv file as resource file and accessing it in the code

Question

I have a .csv file which i will read using oledb method in my code now i want this .csv file as my resource file so i have added that file in the resources. But struct with accessing the resource file from the code, can anyone please help me on this

Thanks

Answer 1

Assuming that your CSV file is embedded as a resource you could access it like this:

using (var stream = Assembly
    .GetExecutingAssembly()
    .GetManifestResourceStream("YourNamespace.test.csv"))
using (var reader = new StreamReader(stream))
{
    string csv = reader.ReadToEnd();
    // do something with the CSV
}