How to pass data from one Api Controller to another Api controller?

Question

Hello Sir, I'm trying to pass the data from Multi_DB_LoginController : ApiController to Multiple_SelectController : ApiController. From Multi_DB_LoginController : ApiController I wanted to pass the selected database i-e connStr to Multiple_SelectController : ApiController and all the apicontrollers present in the project. Using these Web Api's to connect Mobile App to the database. Please help me. Thank you and Regards.

Sachin Singh · Answer

you can also create a class to change connection dynamically as per user selection. public class Connection { public string ConfigurnewConnectionString( string server, string database, string userid, string password, string ConnectionString) { System.Configuration.Configuration Config1 = WebConfigurationManager.OpenWebConfiguration( "~" ); ConnectionStringsSection conSetting = (ConnectionStringsSection) Config1.GetSection( "connectionStrings" ); conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace( "{0}" , server); conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace( "{1}" , database); conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace( "{2}" , userid); conSetting.ConnectionStrings[ConnectionString].ConnectionString = conSetting.ConnectionStrings[ConnectionString].ConnectionString.ToString().Replace( "{3}" , password); return conSetting.ConnectionStrings[ConnectionString].ConnectionString; } } // in your user selection if (obj.DatabaseName == "PersonDatabase" ) { ConStr = objConnection.ConfigurnewConnectionString(obj.Servername, obj.DatabaseName, obj.UserId, obj.Password, "PersonDatabaseEntities" ).ToString(); } else if (obj.DatabaseName == "EmployeeDatabase" ) { ConStr = objConnection.ConfigurnewConnectionString(obj.Servername, obj.DatabaseName, obj.UserId, obj.Password, "EmployeeDatabaseEntities" ).ToString(); }

Sachin Singh · Answer

after going through your code, i can understand that you want to store client selection (database) so that you can pick right connection string in web api, Though it is not right solution but you can use Session in web api , to use session in web api in your global.asax (MVC) file add below lines of code public override void Init() { this .PostAuthenticateRequest += MvcApplication_PostAuthenticateRequest; base .Init(); } void MvcApplication_PostAuthenticateRequest( object sender, EventArgs e) { System.Web.HttpContext.Current.SetSessionStateBehavior( SessionStateBehavior.Required); } Now you can use Session to store Client Selection in web api.

Sachin Singh · Answer

create a common base class and use with different controllers public abstract class MyBaseController:ApiController { public void CommonMethod() { // Do something here } } then use them like public class ControllerA : MyBaseController { public void MethodA() { base.CommonMethod(); // Do something else } } public class ControllerB : MyBaseController { public void MethodB() { base.CommonMethod(); // Do Something else } }

Demo Cloud · Answer

Hello, Im using these Api controllers to connect the database with the mobile app. Please help. I've also attached the code for the controllers where i'm trying topass the selected database from on APi controller to another. Thanks

How to pass data from one Api Controller to another Api controller?

Answers (4)