VISUAL CONTROLS FOR STORED PROCEDURE AND OBJECT RELATIONAL CLASS DEVELOPMENT
A development system is provided. The system includes a workspace component to visually display one or more stored procedures and one or more class components. A manipulation component locates the stored procedures onto the class components in order to automatically create methods for the class components.
1 . A development system, comprising:
a workspace component to visually display one or more stored procedures and one or more class components; and
a manipulation component to locate the stored procedures onto the class components in order to automatically create methods for the class components.
2 . The system of claim 1 , the workspace component visually associates one or more stored procedures with an object/relational (O/R) class.
3 . The system of claim 3 , further comprising one or more return values that are employed to differentiate which stored procedure to associate with the O/R class.
4 . The system of claim 1 , the workspace component determines one or more actions by analyzing the stored procedures.
5 . The system of claim 4 , the actions are based in part by the shape of a return value.
6 . The system of claim 4 , the actions are based in part by a class drop target.
7 . The system of claim 6 , the class drop target is an existing O/R class or a methods pane associated with a workspace component.
8 . The system of claim 7 , where the drop target is the existing O/R class and a stored procedure returns a scalar value or a result set that has a similar shape or a shape that is a superset or a subset of target O/R class properties, a relationship is created between a method that wraps the stored procedure and a target class.
9 . The system of claim 7 , where the drop target is the methods pane, a region in a workspace component that has been reserved for O/R methods, or a background surface of the workspace component, a method component that wraps a stored procedure is added to an O/R methods list under a data context designation.
10 . The system of claim 1 , further comprising a properties component that is selected via the manipulation component.
11 . The system of claim 10 , the properties component is associated with a data context, a connection object, or a visual property.
12 . The system of claim 1 , the workspace component is associated with a methods pane, an object locator, or an object connection component.
13 . The system of claim 12 , the workspace component is associated with one or more tables, one or more object views, or one or more table valued functions.
14 . The system of claim 12 , the workspace component associates the stored procedures with a data context component.
15 . The system of claim 12 , the object connection component is associated with a visual connection object between object shapes.
16 . A method for creating object/relational structures, comprising:
defining one or more class components on a visual workspace;
selecting one or more stored procedures for the visual workspace; and
moving the stored procedures in vicinity of the class components to automatically create methods for the class components.
17 . The method of claim 16 , further comprising defining an area threshold to determine the vicinity of the class components.
18 . The method of claim 16 , further comprising generating a wrapper for the stored procedures.
19 . The method of claim 16 , creating mappings between the class components and the stored procedures.
20 . A system to create object/relational mappings, comprising:
means for creating one or more class components;
means for selecting one or more stored procedures; and
means for creating a mapping between the class components and the stored procedure when the stored procedures are visually associated with the class components.