private static StringBuilder GenerateSpHeader(StoredProcedureParmeters storedProcedureParmeters) { var queryHeader = new StringBuilder(); queryHeader.Append("CREATE PROCEDURE " + storedProcedureParmeters.StoredProcedureName); if (storedProcedureParmeters.IncludePrimaryKey) { IncludePk(queryHeader); } if (storedProcedureParmeters.IncludeAllParameters) { IncludeAllParameters(queryHeader); } if (storedProcedureParmeters.Parameters.Length > 0) { IncludeCustomParameters(storedProcedureParmeters, queryHeader); } queryHeader.Length--; queryHeader.Append(" AS "); return(queryHeader); }
private static void IncludeCustomParameters(StoredProcedureParmeters storedProcedureParmeters, StringBuilder queryHeader) { foreach (var parameter in storedProcedureParmeters.Parameters) { queryHeader.AppendFormat(" @{0} {1},", parameter, MapType(_tableInformation.Properties[parameter])); } }