VISUAL CONTROLS FOR STORED PROCEDURE AND OBJECT RELATIONAL CLASS DEVELOPMENT

• US 20080189311A1
• Filed: 02/01/2007
• Published: 08/07/2008
• Est. Priority Date: 02/01/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Hejlsberg, Anders, Cote, Antoine, Joo, Young Kun, Crawley, Andrew Joseph, Stanton, Richard Alexander, Delano, Lance Chadwick
• Application Number:
  US11/669,968
• Publication Number:
  US 20080189311A1
• Time in Patent Office: Days
• US Class Current: 707/101
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2443 Stored procedures

Abstract

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.

Claims

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.

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.

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.

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.