Stored procedure sorting in Entity Framework

[Former Member]

When updating a model from the db the window listing them doesn't have them sorted. I've only seen this problem with ASE. How do I get them sorted?

[dawn_kim]

One more question sorry, what version of the ado.net driver are you using?

Thanks,
Dawn

[Former Member]

Hey Dawn,

Sorry for the delay Fridayitis set in. lol

VS 2012 upd 4

EF 5

ADO  4.157.1300 (I think)

Thanks,

Mark

[dawn_kim]

Hi Mark,

Sorry for the delay in the response. I am using Studio 2013 because I got to get it tested. They are alphabetical order in my system.
Try this: If you right click Stored Procedures and choose properties. You should see a box for this on the right side. There is an icon that says alphabetical. Click this and it should make sure everything is listed alphabetically.

Thanks,
Dawn Kim

[Former Member]

Hi Dawn,

Right clicking on the Stored Procedures in this window has no affect...

I'm in the "Update Model from Database" wizard not the Model Browser.

Thanks,

Mark

[Former Member]

Hi Mark,

For EDM we use SQL, not catalog stored procedures, to provide the listing of the items.

In the case of the sprocs, it looks like the order by clause is messed up. It is not using name of proc.

Since we can't access this SQL we can't workaround it.

Are you able to open incidents with SAP?  We need one to log this to Engineering. The SQL is built into the Provider and need to create CR (change request) to resolve this.

Cheers,

-Paul

[Former Member]

Hi Paul,

I created an incident report. Its been broken for a long time. I hope it gets fixed soon.

Thanks for the explanation!

Mark

[dawn_kim]

Hi Mark,

What version of Studio and what version of EF?

Thanks,
Dawn Kim