Linq to SQL File Size

Question

Hi,

What I wanna learn is if we put every table into one LinqToSQL file, do we lose performance ? Is it better to put each table in different LinqToSQL Files or it's the same thing with putting in single one.

I hope I could explain my question.

Thanks and Regards...

Answer 1

There won't be a run-time penalty, but it may slow intelisense down once you get to millions of tables in a single file.

For what it's worth, the default SQL Metal behaviour puts all tables in a database into a single file.