variable name in the place of class name

Anu

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
  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));
Anu5y ago
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
Sachin Singh5y ago
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();
    }
}
Kiran Mohanty5y ago
Hi,
Then you can type cast your dynamic string type to a specific class type.
Ex:-
var type = Type.GetType("dynamicInput");
Anu5y ago
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 Mohanty5y ago
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);