what are the pros and cons using LINQ to SQL?

performance ? architecture ? the system in question will always be a MS SQL database there is an existing DAL but there 开发者_运维百科will be refactoring done on the system and Linq-to-SQL seems a good candidate to avoid maintaining a DAL or SP's

For advantages, see the accepted answer on this related question: What are the advantages of LINQ to SQL?.

For disadvantages, you may be interested in the discussion at this related question: linq2sql disadvantages

Try looking at for a discussion on the pros and cons

http://kevine323.blogspot.co.uk/2011/08/linq-to-sql-and-entity-framework-vs.html

-- Lee