/// <summary> /// Add text to stored procedure /// </summary> /// <param name="text">Text to add</param> private void AddToStoredProcedure(MsSqlDbObjectText text) { MsSqlStoredProcedureSchema sp = _storedProcedures.SingleOrDefault(p => p.SchemaName == text.SchemaName && p.ObjectName == text.ObjectName); if (sp == null) { sp = new MsSqlStoredProcedureSchema(text.SchemaName, text.ObjectName); _storedProcedures.Add(sp); } sp.AddText(text); }
/// <summary> /// Add parameter to stored procedure /// </summary> /// <param name="prms">Parameter to add</param> private void AddToStoredProcedure(MsSqlDbObjectParam prms) { MsSqlStoredProcedureSchema sp = _storedProcedures.SingleOrDefault(p => p.SchemaName == prms.SchemaName && p.ObjectName == prms.ObjectName); if (sp == null) { sp = new MsSqlStoredProcedureSchema(prms.SchemaName, prms.ObjectName); _storedProcedures.Add(sp); } sp.AddParam(prms); }