Activities of "Qloud"

Hello,

mutli tenant - multi db is very good concept.

I have just few question here. Suppose our application have multi-tenant - multi db concept. and we got new 100 db and meanwhile we are working with few custom fields or custom table on application then how it will done for all db? means how we can migrate easily? Or do you have system like if we add one custom field/table then it will create for all current tenant db automatically? and for this scenario what is the solution when application is live already then some minor customization needed then how our customer will migrate? or how we can help them. Many questions :shock:

Please advice.

Awaiting for your response.

Thanks

Hello,

Here is the right solution for my issue.

#1123

Thank you Ismil, hikalkan and ismcagdas :)

Hello Hikalkan,

What is the solution for my issue?

Hi Hikalkan,

Basically we can't explore personal detail on forums that's why i put {Server}, {dbname}, {Password} like that.

:)

Hello ismcagdas,,

I am trying to run still on local system.. so yes my application is running on my visual studio and yeah sql server also on my same system.

Let me know the next step to resolve this issue.

Thanks

Hello ismcagdas,

Yeah this service is already running on my system. Let me know the next step to resolve this issue.

Dear ismcagdas,

As per hikalkan mention in documentation We have to enable MSDTC. not a DTC

And when we right click on the "Local DTC" then click properties. then in security tab showing Network DTC Access.

So may i know if i enable this option then Multi tenant – multi databases will work?

Find attached for reference.

Awaiting for your response.

Thanks

Hello Hikalkan,

Thank you for your quick response.

I got a step for enable MSDTC [https://technet.microsoft.com/en-us/library/cc759136%28v=ws.10%29.aspx]). but on last step they mention Hit the Security Configuration button in MSDTC tab. But in my windows 10 not available this option in MSDTC tab. please see attached.

Can you please suggest me how we can enable MSDTC when we are on local development.

Awaiting for your answer.

Thanks,

Hello,

I have downloaded code and i have proceed with below steps. database is created but empty and getting error on tenant creation.

1. Added master connection string on web.config
2. Run Update-Database command.
3. Now application is working perfectly with default tenant.
4. Then creating tenant and i am passing connection string with credential and without credential also getting same error.

Server={servername};Database={dbname};User ID=sa;Password={password}; Server={localhost};Database={dbname};Trusted_Connection=true;

I have try with above two connection string. database created successfully. but not creating tenant on tenants table in master database.

I have followed this document. <a class="postlink" href="http://volosoft.com/aspnet-boilerplate-v0-9-and-aspnet-zero-v1-10-have-been-released/">http://volosoft.com/aspnet-boilerplate- ... -released/</a>

Do you have any other document? step by step?

Error (Stack trace) System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: MSDTC on server '{Server}' is unavailable. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) at System.Data.SqlClient.TdsParser.GetDTCAddress(Int32 timeout, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.GetDTCAddress() at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx) at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx) at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction) at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction) at System.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultip...

Awaiting for your answer.

Thanks

Hello Hikalkan,

Thanks for your quick and helpful response.

1. It's very easy:

• Add your property to User entity
• Add same property to UserListDto (if you want to show on the grid). It will be auto-mapped.
• Define grid column in the User page.
• If you want to edit this column while creating/editing user, you can add a new form field to user create/edit modal, change editing DTO and update code.

But this is not special to users. Once you understand the relation between entity, dto, application services and UI layer, you can do everything. I suggest you to read this document to understand their relation: <a class="postlink" href="http://www.aspnetzero.com/Documents/Dev">http://www.aspnetzero.com/Documents/Dev</a> ... y-Step-MPA

I have added phoneNo field in User entity and UserListDto as per your suggestion. Then i have create field in database using add-migration command. by the way field added successfully. Now i have added code for display phone no field value in grid in index.js of angular code but data is not displaying :(

Then i've convert to MPA application and put same change in index.js file for MPA. But here also result is same display is column but data is not showing. May i know is there any step is missing.

Below is code that i've added Index.Js file.

Angular.js (User)

{
                        name: app.localize('Phone'),
                        field: 'Phone',
                        minWidth: 100
                    }

MVC (User)

Phone: {
                    title: app.localize('Phone'),
                    width: '15%'
                },

Is there anything need to change in ABP project? I have just used DLL. I didn't download ABP code and didn't added in my project solution.

And I am little bit confuse about your mvc version. Basically when we are working on mvc then we are binding model in controller and then passing data from controller to view. But here you guys are using services in direct JS file like >var _userService = abp.services.app.user; May know what is the difference between normal MVC concept and yours?

Awaiting for your response.

Thanks, Rama