ASP.NET ASPX Administrative Grids Template Suite

Re: Error if Editing Employees Territories

johnhbarrett — Sat, 25 Apr 2009 05:36:48 GMT

No problem. i'm thinking of renewing my license after a spell away from the world of ES (using LINQ-To-NHibernate).

I must say, i'm very impressed with the progress your team has made - i'll certainly be recommending this product at the next opportunity.

Is there any thoughts around the xaml space?

Cheers, John

Re: Error if Editing Employees Territories

David.Parsons — Sat, 25 Apr 2009 05:06:49 GMT

Thx for the heads-up. We probably should not have told the Admin Grid template to generate an "Edit" page for it, as there is nothing to edit.

EntitySpaces does not allow changing/updating a primary key field. The Northwind EmployeeTeritories table is a simple cross-reference for a Many-to Many. All the fields in it are part of the primary key. You can only delete a EmployeeTerritory record (dissociate a Territory), or add one (associate).

Error if Editing Employees Territories

johnhbarrett — Sat, 25 Apr 2009 02:37:29 GMT

1. Run thge on line demo

2. select any record

3. edit the territoy record for that person simply by selection a different on in the territory ddl

get an "invalid Sql message or similar...