Entity Name in Database

How to Construct Entity Name in DI Query

Comments

[dbo].[recei.pt]

dbo_receipt

If entity name has period, then drop the period in the table name while querying.

[dbo].[receipt]

dbo_receipt2

If duplicate entity name exists, then add suffix 2 to the table name while querying.

[dbo].[inv-oice]

dbo_invoice

If entity name has hyphen, then drop the hyphen to the table name while querying.

[dbo].[recei pt]

dbo_recei_pt

If entity name has blankspace ,then replace it with _(underscore) while querying.

[dbo].[recei_pt]

dbo_recei_pt2

If entity name already has _ underscore, then suffix 2 to the table name while querying.