/// <summary>
/// Adds a new stored procedure to the table with specified name and text.
/// </summary>
/// <param name="name">
/// The name of the stored procedure to add.
/// </param>
/// <param name="text">
/// The text of the stored procedure to add.
/// The text must contain a valid SQL stored procedure creation statement.
/// </param>
/// <returns>
/// If the operation succeeded, the return value is the stored procedure created.
/// </returns>
/// <remarks>
/// The name in the Text parameter must match the Name parameter.
/// </remarks>
public SqlStoredProcedure Add(string name, string text)
{
if (name == null || name.Length == 0)
{
throw new ArgumentException(SR.GetString("SqlStoredProcedureCollection_MustHaveValidName"));
}
if (this[name] != null)
{
throw new ArgumentException(String.Format(SR.GetString("SqlStoredProcedureCollection_NameAlreadyExists"), name));
}
// Physically add database
NativeMethods.IStoredProcedure dmoStoredProcedure = (NativeMethods.IStoredProcedure) new NativeMethods.StoredProcedure();
dmoStoredProcedure.SetName(name);
dmoStoredProcedure.SetText(text);
database.dmoDatabase.GetStoredProcedures().Add(dmoStoredProcedure);
SqlStoredProcedure sproc = new SqlStoredProcedure(dmoStoredProcedure.GetName(), dmoStoredProcedure.GetOwner(), dmoStoredProcedure.GetSystemObject() ? SqlObjectType.System : SqlObjectType.User, DateTime.Parse(dmoStoredProcedure.GetCreateDate()));
// Set internal properties
sproc.dmoStoredProcedure = dmoStoredProcedure;
sproc.database = this.database;
// Add to private list
storedProcedures.Add(sproc);
return(sproc);
}
