Design on Data Manipulation Class Based on ADO.NET
Yong Chang Ren, Tao Xing, Zhao Feng Xing, Wei Ling Cai · Applied Mechanics and Materials · 2011
Programmers manual compiling SQL statements according to relevant software development of database existing some troubles like workload big, easy to make a mistake, difficult to maintenance, this piece research designing on data manipulation class based on ADO.NET, realize the database operation through the data manipulation class. Based on expounding ADO.NET architecture and ADO.NET object model, concentrate on the researching two things: one is automatic generation of SQL statements, designing operation function, function Arguments or global arrays, deciding which type of SQL statements to generate, the other one is designing on data manipulation class, through re-loading, packaging and inheriting to design in data manipulation class for database. Results show that the research and application of data manipulation class solved a number of problems of traditional software development; it has important meaning for improve quality and efficiency of software development, it has become an important research direction of Database software development area.