How do I use ConnectionManager in csla in a blazor program? How do I do dependency injection?

[knox007]

I am using csla.net 8.2.9, but I still want to use ADO.NET to connect to the database. I want to use ConnectionManager under Csla.Data to manage the database connection. How should I set it up and use it?

[rockfordlhotka]

The connection managers were removed in favor of using dependency injection with .NET 8.

If you want to use the old ConnectionManager, you'll need to take it from the previous version of CSLA and include it directly in your project.

I recommend using DI though, as this is the modern way to manage connections.

[knox007]

I have obtained ConnectionManager from the previous version, included it into my project, and implemented dependency injection. However, there is a problem that when ConnectionManager is disposed, ApplicationContext is always null. I don't know why?

[knox007]

I understand a little bit if ConnectionManager is not di enabled in CSLA.NET 8 or later?

[rockfordlhotka]

You'll probably need to change ConnectionManager to have the ApplicationContext injected.

[knox007]

I changed the ConnectionManager constructor to inject ApplicationContext into it, but it worked fine when I created the database connection. When I tried to release the database connection, ApplicationContext was null. Is there anything else that needs to be changed?

[knox007]

@rockfordlhotka

[StefanOssendorf]

How are you retrieving the connection manager instance?
And how is the connection manager registered in your di?

[knox007]

Thanks for your response,Previously, csla 3.8 was used,Now I want to upgrade to CSLA.NET8.2.9 or CSLA.NET9.0.0, and make blazor server program, is currently a variety of difficulties, due to historical reasons a lot of business logic is still using sql server stored procedures

[Chicagoan2016]

This discussion #3287 might help.

[Chicagoan2016]

Also #2979

[knox007]

I have a problem with nested transactions in the solution proposed by #2979. I have carefully read and thought about the process you provided above. In the figure below, The step I've identified should be the subitem business class update operation, where the subitem business object invokes its DAL class for database operations?

Also I was interested in the comments class you raised above, which can be saved as root , and there is a transaction d amount management mechanism, could you tell me more about this class, I would like to know its working logic

@hurcane

[hurcane]

I don't think more details from my codebase is going to help you with your nested transaction scenario. My code uses the [Transactional] attribute, so transactions are implicitly handled. Instead of me providing general guidance that may not apply for your scenario, maybe you could share more about what you have tried so far?

What is the code for the service class you are using? How is the service being instantiated during startup? And how is your current DAL code implemented between your parent and child?

In theory, the class the defines the database service from #2979 should be handling BeginTransaction, Open, Close, and EndTransaction all within the service class. If it is available as a scoped service, then you should have a single instance and BeginTransaction should only get executed a single time, even if the service is requested multiple times.

[knox007]

Yes, what you said is right, I should be concerned about the function implementation and use logic of my code ,I used the logical method in #2979 to inject the connection into the DAL,I did not create and use a database connection in the BO class ,So this is the main reason for nested transactions ,By letting the child dal do database operations in the parent BO class first, and then do data operations in the parent class, and then do transaction commits in the parent dal after completion, this can solve the problem of nested transactions, It's just that the business logic looks a little fuzzy ,I thought about your suggestion to create database connections and transactions in the parent BO class and pass the connection to the child, but I think it should be similar to the process mentioned above, just in a different pattern ,Thank you very much for your reply, it is really helpful to participate in the discussion on github. @hurcane @Chicagoan2016

[hurcane]

Why do you say that this is a nested transaction? It looks to me like the line update and the header order are using the same connection and the same transaction. I don't think you even need to be assigning the transaction on the command because the connection already has a transaction assigned to it when the command is created.

[knox007]

Sorry for the late reply. After reading your reply, I understand that my code does not belong to nested transactions, and I always think that it is a nested transaction. Thank you for letting me understand this point。 @hurcane