Developing Multi Tenant functionally for Nopcommerce... brain storming

Hi,I'd like to share this!

1- I think it is better & easier for multi-tenant support to start in NC code & not plugin.

2- As SAAS provider , I agree to use separate db approch to avoid long run upgrades & conflicts when having too many customers concerning security & db overload.

3-  For querying multi-tenant databases, I found this library http://enzosqlshard.codeplex.com/ from the links I previously mentioned,I haven't try it yet!

4-We'll consider default  NC installationto be store owner or SAAS provider.    

5-Now,our registered customers will be our tenants! (i.e B2B).

6-We'll add a Tenant Table in default NC db including fields (Id,CustomerId,DB_Path,....).

7-CustomerId in Tenant Table  is FK to Customers table.

8-We'll use DB_Path with enzosqlshard for querying tenant db. Again,I haven't try it yet!

7-We'll create new table  Tenant_Entity_Mapping (Id,TenantID,EntityID) just like StoreMapping design to serve as config foreach tenant  to indicate which payment method,shipping method,.. that our Tenant subscribe to let our
ONE DEFAULT COPY OF NC use it in routing.


8-For routing,we have front & back ends!
  I think it is better to create ITenantContext something like IStoreContext & use it in classes BaseNopController in both
  NopWeb & Admin for the sake of routing,we also may include new customer role Tenant to be used much like Vendor
rule in front end & Admin role in back end.

I hope it may helps!

Thanks Keem for the amazing post!  I really appreciate you posting this, it helps to have an outline of the right steps to take.  I am new to development so this guide line with be very beneficial to me.  

The library looks very promising for the multi tenant databases.  The one question I have it that it says on the requirements that you need .NET 4 framework with visual studio 2010.  Will this mean that it will not work with nopcommerce version 3 since that is .NET 4.5 framework?

Please keep us all updated on how it works out for you.  I am really excited about this!  

I will let you know if I run into any problems. :-)  Thanks!

Regards,

Tim

hi
Not much to say today - but I did find this : http://lonetechie.com/2012/09/25/multi-tenant-architecture-with-asp-net-mvc-4/

seems to have worked out the how.

Hi
Just found this : https://www.nopcommerce.com/p/1/nopcommerce-copyright-removal-key.aspx
How will this affect it - Will we need a license for each TENANT ?

Thanks

deltaoo wrote:

Thanks for sharing the link.


deltaoo wrote:

I think that you would if you wanted to remove the "powered by nopcommerce". But couldn't you just leave the "powered by nopcommerce"?

You could ask on this thread to double check with Andrei: https://www.nopcommerce.com/boards/t/18/powered-by-nopcommerce-copyright-removal-notice.aspx

hi guys!
Has there been any traction on this?

deltaoo wrote:

Hi deltaoo,

I had to put this project on hold to finish two engineering college classes I was taking over the summer... Dynamics and Deforms.  I have not got my grade yet, but I am thinking I might get an A in both. :-)

I am not sure, but I am guessing Keem might have already completed this.  What about you, how far have you got?  I would be interested in hearing if there were any parts you had trouble with.

I really would like to build this multi tenant capability.  Once I can get some time to work on it, I am planing on trying to figure out how to do the parts that I was still unsure about.

Regards,

Tim

Hi
Good luck hope that A comes your way /

@Keem : any progress on your end ?

I'm  only just starting to get into this - my approach won't be a plugin - rather a "wrapper" around everything

fingers crossed

Hi ,I'm afraid I'm currently busy in another project.

But I think you might find this useful

https://cloudninja.codeplex.com/

http://www.fabrikamshipping.com/

+1 for the Multi Tenant functionally