I have a stand alone MVC 5 solution that contains 8 tables, and I would like to offer it for public so, I decided to have it as plugin/package or module in a well-known CMS instead of being stand-alone solution mainly for security and user management.
I have tested Umbraco in order to develop a package in visual studio to create 2 database tables with read and write functions and I feel that Umbraco is not easy for such solutions, and I hope hear from you that my feeling is wrong.
Is it easy to develop a package with many database tables and many views in Umbraco?
May you please suggest some free packages with source code to learn form.
Anyways, Umbraco utilizes a small framework called PetaPoco, which you can use for creating tables as well as the typical read, insert, update and delete you would expect when working with a database.
Warren Buckley has written an article about PetaPoco, which you can find here:
Umbraco is designed primarily as a content-management system, so it's built around the content being stored within Umbraco rather than external tables. Having said that, you can integrate it with a database in a number of ways.
A quick way to do this would be to use a package such as Fluidity - I'd recommend it if you want a quick CRUD interface to some database tables:
Stand-alone solution to Umbraco plugin
Hi,
I have a stand alone MVC 5 solution that contains 8 tables, and I would like to offer it for public so, I decided to have it as plugin/package or module in a well-known CMS instead of being stand-alone solution mainly for security and user management.
I have tested Umbraco in order to develop a package in visual studio to create 2 database tables with read and write functions and I feel that Umbraco is not easy for such solutions, and I hope hear from you that my feeling is wrong.
Is it easy to develop a package with many database tables and many views in Umbraco?
May you please suggest some free packages with source code to learn form.
Regards,
Easiness is always a relative term.
Anyways, Umbraco utilizes a small framework called PetaPoco, which you can use for creating tables as well as the typical read, insert, update and delete you would expect when working with a database.
Warren Buckley has written an article about PetaPoco, which you can find here:
https://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/
The article is back from 2013, but I think the code is still valid.
I have used PetaPoco for some of my packages as well, so you can have a look at the files below for inspiration:
https://github.com/skybrud/Skybrud.Umbraco.Redirects/blob/master/src/Skybrud.Umbraco.Redirects/Models/RedirectsRepository.cs
https://github.com/skybrud/Skybrud.Umbraco.Redirects/blob/master/src/Skybrud.Umbraco.Redirects/Models/RedirectItemRow.cs
https://github.com/skybrud/Skybrud.Umbraco.Feedback/blob/master/src/Skybrud.Umbraco.Feedback/FeedbackModule.cs#L120
https://github.com/skybrud/Skybrud.Umbraco.Feedback/blob/master/src/Skybrud.Umbraco.Feedback/Model/Entries/FeedbackDatabaseEntry.cs
I hope that helps ;)
Umbraco is designed primarily as a content-management system, so it's built around the content being stored within Umbraco rather than external tables. Having said that, you can integrate it with a database in a number of ways.
A quick way to do this would be to use a package such as Fluidity - I'd recommend it if you want a quick CRUD interface to some database tables:
https://umco.github.io/umbraco-fluidity/
is working on a reply...