StoredProcQuery

I am trying to bind a data grid to the result of a stored procedure call. I added the stored procedure to the entity data model. I built my own custom complex entity type. 

I edit the CSDL content
 in XML. I have a tool which generates the XML by iterating through a 
dataset returned from a call to the proc. It is much faster than doing 
it by hand.

<ComplexType Name="PatientGetRS_Result">
              <Property Type="Int32" Name="ObjectParentID" Nullable="true" />
              <Property Type="String" Name="LastName" Nullable="true" MaxLength="50" />
              <Property Type="String" Name="FirstName" Nullable="true" MaxLength="50" />
etc
etc
 </ComplexType>

I imported the procedure , inspected the class and associated properties, and all was right with the world. I created a simple xaml with only the data grid and bound it to the ObservableCollection<PatientGetRS_Result> using the complex type. 

When I run the app the data grid columns are auto filled but have extra columns not in the <PatientGetRS_Result> class. These include ParentProperty, ParentEntity, VerifierEngine, EntityManager, EntityMetadata, 2 instances of Item, and SerializationContext. 

When Silverlight attempts to bind it fails since "Type" occurs twice. I get a "Ambigious Match Found" exception due to the 2 instances of "Item". 

Why is DevForce adding these other fields??

I realize that I can set AutoGenerateColumns="False" and then add the columns manually but that really takes away from the elegance of this entity framework.

This is a fix but once again hacky!!!

           var Patient = new PatientGetRS_Result();
            PropertyInfo[] properties = Patient.GetType().GetProperties();
            Array.ForEach(properties, oPropertyInfo =>
            {
                if (oPropertyInfo.Name == "Item")
                    return;

                dataGrid1.Columns.Add(new DataGridTextColumn { Header = oPropertyInfo.Name, Binding = new System.Windows.Data.Binding(oPropertyInfo.Name), IsReadOnly = true });
            });

Once this is done the binding works and the grid updates.

Edited by cbondeson - 24-Jul-2010 at 5:34am