I have a side project where most of the operations will be simple data retrievals (the data is automatically inserted at regular intervals through another process -- i.e. a scheduled task). The application will be used as an ad-hoc reporting / querying tool. There will be minimal joins, so the SQL statements are all pretty simple. It is important that the operations work fast and efficient.
My client is suggesting we use LINQ-to-SQL combined with stored procedures. My question is this: if we decide to use stored procedures, is LINQ-to-SQL the right tool? Or, would it be better to use classic ADO.NET? Are there any advantages to using LINQ-to-SQL over ADO.NET? How about performance, ease-of-use, etc? Thanks in advance.