CODEWITHSUNDEEP
visual-studio-2010sql-server-2008
CBredlow
CBredlow

Reputation: 2840

Visual Studio dropping 's' off of sql server tables

When adding in tables from SQL Server to a dbml, it will drop the 's' off of the table name. One example: when adding the table 'Alias' it will change the name to 'Alia'. Is there any way to prevent this from happening?

Method of adding tables:
1) Connect to database in the Server Explorer Tab
2) Open tables folder
3) Select all the tables and drag them to the open dbml window

Upvotes: 1

Views: 147

Answers (1)

JohnD
JohnD

Reputation: 14757

If you are using entity framework, and adding tables via the update wizard, there is a checkbox which says "Pluralize or singularize generated object names":

update wizard

You can uncheck that and it will leave your table names alone.

Update: looks like you are drag/dropping to DBML, try this link:

Linq to SQL: How do I stop the auto generated object name from being renamed?

Upvotes: 3

Related Questions