A couple of weeks ago, I posted some code to use LINQ to query tables in an Excel spreadsheet . Because you can query databases using LINQ to SQL, you can write code to query a database and do a join with data in an Excel spreadsheet. This can enable some interesting scenarios – let’s say that you have a database that contains some sort of master records, and you’ve downloaded another table and significantly modified it through one means or another. Without using this technique, you would either
Read More...