[Framework Name] MINDSWARE DATAOBJECTS & DYNAMICDATASHEETS FRMEWORK
To download all source code and examples here: http://www.cnb4c.com/mindsware_dynamicdataObjects_v0.1.rar
[Version number] V0.1
[Platform] Microsoft.Net 1.1
[Function Description] 1, as the name suggests: This framework mainly completes two functions: (1) Implement Object to Database Mapping, developers no longer need to write complex INSERT, UPDATE and DELETE, and to Oracle, SQL Server, and various OLEDBs Data source supports transparent access. Among them, Oracle and SQL Server access via Native Provider mode, not through OLEDB, maximum improvement performance. (2) Dynamic maintenance of relational data sheets, including new, modified, deleted, queries, and display the functionality of flipping. A relational table adds / deletes fields, modifying performance, can be easily implemented (several lines of code).
The framework below the J2EE platform, but the .NET platform is not numbered, I hope this Framework has contributed to the popularity of .NET, and I also learn .NET's programming, Model Support provides an example. Welcome volunteers to join my ranks together, and enrich this Framework.
2, Flexibility and Plug-in Ability are very strong, can apply any .NET project, just need to use the reference mindsware in the project, where DbObject, MultidBobject, DBConnection uses it, provides INSERT, UPDATE, DELETE , RetreiveList, Country, etc., is a very rich data manipulation method. It is limited to the space and time, and these methods are demonstrated in the example.
3. To achieve new, modify, delete, query, display list, turn, order, sorting operations for many database tables, you need about 4 to 5 pages files (still not on the ASP / JSP) It is very troublesome, and this basic data maintained work is required for at least two or three months. And updated, maintenance is definitely a nightmare. This framework uses an ASPX page to complete the new, modified, delete, query, list, turn page, sorting operation (unfinished), all operations in public controls, all operations, just a housing, this page is just a housing. Various controls can be discharged according to actual needs, set the display style, and the various page operation functions. The code to be written for each table developer is only 10 ~ 30 lines. There are three pages in the example that demonstrates how to complete data maintenance of the two database tables.
4. Use a user-defined class to complete the schema definition of a database table, inherit a DBObject or MultidBobject class (this name is similar to an open source project Expresso, the function is similar), as long as the Schema is defined, it is manual setting When each Column name, the data type, whether the primary key can be empty, whether to refer to the primary key of other tables, display type (display as TextBox, Textarea, DropdownList, Radiolist, or something else), etc. Then automatically use the base class that has already defined a list of RetreiveList, count, and the method of processing the query, and the method of modifying the data, INSERT, Delete Don't write SQL statements, don't bind parameters, everything is automatically completed. 5, there is a class of special render tables to generate various forms, such as new data forms, modify data forms, etc., and query forms, etc. The format can be derived from the definition through a style list, which will determine what control is displayed according to the setting of the Data Column, such as a column that refers to the other table primary key, which displays a DROPDOWNLIST, which shows the description of the key value of the reference table, and actual value It is a key value, which is the most basic operation. It is also possible to dynamically add Validator if it is allowed to be empty, whether it is a number, whether it is a password, and is submitted to the Validation on the page, such as the password requires two times, and the two-edged input should be consistent, listed as numbers This box can only be a number, etc. In the query form, if you are listed as a number or date, two boxes and termination values are automatically given, and the date control is displayed if it is the date.
[Document Description] 1, under the MINDSWARE directory below is the core Project and all source code! !
2, Sample_Web_Project Directory Here is an example Web Project
3, SQL_Scripts_for_sample directory below is the database built-in statement required by the example, including Oracle and MS SQL, and an Access sample database that is built.
4, you need to download Oracle Client and Oracle Data Provider for .NET (ODP.NET), installed on the developer and web server (probably the same machine) can only connect to the Oracle database similar to system.data.sqlclient. The corresponding Assembly is Oracle.DataAccess.
By wesley@smth2003.12
Welcome to communicate on the forum, or send email, please do not send a mailbox in the SMTH station, it is too easy to super. Email: wesley@263.netqq: 18990702msn: wesley_wu@hotmail.comWebsite: http://www.cnb4c.com/bbs/list.asp?boardid=32
