Setting Linq to SQL Type Names in Visual Studio

Question

I love Linq but it can rapidly clutter up the namespace with automatically generated types. Usually these automatically generated types are often irritatingly close to other objects leading to many hours of fun and laughter.

In the designer I notice that I can specify the table names, however I can not for the life of me see how to set the row names.

For Example
TableName : User_Table
RowName : User_Row as opposed to "User_Tables"

I swear I've done this before but I can't seem to remember how.

Answer 1

You can do this by manually editing the dbml file in an xml editor. All names are stored separately in the dbml file, but not all are accessible from the designer.

Alternatively, there are third party tools that make handling names etc easier; one such tool is my VS add-in for L2S and EF. It adds naming rule support, mass-renaming, model <-> db schema sync etc to the existing L2S designer. You can download it and get a free trial license at http://www.huagati.com/dbmltools/