public MySmo.StoredProcedure GetStoredProcedure(Smo.StoredProcedure smo_sp, MySmo.Database parent = null) { #region implement SetDataLimit(); var mysmo_sp = new MySmo.StoredProcedure(); mysmo_sp.ParentDatabase = parent; mysmo_sp.Name = smo_sp.Name; mysmo_sp.Schema = smo_sp.Schema; mysmo_sp.CreateTime = smo_sp.CreateDate; mysmo_sp.Owner = smo_sp.Owner; mysmo_sp.ExtendedProperties = GetExtendProperties(mysmo_sp, smo_sp.ExtendedProperties); var s = ""; if (mysmo_sp.ExtendedProperties.TryGetValue(K_MS_Description, out s)) { mysmo_sp.Description = s; mysmo_sp.ExtendedProperties.Remove(K_MS_Description); } mysmo_sp.Parameters = new List <MySmo.Parameter>(); foreach (Smo.StoredProcedureParameter smo_p in smo_sp.Parameters) { var mysmo_p = new MySmo.Parameter { ParentDatabase = parent, ParentParameterBase = mysmo_sp, Name = smo_p.Name.Substring(1), DefaultValue = smo_p.DefaultValue, IsOutputParameter = smo_p.IsOutputParameter, IsReadOnly = smo_p.IsReadOnly, DataType = new MySmo.DataType { Name = smo_p.DataType.Name, Schema = smo_p.DataType.Schema, MaximumLength = smo_p.DataType.MaximumLength, NumericPrecision = smo_p.DataType.NumericPrecision, NumericScale = smo_p.DataType.NumericScale, SqlDataType = (MySmo.SqlDataType)(int) smo_p.DataType.SqlDataType } }; mysmo_sp.Parameters.Add(mysmo_p); } FormatExtendProperties(mysmo_sp); return(mysmo_sp); #endregion }
public void FormatExtendProperties(MySmo.StoredProcedure mysmo_sp) { CombineExtendProperties(mysmo_sp.ExtendedProperties); DistributeExtendProperties((MySmo.IParameterBase)mysmo_sp); }