/// <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); }
/// <summary> /// Add parameter to table /// </summary> /// <param name="prms">Parameter to add</param> private void AddToTable(MsSqlDbObjectParam prms) { MsSqlTableSchema table = _tables.SingleOrDefault(t => t.SchemaName == prms.SchemaName && t.ObjectName == prms.ObjectName); if (table == null) { table = new MsSqlTableSchema(prms.SchemaName, prms.ObjectName); _tables.Add(table); } table.AddParam(prms); }
/// <summary> /// Add column paameter to this table /// </summary> /// <param name="param">Column parameter</param> public void AddParam(MsSqlDbObjectParam param) { _prms.Add(param); }