} // PLACEHOLDER FOR THE LINES READ
internal static Titles ConvertRow(string row) // METHOD TO READ THE LINES AND ASSIGN TO OBJECT
{
clsDataconnection objConn = new clsDataconnection();
return(new Titles()
{
details = row //ASSIGNING THE DETAILS FROM THE ROW
});
}
public List <Titles> testQry()
{
clsDataconnection objConn = new clsDataconnection(); // CREATING A LOCAL INSTANCE OF THE DATA ACCESS LAYER CLASS
DataTable dt = new DataTable(); // CREATING A DATATABLE
var linqCSV = objConn.createLinq(); // ESSENTIALLY THE PATH TO THE CSV FILE
var results = File.ReadAllLines(linqCSV) // RUNNING THE LINQ OPERATION
.Skip(1)
.Where(row => row.Length > 0)
.Select(Titles.ConvertRow).ToList(); // I HAD TO CREATE A OBJECT BECUASE THE CSV RUNNING COLUMN BY COLUMN WOULD BE A MESS
return(results);
}
