C# (CSharp) ProcedureAlterSchema Examples

Example #1

        private void OnAlterProcedureThreaded(object state)
        {
            ProcedureNode        node           = CurrentNode.DataItem as ProcedureNode;
            IDbFactory           fac            = node.ConnectionContext.DbFactory;
            IEditSchemaProvider  schemaProvider = (IEditSchemaProvider)node.ConnectionContext.SchemaProvider;
            ProcedureAlterSchema alterSchema    = new ProcedureAlterSchema(node.Procedure, (ProcedureSchema)((ProcedureSchema)state).Clone());

            schemaProvider.AlterProcedure(alterSchema);
            OnRefreshParent();
        }

Example #2

File: SqlServerSchemaProvider.cs Project: yayanyang/monodevelop

 //http://msdn2.microsoft.com/en-us/library/aa225939(SQL.80).aspx
 public override void AlterProcedure(ProcedureAlterSchema procedure)
 {
     ExecuteNonQuery(procedure.NewSchema.Definition);
 }

Example #3

File: MySqlSchemaProvider.cs Project: transformersprimeabcxyz/monodevelop-1

		//http://dev.mysql.com/doc/refman/5.1/en/alter-procedure.html
		public override void AlterProcedure (ProcedureAlterSchema procedure)
		{
			ExecuteNonQuery (procedure.NewSchema.Definition);
		}

Example #4

File: ProcedureNodeBuilder.cs Project: Kalnor/monodevelop

		private void OnAlterProcedureThreaded (object state)
		{
			ProcedureNode node = CurrentNode.DataItem as ProcedureNode;
			IDbFactory fac = node.ConnectionContext.DbFactory;
			IEditSchemaProvider schemaProvider = (IEditSchemaProvider)node.ConnectionContext.SchemaProvider;
			ProcedureAlterSchema alterSchema = new ProcedureAlterSchema (node.Procedure, (ProcedureSchema)((ProcedureSchema)state).Clone ());
			schemaProvider.AlterProcedure (alterSchema);
			OnRefreshParent ();
		}

Example #5

File: AbstractEditSchemaProvider.cs Project: FreeBSD-DotNet/monodevelop

		public virtual void AlterProcedure (ProcedureAlterSchema procedure)
		{
			throw new NotImplementedException ();
		}