public string GetValues() { //ModelClass objModel = new ModelClass(); DataSet ds = new DataSet(); DALCommon objDALCommon = new DALCommon(); Dictionary <string, string> StoredProcedureParams = new Dictionary <string, string>(); StoredProcedureParams.Add("@Parameter1", "Parameter1_Value"); ds = objDALCommon.DBCall(configuration.GetConnectionString("NewBusiness"), "STORED_PROCEDURE_NAME", StoredProcedureParams); objDALCommon.AssignTableName(ref ds); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //assign to Model //objModel.SomeProperty = ds.Tables["Table1Name"].Rows[0]["ColumnName"].ToString(); } return(JsonConvert.SerializeObject("objModel")); }