public void MakeParams()
{
if (_params == null)
{
ISProcedure SP_Parameter = SProcedureFactory.GetInstance(ServerKey);
SP_Parameter.SetConnectionString(ConnectionString);
IEnumerable <ParameterMetadata> PMetadata = SP_Parameter.GetParameterMetadata(SpName);
_params = new Dictionary <string, SpParameter>();
foreach (var item in PMetadata)
{
//removeing @ from the ParameterName
string ParaName = item.Name.Substring(1);
var P_DTOParam = DataHelper.ParameterFromDTO(ParamDTO);
if (P_DTOParam.ContainsKey(ParaName))
{
var Param_Meta = P_DTOParam[ParaName];
Param_Meta.IsOutParam = item.IsOut(ServerKey);
_params.Add(ParaName, Param_Meta);
}
else
{
throw new Exception(ParamDTO.GetType().Name + "Not Containg Parameter of " + ParaName + ", of Procedure " + SpName + ".");
}
}
}
}
public static ISProcedure GetInstance(string DBKey)
{
ISProcedure result = null;
if (DB.SQLSERVER.Equals(DBKey, StringComparison.OrdinalIgnoreCase))
{
result = new SqlServerSProcedure();
}
else
{
throw new Exception("Not Implemented for :" + DBKey);
}
return(result);
}
