Error: FileNotFoundException: Could not load file or assembly 'System.Data.OleDb, Version=126.96.36.199
I had a script in LINQPad 5 that worked fine and loaded an Excel file and did some LINQ to SQL queries from the database looking up values from the Excel file.
I upgraded to LINQPad 6 and now I see an error in this line:
var excel = ExcelProvider.Create(@EmailSearchList.xlsx, "Sheet1");
The errors is this:
FileNotFoundException: Could not load file or assembly 'System.Data.OleDb, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. The system cannot find the file specified.
I have a reference to this DLL: ScipBe.Common.Office.dll, I think that's what contains the "ExcelProvider".
I don't know where is it trying to locate "System.Data.OleDb", what does this error actually mean and how can I fix it?