Development environment configured to generate application source code from database objects

Abstract

Development tools are disclosed that connect various artifacts in a database aware fashion. For example, the development environment may integrate SQL query builders across multiple application development interfaces (e.g., a source code editor, XML editor, database scripting tools, etc.), significantly improving developer productivity, reducing development cost and time. Thus, the process of consuming heterogeneous artifacts in an application (or creating them for consumption) becomes a very productive experience, eliminating the need to manually cut/paste information in multiple project files in many cases.

1 . A computer-implemented method for an integrated development environment (IDE) tool to manage database aware application development, the method comprising:
 executing the IDE tool on a computing system having at least a processor, a memory, and a storage device, wherein the IDE tool is configured to perform an operation, comprising:
 presenting within an interface of the IDE tool, a display of the database data model, 
 receiving a selection of a database object of the database data model, 
 generating application source code configured to access the selected database object, and 
 storing an indication of the relationship between the database object and the application source code. 
   
     
     
         2 . The method of  claim 1 , wherein the operation further comprises, prior to generating the application source code, receiving one or more parameters characterizing the application source code to be generated to access the database object. 
     
     
         3 . The method of  claim 1 , wherein generating application source code comprises generating a stored procedure. 
     
     
         4 . The method of  claim 3 , further comprising, deploying the stored procedure to a database engine. 
     
     
         5 . The method of  claim 1 , wherein the operation further comprises:
 receiving a request to access the application source code;   presenting the application source code on an editing pane of the IDE tool; and   in response to determining that one or more modifications have been made to the application source code, updating the selected database object to conform to the modifications made to the application source code.   
     
     
         6 . The method of  claim 1 , wherein the operation further comprises:
 receiving a request to access the selected database object;   presenting the database object on a design canvas of the IDE tool; and   in response to determining that one or more modifications have been made to the database object:
 regenerating the application source code to conform to the modifications made to the database object. 
   
     
     
         7 . The method of  claim 1 , wherein the database object comprises a database query. 
     
     
         8 . The method of  claim 7 , wherein generating the application source code comprises generating a relational-to-object interface for the database query. 
     
     
         9 . A computer-readable storage medium containing an integrated development environment (IDE) tool, which when executed on a processor, performs an operation to manage database aware application development, the operation comprising:
 presenting within an interface of the IDE tool, a display of the database data model,   receiving a selection of a database object of the database data model,   generating application source code configured to access the selected database object, and   storing an indication of the relationship between the database object and the application source code.   
     
     
         10 . The computer-readable storage medium of  claim 9 , further comprising, prior to generating the application source code, receiving one or more parameters characterizing the application source code to be generated to access the database object. 
     
     
         11 . The computer-readable storage medium of  claim 9 , wherein generating application source code comprises generating a stored procedure. 
     
     
         12 . The computer-readable storage medium of  claim 11 , wherein the operation further comprises, deploying the stored procedure to a database engine. 
     
     
         13 . The computer-readable storage medium of  claim 9 , wherein the operation further comprises:
 receiving a request to access the application source code;   presenting the application source code on an editing pane of the IDE tool; and   in response to determining that one or more modifications have been made to the application source code, updating the selected database object to conform to the modifications made to the application source code.   
     
     
         14 . The computer-readable storage medium of  claim 9 , wherein the operation further comprises:
 receiving a request to access the selected database object;   presenting the database object on a design canvas of the IDE tool; and   in response to determining that one or more modifications have been made to the database object:
 regenerating the application source code to conform to the modifications made to the database object. 
   
     
     
         15 . A system, comprising:
 a processor; and   a memory containing an integrated development environment (IDE) tool, which when executed on a processor, performs an operation to manage database aware application development, the operation comprising
 presenting within an interface of the IDE tool, a display of the database data model, 
 receiving a selection of a database object of the database data model, 
 generating application source code configured to access the selected database object, and 
 storing an indication of the relationship between the database object and the application source code. 
   
     
     
         16 . The system of  claim 15 , further comprising, prior to generating the application source code, receiving one or more parameters characterizing the application source code to be generated to access the database object. 
     
     
         17 . The system of  claim 15 , wherein generating application source code comprises generating a stored procedure. 
     
     
         18 . The system of  claim 17 , wherein the operation further comprises, deploying the stored procedure to a database engine. 
     
     
         19 . The system of  claim 15 , wherein the operation further comprises:
 receiving a request to access the application source code;   presenting the application source code on an editing pane of the IDE tool; and   in response to determining that one or more modifications have been made to the application source code, updating the selected database object to conform to the modifications made to the application source code.   
     
     
         20 . The system of  claim 15 , wherein the operation further comprises:
 receiving a request to access the selected database object;   presenting the database object on a design canvas of the IDE tool; and   in response to determining that one or more modifications have been made to the database object:
 regenerating the application source code to conform to the modifications made to the database object.