Gerard,
To the best of my awareness, LINQ to SQL will only work with SQL Server.
My two cents: if you're using stored procs in SQL Server, there is not much of a convincing reason to use LINQ to SQL (and in my opinion, LINQ to SQL is, in some instances, a few steps backwards)
The power and benefits to LINQ are things like Linq to Objects, Linq to XML, etc.
Kevin