Hi,
Can I use the WebHierarchicalDataGrid and WebHierarchicalDataSource with the Entity Framework 4.0?
Do you have any demos or sample code?
Cheers,
CP
Hello Claudio,Please take a look at the attachment. There is a sample using northwind with the requested WHDG and webhierarchicaldatasource. Please let me know if the sample is helpfull. The sample is with the latest possible at the moment version of NetAdvantage for ASP - 12.2.20122.2029
Hi Nikifor,
Could you please advise what training video I would have to watch to in order to learn how to work with the WebHierarchicalDataSource and the Entity Framework 4.0?
I am looking for a training video that will show how to work with Many to Many, One to Many relationships, insert, update, delete, modify records etc..
Claudio
Hello Claudio,
After some research, RQ video for working with entity framework 4.0 has been determined to be a new product idea. I have sent your product idea directly to our product management team. Our product team chooses new product ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this product idea is PI12110113.
If you would like to follow up on your product idea at a later point, you may contact Developer Support management via email. Please include the reference number of your product idea in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request. If you have specific issues with the hierarchical grid bound to Entity datasourse please open a new support ticket regarding this issue or start a new forum thread if it is not related to this one.
Hello Claudio,Please let me know if you have any further questions regarding this issue.
Hi Nikifor,I finally had time after some health problems to review the application sample you kindly provided. However, my question was a bit more complex.In the Northwind database we have the Orders, OrderDetails Products and categories tables. The OrderDetails table work as a mapping table even though it has more fields like UnitPrice, Quantity and Discount. So we have a many to many relationship Orders-OrderDetail-Products like this:
Orders---------> OrderDetails <--------Products<--------Categories.
1 - Can we use the Infragistic WebHierarchicalDataGrid and WebHierarchicalDataSource with the Entity Framework 4.0 so that we could create a grid and display all the related entities?
2 - Could we use CRUD operations on the grid? Would the WebHierarchicalDataGrid and WebHierarchicalDataSource know how to send the updates, insertions, deletes and using filters with the entity framework?
Example: The grid would display the following:
OrderID, OrderDate, Freight, ShipName, ShipCity (from Orders)UnitPrice, Quantity, Discount (from OrderDetails) ProductID, ProductName, CategoryName, Description (from Products and Categories)
3 - If I updated the CategoryName and save, will it be saved to the right Category table?
4 - What about to create a new record using all tables? what is the best way?
This is the kind of tutorial I think you should be creating to help people like me that use the Infragistic controls.
Could you please provide a sample code for the scenario described above?
Cheers
C