public StoredProcedureInfo CloneStoredProcedure(DatabaseInfo ownerDb = null) { var res = new StoredProcedureInfo(ownerDb ?? OwnerDatabase); res.Assign(this); return(res); }
public void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema) { var oldObj = _database.FindStoredProcedure(obj); if (oldObj != null) { oldObj.FullName = new NameWithSchema(newschema, oldObj.FullName.Name); } }
public void AlterStoredProcedure(StoredProcedureInfo obj) { var oldObj = _database.FindStoredProcedure(obj); if (oldObj != null) { string gid = oldObj.GroupId; oldObj.Assign(obj); oldObj.GroupId = gid; } }
public StoredProcedureInfo FindStoredProcedure(StoredProcedureInfo obj) { return(FindStoredProcedure(obj.FullName)); }
public StoredProcedureInfo CloneStoredProcedure(DatabaseInfo ownerDb = null) { var res = new StoredProcedureInfo(ownerDb ?? OwnerDatabase); res.Assign(this); return res; }
public override void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema) { ChangeObjectSchema(obj, newschema); }
public override void RenameStoredProcedure(StoredProcedureInfo obj, string newname) { RenameObject(obj, newname); }
public virtual void RenameStoredProcedure(StoredProcedureInfo obj, string newname) { throw new System.NotImplementedException(); }
public virtual void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema) { throw new System.NotImplementedException(); }
public virtual void AlterStoredProcedure(StoredProcedureInfo obj) { WriteRaw(Regex.Replace(obj.CreateSql, @"create\s+procedure", "ALTER PROCEDURE", RegexOptions.IgnoreCase)); EndCommand(); }
public virtual void DropStoredProcedure(StoredProcedureInfo obj, bool testIfExists) { PutCmd("^drop ^procedure %f", obj.FullName); }
public virtual void CreateStoredProcedure(StoredProcedureInfo obj) { WriteRaw(obj.CreateSql); EndCommand(); }
public void RenameStoredProcedure(StoredProcedureInfo obj, string newname) { var oldObj = _database.FindStoredProcedure(obj); if (oldObj != null) { oldObj.FullName = new NameWithSchema(oldObj.FullName.Schema, newname); } }
public void DropStoredProcedure(StoredProcedureInfo obj, bool testIfExists) { _database.StoredProcedures.RemoveAll(v => v.FullName == obj.FullName); }
public void CreateStoredProcedure(StoredProcedureInfo obj) { _database.StoredProcedures.Add(obj.CloneStoredProcedure(_database)); }