MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Possible integration with another database (Zatvorena) (Mono Support )

70673 put(a) pogledan, 6 odgovor(a) 30.7.2011. 8:16:14Kreirao(la) NaveedAnjum

Povezane teme

NaveedAnjum

NaveedAnjum

30.7.2011. 8:16:14
I have another database on SQL Server and have a number of customers stored in that database. Now i want to use that customer information in monox community site so that they becomes community member.

My question is what are the possible integration options with another database in monox ?
Ovaj sadržaj još nije ocijenjen. 
36 Reputacija 3 Ukupno objava
khorvat

khorvat

30.7.2011. 8:31:58
Hi,

I think the best way to approach this is to implement custom Membership provider (on top of MonoSoftware.MonoX.MonoXMembershipProvider which inherits AspNetSqlMembershipProvider) and custom Role manager (on top MonoSoftware.MonoX.MonoXRoleProvider which inherits AspNetSqlRoleProvider). That way you can use MonoX database for the CMS and your own database for the user management. 

If you choose this approach let us know so we can provide you with the additional information that you will need to perform this task.

Some references that may help

Introduction to Membership
You can read more about extending ASP.NET membership here.

Regards
Ocjena 3,50, 2 glas(ova). 
15993 Reputacija 2214 Ukupno objava
denis

denis

30.7.2011. 16:00:10
The Membership and Role provider strategy Kristijan recommended is the easiest and the most elegant approach to ASP.NET application integration (it is also used to communicate with other authentication systems like ActiveDirectory, or other databases like MySQL or Oracle). Here is another article that can help you understand the basic principles: Membership and Role providers in ASP.NET 2.0.
Ovaj sadržaj još nije ocijenjen. 
7207 Reputacija 956 Ukupno objava
NaveedAnjum

NaveedAnjum

1.8.2011. 6:21:31
Thanks khorvat and denis for quick reply. When i will integrate it with our custom DB i will let you know.

Ovaj sadržaj još nije ocijenjen. 
36 Reputacija 3 Ukupno objava
shawndg

shawndg

1.8.2011. 11:45:50
I don't know how much you already have that you want to cross over.

But.. IT is fully possible to also do a database conversion script to pull a list of customer from your old database and insert them into the MonoX aspnet_users table. I'm not 100% sure on the name right off hand but you could do it.

You could also then build your own ext table and store any extra customer data the user has and then to display it or allow MonoX users to edit it or even register using it.. You would extend the MonoX registration system.
Ovaj sadržaj još nije ocijenjen. 
1871 Reputacija 252 Ukupno objava
khorvat

khorvat

2.8.2011. 8:58:33
Hi,

just a small note, if you proceed with the Shawndg suggestion you will also need to import data in the aspnet_mebership DB table as aspnet_users and aspnet_membership are tightly connected.

BTW there is also a UserProfile DB table that you can use to store an extra customer data.

Regards
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava