Linq to Excel

Having fun with Linq to SQL for a little while now, it speed up my development time dramatically, because I can write C# code better than SQL statement, so I let Linq to SQL handle the SQL for me.

Came across a need to read Excel, I knew I can read it using ADO.NET , but when try to make use of Linq to SQL in the project, try not to create a function that using the normal querying using the ADO.NET, so I came across Linq to Excel , now I can read the Excel files like normal Linq to SQL, and it works with Excel files created in Excel 2010, thumbs up!

April 21, 2011 ยท Stephen Saw