variable name in the place of class name

Question

Hello, Can someone please help me to find a way to put a variable name which will store the class name read from the database in the place of the class name "Role1" in the below code. IEnumerable dataresult; dataresult = connection.Query ("sp_ReadGridData", new{ gridname ,id, usrname, LinkId }, commandType: CommandType.StoredProcedure); return Request.CreateResponse(DataSourceLoader.Load(dataresult, loadOptions)); Thanks, Hanusha

Sachin Singh · Answer

var RoleType1= getRoleId(); Type RoleType= Type.GetType(RoleType1); var RoleType= getRoleId(); // the current logged in user's Role IEnumerable dataresult; dataresult = connection.Query( "sp_ReadGridData" , new { gridname ,id, usrname, LinkId }, commandType: CommandType.StoredProcedure); return Request.CreateResponse(DataSourceLoader.Load(dataresult, loadOptions));

Sachin Singh · Answer

A generic method to query database with Dapper. public static IEnumerable ListReader ( string procedure, string DbName = "TEST" ) { using (IDbConnection con= new SqlConnection(ConfigurationManager.ConnectionStrings[DbName].ConnectionString)) { return con.Query (procedure, values, commandType: CommandType.StoredProcedure).ToList(); } }

Anu · Answer

Hello Sachin, Thanks alot for your suggestion. Can you please let me know how can I involke the method you suggested from mycode. Below is the code where I hardcoded the class name that I need to change to variable name. public HttpResponseMessage GetAll(DataSourceLoadOptions loadOptions) { int LinkId = Convert.ToInt32(HttpContext.Current.Session["LinkId"].ToString()); string roleid = HttpContext.Current.Session["Role"].ToString(); string usrname = HttpContext.Current.Session["UserName"].ToString().Trim(); string gridname = "Grid1Sp"; string id = ""; IEnumerable dataresult; dataresult = connection.Query ("sp_ReadGridData", new{ gridname ,id, usrname, LinkId }, commandType: CommandType.StoredProcedure); return Request.CreateResponse(DataSourceLoader.Load(dataresult, loadOptions)); } Thanks, Hanusha

Kiran Mohanty · Answer

Hi, Then you can type cast your dynamic string type to a specific class type. Ex:- var type = Type.GetType("dynamicInput");

Anu · Answer

Hi Kiran, Thanks for checking this. Based on your suggestion from the calling function we have give the class name. But in my application the class name will be identified at runtime. Thanks, Hanusha

Kiran Mohanty · Answer

You can define a generic method here. It will do the job. private object DatabseFunction(T classType) { IEnumerable dataresult; dataresult = connection.Query ( "sp_ReadGridData" , new { gridname ,id, usrname, LinkId }, commandType: CommandType.StoredProcedure); return Request.CreateResponse(DataSourceLoader.Load(dataresult, loadOptions)); } //call from calling method as DatabseFunction(Role1);