public static DataAccessLayer.DBCommand Add(this DataAccessLayer.DBCommand sql,
DataAccessLayer.DBCommand dbCommand, string paramName, string outputParamName,
System.Data.ParameterDirection direction = System.Data.ParameterDirection.Input)
{
sql.AddParameter(dbCommand, paramName, outputParamName, direction);
return(sql);
}
public static DataAccessLayer.DBCommand Add(this DataAccessLayer.DBCommand sql, string paramName,
System.Data.ParameterDirection direction, System.Data.DbType type, object objValue = null)
{
sql.AddParameter(paramName, direction, type, objValue);
return(sql);
}
/// <summary>
/// Allow for dasiy chain adding parameters and execute in one statement on DbCommand class
/// </summary>
/// <param name="sql">self reference</param>
/// <param name="paramName">SQL Parameter to add</param>
/// <param name="objValue">SQL Value to add</param>
/// <returns>Return back the same DbCommand object to chain up more function call</returns>
public static DataAccessLayer.DBCommand Add(this DataAccessLayer.DBCommand sql, string paramName, object objValue)
{
sql.AddParameter(paramName, objValue);
return(sql);
}
