internal static bool SqlDataTypeIsVarChar(this IProcedureParameter procedureParameter)
{
return(procedureParameter.SqlDataType == SqlDataType.VARCHAR);
}
public static string GetDotNetType(this IProcedureParameter procedureParameter)
{
return(SqlDataType.GetDotNetType(procedureParameter.SqlDataType, procedureParameter.IsNullable));
}
public static object GetDefaultValueForCallingProcedure(this IProcedureParameter procedureParameter)
{
if (procedureParameter.IsNullable)
{
return(null);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.VARCHAR, StringComparison.Ordinal))
{
return("''");
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.Int, StringComparison.Ordinal))
{
return(0);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.DateTime, StringComparison.Ordinal) ||
procedureParameter.SqlDataType.StartsWith(SqlDataType.Date, StringComparison.Ordinal))
{
return(DateTime.MinValue);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.SmallDateTime, StringComparison.Ordinal))
{
return(DateTime.Today.AddDays(-1).Date);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.SmallInt, StringComparison.Ordinal))
{
return((short)0);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.Bit, StringComparison.Ordinal))
{
return(false);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.BigInt, StringComparison.Ordinal))
{
return((long)0);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.Binary, StringComparison.Ordinal))
{
return(new byte[0]);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.Float, StringComparison.Ordinal))
{
return((float)0);
}
if (procedureParameter.SqlDataType.StartsWith(SqlDataType.Money, StringComparison.Ordinal) ||
procedureParameter.SqlDataType.StartsWith(SqlDataType.SmallMoney, StringComparison.Ordinal))
{
return((decimal)0);
}
throw new NotImplementedException("Not implemented yet." + procedureParameter.SqlDataType);
}
public ExecuteProcedure(IProcedureParameter spParameter)
{
this._spParameter = spParameter;
}
