I am new in Umbraco. I want to create relational database structure through Umbraco, have one to many relational tables which are dependent each other
Please suggest the best approch to handle this
I tried manually created tables in the database same where umbraco resides and made a dashboard tab inside back office and tried to manage through User Controls
How to manage relational data with Umbraco
Hi All,
I am new in Umbraco. I want to create relational database structure through Umbraco, have one to many relational tables which are dependent each other
Please suggest the best approch to handle this
I tried manually created tables in the database same where umbraco resides and made a dashboard tab inside back office and tried to manage through User Controls
Can you please suggest which method is suitable
Thankyou
Hi Gufran,
I'm thinking of two ways: PetaPoco or NHibernate.
Both are open source object-relational mapper for the .NET framework.
Maybe this is a good starting point for you:
http://www.toptensoftware.com/petapoco/
http://nhibernate.info/
Hope this helps?
Best,
Sören
Thanks Soren!!!
But how to integrate PetaPoco with umbraco back office
Could you please help on this
Hi Gufran, uCommerce also make this a little easier to manage relation data using NHibernate. Please note this requires uCommerce to be installed. You can read more about uCommerce and NHibernate in this doc. http://docs.ucommerce.net/ucommerce/v6.6/extending-ucommerce/save-custom-data-in-the-database.html
is working on a reply...