Design and Implementation of ASP.NET Database Application Generator with Entity-Relationship Model

• Main Authors: Jiun-Ming Juang, 莊浚銘
• Other Authors: 劉長遠
• Format: Others
• Language: zh-TW
• Published: 2010
• Online Access: http://ndltd.ncl.edu.tw/handle/83234569371472522139

碩士 === 臺灣大學 === 資訊工程學研究所 === 98 === Entity-Relationship model and Microsoft® ASP.NET technology are frequently used in developing web relational database applications. Without using any commercial Computer-Aided Software Engineering（CASE）tools, however, programmers tend to develop ASP.NET applications in a traditional way. That is, draw an E-R model on paper at first, and then use that model to manually create the desired database and tables, and finally start to develop programs manipulating data in the built database. This process appears to be time-consuming and involves a lot of manual works. In this study, we use Visual C#®, as a programming language, to develop an E-R model designer and an ASP.NET database application generator. The designer, as a simple CASE tool, provides users a visual interface for designing an E-R model. More importantly, it enables users to customize and generate the pre-defined XML parameters required in the ASP.NET database application generator. And the application generator, in turn, takes the XML parameters to generate the specified relational database and ASP.NET programs. By applying the designer and the generator with built-in functionalities of Role-Based Access Control（RBAC）, developers can quickly get a handy web database application for further usage.