public static bool ModifySPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, object SPValue, int size = -1) { if (activeSPEntry == null) { return(false); } else { SqlParameter activeParameter = null; foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters) { if (tmpParameter.ParameterName == Paramername) { activeParameter = tmpParameter; break; } } if (activeParameter != null) { activeParameter.Direction = SPDirection; activeParameter.SqlDbType = SPType; activeParameter.Value = SPValue; if (size != -1) { activeParameter.Size = size; } return(true); } else { return(false); } } }
public bool Action_ExecuteDeleteSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary <string, object> ValueMaping, Dictionary <string, int> SizeMaping) { if (activeEntry != null && ActiveConnection != null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "delete"); foreach (string activeParameter in ValueMaping.Keys) { int activeParametersIndex = Data_SqlSPEntry.GetSPParameterIndex(ref activeEntry, activeParameter); if (activeParametersIndex != -1) { SqlParameter activeExistedParamter = activeEntry.ActiveParameters[activeParametersIndex]; if (!SizeMaping.ContainsKey(activeParameter)) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter]); } else { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter], SizeMaping[activeParameter]); } } } Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; activeSqlSPHelper.Action_ExecuteForNonQuery(activeEntry); return(true); } else { return(false); } }
public static void CopyParams(ref Data_SqlSPEntry sourceEntry, ref Data_SqlSPEntry objectEntry) { foreach (SqlParameter activeParameter in sourceEntry.ActiveParameters) { SqlParameter cloneObj = new SqlParameter(); cloneObj.ParameterName = activeParameter.ParameterName; cloneObj.Direction = activeParameter.Direction; cloneObj.DbType = activeParameter.DbType; objectEntry.ActiveParameters.Add(cloneObj); } }
public static bool AddSPEntryToList(string SPName, SqlDbType SPType, string EntryType, ref List<Data_SqlSPEntry> activeList) { if (activeList == null) return false; Data_SqlSPEntry activeEntry = new Data_SqlSPEntry(); activeEntry.SPName = SPName; activeEntry.SPType = SPType; activeEntry.EntryType = EntryType; activeList.Add(activeEntry); return true; }
public object Clone() { Data_SqlSPEntry newEntry = new Data_SqlSPEntry(); newEntry.ActiveParameters = this.ActiveParameters; newEntry.EntryType = this.EntryType; newEntry.KeyName = this.KeyName; newEntry.SPName = this.SPName; newEntry.SPType = this.SPType; return(newEntry); }
public static bool AddSPEntryToQueue(string SPName, SqlDbType SPType, string EntryType, ref Queue<Data_SqlSPEntry> activeQueue) { if (activeQueue == null) return false; Data_SqlSPEntry activeEntry = new Data_SqlSPEntry(); activeEntry.SPName = SPName; activeEntry.SPType = SPType; activeEntry.EntryType = EntryType; activeQueue.Enqueue(activeEntry); return true; }
public static bool AddSPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, int size, object SPValue) { if (activeSPEntry == null) return false; SqlParameter activeParameter = new SqlParameter(); activeParameter.ParameterName = Paramername; activeParameter.Direction = SPDirection; activeParameter.SqlDbType = SPType; activeParameter.Value = SPValue; activeParameter.Size = size; activeSPEntry.ActiveParameters.Add(activeParameter); return true; }
public static bool AddSPEntryToList(string SPName, SqlDbType SPType, string EntryType, ref List <Data_SqlSPEntry> activeList) { if (activeList == null) { return(false); } Data_SqlSPEntry activeEntry = new Data_SqlSPEntry(); activeEntry.SPName = SPName; activeEntry.SPType = SPType; activeEntry.EntryType = EntryType; activeList.Add(activeEntry); return(true); }
public static bool AddSPEntryToQueue(string SPName, SqlDbType SPType, string EntryType, ref Queue <Data_SqlSPEntry> activeQueue) { if (activeQueue == null) { return(false); } Data_SqlSPEntry activeEntry = new Data_SqlSPEntry(); activeEntry.SPName = SPName; activeEntry.SPType = SPType; activeEntry.EntryType = EntryType; activeQueue.Enqueue(activeEntry); return(true); }
public static bool AddSPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, int size, object SPValue) { if (activeSPEntry == null) { return(false); } SqlParameter activeParameter = new SqlParameter(); activeParameter.ParameterName = Paramername; activeParameter.Direction = SPDirection; activeParameter.SqlDbType = SPType; activeParameter.Value = SPValue; activeParameter.Size = size; activeSPEntry.ActiveParameters.Add(activeParameter); return(true); }
public bool Action_ExecuteForNonQuery(Data_SqlSPEntry activeSPEntry) { try { if (activeSPEntry == null) { return(false); } else { if (activeconnection != null) { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { SqlParameter newParameter = new SqlParameter(); newParameter.ParameterName = activeParameter.ParameterName; newParameter.SqlDbType = activeParameter.SqlDbType; newParameter.DbType = activeParameter.DbType; newParameter.Direction = activeParameter.Direction; newParameter.Value = activeParameter.Value; cmd.Parameters.Add(newParameter); } cmd.Connection = activeconnection; cmd.ExecuteNonQuery(); return(true); } else { return(false); } } else { return(false); } } } catch { return(false); } }
public DataSet Action_ExecuteGetSPSForDS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection) { DataSet ds = new DataSet(); if (activeEntry != null && ActiveConnection != null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get"); Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; activeSqlSPHelper.Action_ExecuteForDS(activeEntry, out ds); return(ds); } else { return(null); } }
public bool Action_ExecuteForDT(Data_SqlSPEntry activeSPEntry, out DataTable resultDT) { resultDT = null; try { if (activeSPEntry == null) { return(false); } else { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { SqlParameter newParameter = cmd.CreateParameter(); newParameter.ParameterName = activeParameter.ParameterName; newParameter.DbType = activeParameter.DbType; newParameter.Direction = activeParameter.Direction; newParameter.Value = activeParameter.Value; cmd.Parameters.Add(newParameter); } cmd.Connection = activeconnection; SqlDataAdapter sda = new SqlDataAdapter(cmd); resultDT = new DataTable(); sda.Fill(resultDT); return(true); } else { return(false); } } } catch { return(false); } }
public static int GetSPParameterIndex(ref Data_SqlSPEntry activeSPEntry, string Paramername) { int index = 0; if (activeSPEntry != null) { foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { if (activeParameter.ParameterName == Paramername) { return(index); } index++; } return(-1); } else { return(-1); } }
public SqlDataReader Action_ExecuteGetSPSForDR(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection) { if (activeEntry != null && ActiveConnection != null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get"); Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; SqlDataReader dr; if (activeSqlSPHelper.Action_ExecuteForDataReader(activeEntry, out dr)) { return(dr); } else { return(null); } } else { return(null); } }
public bool Action_ExecuteForDS(Data_SqlSPEntry activeSPEntry, out DataSet resultDS) { resultDS = null; try { if (activeSPEntry == null) { return(false); } else { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { cmd.Parameters.Add(activeParameter); } cmd.Connection = activeconnection; SqlDataAdapter sda = new SqlDataAdapter(cmd); resultDS = new DataSet(); sda.Fill(resultDS); return(true); } else { return(false); } } } catch { return(false); } }
public bool Action_ExecuteForDataReader(Data_SqlSPEntry activeSPEntry, out SqlDataReader sqlDataReader) { sqlDataReader = null; try { if (activeSPEntry == null) return false; else { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { SqlParameter newParameter = cmd.CreateParameter(); newParameter.ParameterName = activeParameter.ParameterName; newParameter.DbType = activeParameter.DbType; newParameter.Direction = activeParameter.Direction; newParameter.Value = activeParameter.Value; cmd.Parameters.Add(newParameter); } cmd.Connection = activeconnection; sqlDataReader = cmd.ExecuteReader(); return true; } else return false; } } catch { return false; } }
public static void ModifyExcludeSPParameter(ref Data_SqlSPEntry activeSPEntry, Dictionary <string, object> parameterMaping, List <string> filterParameter) { List <SqlParameter> excluded = new List <SqlParameter>(); foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters) { if (filterParameter.Contains(tmpParameter.ParameterName)) { continue; } if (parameterMaping.ContainsKey(tmpParameter.ParameterName)) { continue; } else { excluded.Add(tmpParameter); } } foreach (SqlParameter tmpExcludeParameter in excluded) { activeSPEntry.ActiveParameters.Remove(tmpExcludeParameter); } }
public bool Action_ExecuteForDT(Data_SqlSPEntry activeSPEntry, out DataTable resultDT) { resultDT = null; try { if (activeSPEntry == null) return false; else { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { SqlParameter newParameter = cmd.CreateParameter(); newParameter.ParameterName = activeParameter.ParameterName; newParameter.DbType = activeParameter.DbType; newParameter.Direction = activeParameter.Direction; newParameter.Value = activeParameter.Value; cmd.Parameters.Add(newParameter); } cmd.Connection = activeconnection; SqlDataAdapter sda = new SqlDataAdapter(cmd); resultDT = new DataTable(); sda.Fill(resultDT); return true; } else return false; } } catch { return false; } }
public static Dictionary <string, Data_SqlSPEntry> Action_AutoLoadingAllSPS(SqlConnection ActiveConnection, string SPType) { if (ActiveConnection != null) { Data_SqlDataHelper obj = new Data_SqlDataHelper(); obj.ActiveConnection = ActiveConnection; string sql_getallsps = "select * from sys.all_objects where (type = 'P') AND (is_ms_shipped = 0)"; DataTable activeSPSDT = new DataTable(); Dictionary <string, Data_SqlSPEntry> result = new Dictionary <string, Data_SqlSPEntry>(); if (obj.Action_ExecuteForDT(sql_getallsps, out activeSPSDT)) { foreach (DataRow activeRow in activeSPSDT.Rows) { Data_SqlSPEntry newSPEntry = new Data_SqlSPEntry(); string spName = ""; obj.Static_GetColumnData(activeRow, "name", out spName); if (SPType != "") { if (SPType == Data_SqlSPEntryType.SelectAction) { if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_SelectAction)) { continue; } } else if (SPType == Data_SqlSPEntryType.UpdateAction) { if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_Update)) { continue; } } } newSPEntry.SPName = spName; newSPEntry.KeyName = spName; string spObjectID = ""; obj.Static_GetColumnData(activeRow, "object_id", out spObjectID); string sql_paramters = "select * from sys.all_parameters where object_id = " + spObjectID; DataTable activeSPParametersDT = new DataTable(); string sql_paramstype = "select * from sys.types"; DataTable paramstypeDT = new DataTable(); if (!obj.Action_ExecuteForDT(sql_paramstype, out paramstypeDT)) { return(null); } if (obj.Action_ExecuteForDT(sql_paramters, out activeSPParametersDT)) { foreach (DataRow activeParamterRow in activeSPParametersDT.Rows) { string activeSystemType_ID = ""; obj.Static_GetColumnData(activeParamterRow, "system_type_id", out activeSystemType_ID); string activeUserType_ID = ""; obj.Static_GetColumnData(activeParamterRow, "user_type_id", out activeUserType_ID); string activeParamsMaxLength = ""; obj.Static_GetColumnData(activeParamterRow, "max_length", out activeParamsMaxLength); string activeParamsName = ""; obj.Static_GetColumnData(activeParamterRow, "name", out activeParamsName); string activeIsOutPut = ""; obj.Static_GetColumnData(activeParamterRow, "is_output", out activeIsOutPut); string max_length = ""; obj.Static_GetColumnData(activeParamterRow, "max_length", out max_length); string activeDBType = ""; DataRow[] dbtyps = paramstypeDT.Select("system_type_id=" + activeSystemType_ID + " and user_type_id=" + activeUserType_ID); if (dbtyps.Length > 0) { obj.Static_GetColumnData(dbtyps[0], "name", out activeDBType); Data_SqlSPEntry.AddSPParameter(ref newSPEntry, activeParamsName, Data_SqlSPHelper.Static_GetDbTypeFromConfigStr(activeDBType), ParameterDirection.Input, int.Parse(max_length), null); } else { continue; } } } else { continue; } result.Add(newSPEntry.KeyName, newSPEntry); } } return(result); } else { return(null); } }
public static int GetSPParameterIndex(ref Data_SqlSPEntry activeSPEntry, string Paramername) { int index = 0; if (activeSPEntry != null) { foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) { if (activeParameter.ParameterName == Paramername) { return index; } index++; } return -1; } else return -1; }
public bool Action_ExecuteForDS(Data_SqlSPEntry activeSPEntry, out DataSet resultDS) { resultDS = null; try { if (activeSPEntry == null) return false; else { if (activeconnection != null) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = activeSPEntry.SPName; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter activeParameter in activeSPEntry.ActiveParameters) cmd.Parameters.Add(activeParameter); cmd.Connection = activeconnection; SqlDataAdapter sda = new SqlDataAdapter(cmd); resultDS = new DataSet(); sda.Fill(resultDS); return true; } else return false; } } catch { return false; } }
public SqlDataReader Action_ExecuteGetSPSForDR(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection) { if (activeEntry != null && ActiveConnection != null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get"); Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; SqlDataReader dr; if (activeSqlSPHelper.Action_ExecuteForDataReader(activeEntry, out dr)) return dr; else return null; } else return null; }
public static Dictionary<string, Data_SqlSPEntry> Action_AutoLoadingAllSPS(SqlConnection ActiveConnection, string SPType) { if (ActiveConnection != null) { Data_SqlDataHelper obj = new Data_SqlDataHelper(); obj.ActiveConnection = ActiveConnection; string sql_getallsps = "select * from sys.all_objects where (type = 'P') AND (is_ms_shipped = 0)"; DataTable activeSPSDT = new DataTable(); Dictionary<string, Data_SqlSPEntry> result = new Dictionary<string, Data_SqlSPEntry>(); if (obj.Action_ExecuteForDT(sql_getallsps, out activeSPSDT)) { foreach (DataRow activeRow in activeSPSDT.Rows) { Data_SqlSPEntry newSPEntry = new Data_SqlSPEntry(); string spName = ""; obj.Static_GetColumnData(activeRow, "name", out spName); if (SPType != "") { if (SPType == Data_SqlSPEntryType.SelectAction) { if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_SelectAction)) continue; } else if (SPType == Data_SqlSPEntryType.UpdateAction) { if (!spName.StartsWith(Data_SqlSPEntryNameFiler.StartNamed_Update)) continue; } } newSPEntry.SPName = spName; newSPEntry.KeyName = spName; string spObjectID = ""; obj.Static_GetColumnData(activeRow, "object_id", out spObjectID); string sql_paramters = "select * from sys.all_parameters where object_id = " + spObjectID; DataTable activeSPParametersDT = new DataTable(); string sql_paramstype = "select * from sys.types"; DataTable paramstypeDT = new DataTable(); if (!obj.Action_ExecuteForDT(sql_paramstype, out paramstypeDT)) { return null; } if (obj.Action_ExecuteForDT(sql_paramters, out activeSPParametersDT)) { foreach (DataRow activeParamterRow in activeSPParametersDT.Rows) { string activeSystemType_ID = ""; obj.Static_GetColumnData(activeParamterRow, "system_type_id", out activeSystemType_ID); string activeUserType_ID = ""; obj.Static_GetColumnData(activeParamterRow, "user_type_id", out activeUserType_ID); string activeParamsMaxLength = ""; obj.Static_GetColumnData(activeParamterRow, "max_length", out activeParamsMaxLength); string activeParamsName = ""; obj.Static_GetColumnData(activeParamterRow, "name", out activeParamsName); string activeIsOutPut = ""; obj.Static_GetColumnData(activeParamterRow, "is_output", out activeIsOutPut); string max_length = ""; obj.Static_GetColumnData(activeParamterRow, "max_length", out max_length); string activeDBType = ""; DataRow[] dbtyps = paramstypeDT.Select("system_type_id=" + activeSystemType_ID + " and user_type_id=" + activeUserType_ID); if (dbtyps.Length > 0) { obj.Static_GetColumnData(dbtyps[0], "name", out activeDBType); Data_SqlSPEntry.AddSPParameter(ref newSPEntry, activeParamsName, Data_SqlSPHelper.Static_GetDbTypeFromConfigStr(activeDBType), ParameterDirection.Input, int.Parse(max_length), null); } else continue; } } else { continue; } result.Add(newSPEntry.KeyName, newSPEntry); } } return result; } else return null; }
public bool Action_ExecuteUpdateSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary<string, object> ValueMaping) { Dictionary<string, int> SizeMaping=new Dictionary<string,int>(); return Action_ExecuteUpdateSPS(activeEntry, ActiveConnection, ValueMaping, SizeMaping); }
public DataTable Action_ExecuteGetSPSForDT(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection) { DataTable dt = new DataTable(); if (activeEntry != null && ActiveConnection!=null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "get"); Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; activeSqlSPHelper.Action_ExecuteForDT(activeEntry, out dt); return dt; } else return null; }
public object Clone() { Data_SqlSPEntry newEntry = new Data_SqlSPEntry(); newEntry.ActiveParameters = this.ActiveParameters; newEntry.EntryType = this.EntryType; newEntry.KeyName = this.KeyName; newEntry.SPName = this.SPName; newEntry.SPType = this.SPType; return newEntry; }
public static bool ModifySPParameter(ref Data_SqlSPEntry activeSPEntry, string Paramername, SqlDbType SPType, ParameterDirection SPDirection, object SPValue, int size = -1) { if (activeSPEntry == null) return false; else { SqlParameter activeParameter = null; foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters) { if (tmpParameter.ParameterName == Paramername) { activeParameter = tmpParameter; break; } } if (activeParameter != null) { activeParameter.Direction = SPDirection; activeParameter.SqlDbType = SPType; activeParameter.Value = SPValue; if (size != -1) activeParameter.Size = size; return true; } else return false; } }
public static void ModifyExcludeSPParameter(ref Data_SqlSPEntry activeSPEntry, Dictionary<string, object> parameterMaping, List<string> filterParameter) { List<SqlParameter> excluded = new List<SqlParameter>(); foreach (SqlParameter tmpParameter in activeSPEntry.ActiveParameters) { if (filterParameter.Contains(tmpParameter.ParameterName)) continue; if (parameterMaping.ContainsKey(tmpParameter.ParameterName)) continue; else { excluded.Add(tmpParameter); } } foreach (SqlParameter tmpExcludeParameter in excluded) { activeSPEntry.ActiveParameters.Remove(tmpExcludeParameter); } }
public bool Action_ExecuteUpdateSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary<string, object> ValueMaping, Dictionary<string, int> SizeMaping) { if (activeEntry != null && ActiveConnection!=null) { Data_SqlSPEntry.ModifySPParameter(ref activeEntry, "@operation", SqlDbType.NVarChar, ParameterDirection.Input, "update"); List<string> filterExclude = new List<string>(); filterExclude.Add("@operation"); Data_SqlSPEntry.ModifyExcludeSPParameter(ref activeEntry, ValueMaping, filterExclude); foreach (string activeParameter in ValueMaping.Keys) { int activeParametersIndex = Data_SqlSPEntry.GetSPParameterIndex(ref activeEntry, activeParameter); if (activeParametersIndex != -1) { SqlParameter activeExistedParamter = activeEntry.ActiveParameters[activeParametersIndex]; if (!SizeMaping.ContainsKey(activeParameter)) Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter]); else Data_SqlSPEntry.ModifySPParameter(ref activeEntry, activeParameter, activeExistedParamter.SqlDbType, activeExistedParamter.Direction, ValueMaping[activeParameter], SizeMaping[activeParameter]); } } Data_SqlDataHelper activeSqlSPHelper = new Data_SqlDataHelper(); activeSqlSPHelper.ActiveConnection = ActiveConnection; activeSqlSPHelper.Action_ExecuteForNonQuery(activeEntry); return true; } else return false; }
public bool Action_ExecuteDeleteSPS(Data_SqlSPEntry activeEntry, SqlConnection ActiveConnection, Dictionary <string, object> ValueMaping) { Dictionary <string, int> SizeMaping = new Dictionary <string, int>(); return(Action_ExecuteDeleteSPS(activeEntry, ActiveConnection, ValueMaping, SizeMaping)); }