Is there a way to generate SELECT SP's for views using ES2008?

Hi

I don't think there is a "built in" method of generating stored procs for views - I'm sure there's a valid reason for the decision behind that by the team, but....

Putting together a template (MyGen or Codesmith) to create your select procs wouldn't be too difficult at all so that wouldn't be an issue, that wouldn't "solve" the issue completely though as the generated Load() and LoadAll()'s for views (in the "Generated" classes) are coded to use dynamic SQL so you would need to provide an Override in your "Custom" classes - I've just tested this against one of my views (created a quick "Select *" stored proc against a view, added a "LoadAll()" overload to my Custom class that uses the "esSqlAccessType.StoredProcedure" param and it worked fine - no other changes were made or needed to be made.

So, in a nutshell, don't think it's built in, but it's really (really!) simple to DIY.

Cheers

Martin

The reason we do not really generate procs for views is that views don't have primary keys and such ....

---

EntitySpaces | Twitter | BLOG | Please honor our Software License

Hi Mike

I assumed it was based around that (or more precisely to do with views not generally being updatable) but Select procs would be easy enough for a user to add (using one of the sample skeleton templates as a base if they're not familiar with template design for example)

Cheers

Martin