logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error
How to change database connection at runtime?
Options
Go to last post Go to first unread
Previous Topic Next Topic
karan.j.shah  
#1 Posted : Friday, September 20, 2019 2:07:39 PM(UTC)
karan.j.shah

Rank: Newbie

Groups: Registered
Joined: 9/18/2019(UTC)
Posts: 0
India
Location: surat

Thanks: 1 times
Hi All,

I have one query while integrating seal report in asp.net mvc application.

I have created multi-tenant web application.

At the time of login,we will fetch database connection string and put that connectionstring in session and use it in all other places.

Now I want to implement same logic for seal report.

I have integrated seal report with my asp.net mvc application with fix database connection string.

Now I want to change connectionstring for that seal report at runtime?

Is it any possible for above query?

Any help will be very grateful for me.

With Regards,

Karan Shah
Back to top

Wanna join the discussion?! Login to your Seal Report Forum forum accountor Register a new forum account.
Back to top  
epf  
#2 Posted : Friday, September 20, 2019 2:56:43 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
You can do that a different places and either in the report Sources or in the Models.

In the main configuration, you have the "Report Execution Init Script" that will apply to all report (Server Manager->Configuration)
Or per report, just create a Task that does the job.
Or you can do it per model in the model "Per Load Script"...

Here are the objects from a Report:
report.Sources[0].Connections[0].ConnectionString = "";
report.Models[0].Connection.ConnectionString = "";


You can also change the repository sources:
repository.Sources[0].Connections[0].ConnectionString = "";

This can be done in the Login Script of your security provider (Server Manager->Configure Web Security->Custom Security Script).

Check https://sealreport.org/Sources
Objects: https://sealreport.org/H...5c-2fb4-831f151b72a7.htm
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET 2.2.4.11 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.058 seconds.