Mono Support Extending monox database tables 

Viewed 18924 time(s), 3 post(s), 7/21/2015 7:54:26 PM - by GoodChuck
7/22/2015 12:55:11 PM
25 Reputation 2 Total posts

My apologies if I have missed this. This is only my third day with the platform. I’ve been sifting through the support threads since this morning looking for some example or explanation about extending database tables initially provided by monox installation.

While many topics covered how to customize webparts, which some are outdated by now, none of the topics mentioned the data layer and how it will be handled by monox.

To give a concrete examples, which incidentally what I am trying to do, I would like to add an additional column in the userprofile table that would act as a foreign key to a new custom table.  

Another example; I would like to add more fields to the event. Such as event banner, event google map and so much more.

Almost all my clients’ form are specific and need some degree of customization, is there an example that would give me a good head start?

 

Thank you very much for your help.

1
7/22/2015 3:56:46 PM
15993 Reputation 2214 Total posts

Hi Chuck,

The easiest way is to use open sourced MonoX DAL layer that can be found on GitHub. To extend DAL (user profile, events etc.) you just need to add those fields to the tables and then regenerate DAL projects. You can use LLBLGen Designer Trial version to generate changes. After that your fields will be available in the DAL and you can use them on other layers.

Beside this you can follow these blog posts:
Building-a-custom-ASP-NET-project-based-on-MonoX
How-to-Extend-MonoX-and-ASP-NET-Profile

Let us know if you need anything else.

Regards

2
7/22/2015 4:58:03 PM
25 Reputation 2 Total posts

Thank you Khorvat for the prompt reply.

I will give it a shot and let you know how it goes.

Best regards

3
This is a demo site for MonoX. Please visit Mono Software for more info.