This open source code, let's say something short: 1: this opening ceremonyCYQ. DataData framework V3.0, includingQBlogPowerful XmlHelper source code, and related updates are recorded at the bottom.2:CYQ. Blog(Autumn GardenQBlog) Re-open the free download, plusCYQ. DataComponent source code, which is fully open to all source code in QBlog V1.0 of the autumn garden.3:CYQ. Blog(Autumn GardenQBlogBasically, it is free for individual users, and the most powerful weapon in the universe is used for enterprises, "saving your life by 3000 ".4:CYQ. DataThe data framework also provides free commercial authorization for individual users. For details, see the source code. Download:CYQ. Data framework V3.0 source code: http://www.cyqdata.com/download/article-detail-426CYQ.Blog open source blog V1.0 source code: http://www.cyqdata.com/download/article-detail-427The following are historical modification and update records:V1.3 started
Records from:
1: MAction: automatically calls Close () When Update/Insert/Fill fails ()
2: MAction: added the ResetTable function.
3: MAction: Modify the Fill method: if there are multiple records, return failure. Change to return the first record.
4: OutPutData: Add ExeCreateProc to directly execute the paging storage process. Records from:
1: MAction: returned result of closed DataSQLHelper
2: MAction: added SetAutoPrefix. Multiple Control prefixes can be uploaded.
3: MAction: The Insert/Update method enables Auto to obtain values.
4: MProce: New Production Class used to execute the Stored Procedure
5: OutPutData: new export of Stored Procedure EnumerationV1.4 started
Records from:
1: MProc: Modify the ExeScalar Method to the generic method public T ExeScalar <T> ()
2: SQLString: The where condition filters out the "--" comment and ";" Semicolon records from:
1: SQLHelper, DataType, and Log modify the access modifier, which is not open to the outside world.
2: MProc: the modification of access modification by SQLHelper is not open to the outside world, and the inheritance is changed to the built-in class.
3: MProc: Change the returned DataTable to MDataTable to hide the returned SqlDataReader.
4: MDataTable: added the ToDataTable function to record from:
1: DataType: the conversion methods for merging data types are GetDbType and GetSqlType, and other additional methods are commented out.
2: Log: Modify the return type of WriteLog to void. An exception is thrown when an exception Log fails to be written to the database.
3: SQLHelper: optimize code and delete useless Methods
4: MAction: adds intelligent detection. The constructor does not need to input database configuration items. For multi-database applications, the rule enumeration is [[U/V/P] _ + database name + Enum], and the configuration file database link configuration item is [database name + Conn].
5: CacheHelper: optimizes the code and reduces the number of lines of code.
6: OutPutData: added the export of multi-database projects, and modified the enumeration export of tables and views to [[U/V/P] _ database name + Enum] format.
7: SQLHelper: added transaction support
8: MAction: by default, transaction support is enabled for all operations until the transaction ends when Close () or EndTransation () is called or an exception occurs. Records from:
1: CacheHelper: modified several function names.
2: MProc: modify several method names and automatically add the "@" prefix to the parameters.
3: OutPutData: added export of stored procedure parameters
4: added all comments and example generated documents from:
1: OutPutData: added the log table generation method.V1.5 startedRecords from:
1: MDataTable: optimizes data binding, improving the speed.
2: SQLOutPut: corrected the generation of enumeration and log tables in the SQL 2000 database.
3: The DataType: GetSqlType method adds the ntext type conversion. The default value of the modification conversion is SqlDbType. NVarChar, which is recorded from 2010-09-04:
4: added support for Guid-type IDs.
5: MProc added support for SQL statements
6: OutPutData: optimized the code and deleted useless functions from:
7: MDataTable: corrected the ToDataTable method and recorded it from 2010-09-06:
8: MAction: added support for GetFrom and SetTo in Winform
9: MActionUI: new classes are separated from MAction. Records from 2010-09-07:
Records from 2010-09-08:
10: MDataTable: supports binding the Winform DataGridView control.PS: V1.5.5, which includes some functions for modifying SQL2000 in V2.0.
V2.0 is a large version that supports multiple databases.
Records from 2010-09-09:
1: added support for Access databases.
Records from:
2: SQLString: FormatWhere is not formatted to lowercase
3: Maction: optimizes the code for accessing database operations
4: OutPutData: re-adjust the internal code, add Access support, and remove the output enumeration description.
5: The auxiliary tool V1.6 was born to support the generation of Access enumeration.
Records from:
6: DbBase: the return value of a stored procedure cannot be a name index or a digital index.
7: MDataColumn: add and delete columns.
8: MDataTable: Modify the constructor
Records from:
9: OutPutData database 2000 output shielding system's built-in [Table/View/Stored Procedure] records from:
10: Add parameters for SQL2000 parameter execution.
11: SQL2000 paging Stored Procedure correction.
12: corrected the use of transactions in SQL2000.
Records from:
13: added Aop to separate permissions, operation logs, exceptions, and other independent processes.
Records from:
14: MDataTable fixed index unreset errors when multiple bindings
Records from:
15: The Dynamic Loading Function is added to Aop. The configuration file is required: <add key = "Aop" value = "assembly name, namespace. Aop class name"/>
Records from 2010-09-27:
16: added support for Oracle, and added and deleted updates.
Records from:
17: Compile the paging stored procedure and call it. You can also use the enumeration export function to create a log table. Records from:
18: Create a log table.
19: auxiliary tools are implemented. Records from:
20: Bind method added to MDataTable
21: added ToJson output for MDataTable
22: added the JsonHelper class from:
1: add the Bind method to MAction.
2: corrected the MAction Debug attribute [Close is automatically called upon failure, and DbBase error information cannot be obtained for the attribute]
3: added the IDisponse interface implementation for MProc.
Records from:
4: MAction: Aop modifies Fill to return the id value
Records from:
5: MProc ResetProc re-determine whether the stored procedure is storedV3.0 startsRecords from:
1: add the Bind method to MAction.
2: corrected the MAction Debug attribute [Close is automatically called upon failure, and DbBase error information cannot be obtained for the attribute]
3: added the IDisponse interface implementation for MProc.
Records from:
4: MAction: Aop modified Fill and the returned id value is recorded from:
Added Xml-related operation classes:
XmlBase
XmlHelper
XhtmlurlResolver
MutilLanguage
HtmlTagType is recorded from:
1: MAction: Add _ DataSqlHelper. ClearParameters () for Insert/Update/Delete/Fill/GetCount ();
2: added an Orm base class.
3: added the ToList <T> generic method to the MDataTable.
4: DbBase adds the transaction shutdown Mechanism
5: OrmBase does not enable transactions by default.
Records from:
6: MAction: when the transaction is closed, the default operation fails and the link is not automatically closed. Records are recorded from:
6: MAction: fixed the error caused by ResetTable/Fill not rewriting the table name, which was recorded from 2010-10-20-> 2010-10-29:
1: AppConfig is added to facilitate viewing all configuration file items [except for the default database connection Conn]
2: added [# true] and [# false] Replace in FormatWhere, supporting multi-database applications.
3: Modify the Return Statement of the table structure and process the uniqueidentifier, ntext, and text types.
4: Access type operation. transactions are disabled by default.
5: Access Data Type DateTime type parameters are processed as Date type.
6. DalAction format the Access database link.
7: Add method of cache class adds cache dependent file path and time input.
8: add custom tags for the cache class [whether the cache is modified or not]
9: added processing for the Image type.
10: An error occurred while querying the table name of the Access custom statement.
OK, finally, all the people passing by, the soy sauce should be played, and the float should be floated over, and the Post should be quickly reserved, so we should study hard.
This article from the "passing by autumn" blog, please be sure to keep this source http://cyq1162.blog.51cto.com/2127378/597084