1

Resolved

CRUD - Adding of plurals in stored procs... adding S where not needed

description

sp_Select_CompanyCategoriess_By_CategoryID
should be
sp_Select_CompanyCategories_By_CategoryID

comments

ld9474 wrote Jan 23, 2008 at 6:00 PM

Are you testing with Norhwind database?
Well this Database has its name not well formed for French DB designers. We use a method called Merise. And using plurals to define an entity is not correct.

For now, you can rename Stored Procedure and give it the name you want if you replace it's value in the FormatedName property once the analyse has run.

Anyway you are right. The future release will not produce plurals by itself... or this may be an option.

ld9474 wrote Jan 23, 2008 at 6:01 PM

Sorry i was thinking of the FriendlyCode not FormatedName in my previous comment

wrote Jan 23, 2008 at 6:01 PM

wrote Jan 23, 2008 at 8:23 PM

wrote Jan 23, 2008 at 8:43 PM

ld9474 wrote Jan 23, 2008 at 9:02 PM

The fix was published in the Patch #1.

No "s" is added to foreign key stored procedures.

wrote Feb 13, 2013 at 7:35 PM

wrote May 15, 2013 at 3:48 AM

wrote May 15, 2013 at 3:48 AM

wrote Jun 12, 2013 at 1:38 AM