CYQ. Data layer framework V4.5.5 released

Preface:Following the previous version: CYQ. the Data framework version V4.5 has been released for more than three months. For more information, see CYQ. data V4.5 has been released for more than half a year. Today, we have to release a new minor version. Because the previous version was too stable, this version had no bug fixes, but added several important performance optimization functions.New features of the current version are previewed. 1: optimized Access and SQLite database links, with {0} representing the root directoryBenefit: You can configure multiple database links. For example, you have used N access databases at the same time in QBlog of the autumn color garden.2: MAction adds the query function of the specified column: SetSelectColumnsBenefit: You can specify a column name during query to reduce the transmission volume.3:Added the AppDebug class to output SQL statements that have been executed globally.Benefits: You can control and print Page SQL statements at any time, and analyze and optimize SQL statements directly.4: added the FastToT Emit class to Improve the Performance of migrating data from MDataTable to List <T> when the data volume is large.Benefits: Emit can be used to speed up and improve performance when the returned data volume is large to convert objects.5: Disable mssql/oracle transaction enabling by defaultBenefit: the transaction is opened as needed, but is not opened by default.To be compatible with transactions of V4.5 and earlier versions, use the configuration items:<Add key = "TransationDefaultOpen" value = "true"> </add>
6:XmlHelper is renamed as XHtmlAction Others:Added configuration items:OpenDebugInfo: true/false: whether to enable the SQL statement record debugging. It is enabled during development and can be disabled during runtime.RecordSqlLongQueryTime: N in milliseconds). It is set during runtime to record SQL statements that have been executed for a long time and can be analyzed and optimized in a targeted manner.AppDebugFilterTime: N in milliseconds). AppDebug can output Page SQL statements, which can be used to filter. The following is a detailed explanation. 1: optimized Access and SQLite database links, with {0} representing the root directoryExample:<ConnectionStrings>
<Add name = "Conn" connectionString = "Data Source = {0} App_Data \ qblog. db; failifmissing = false" providerName = "System. Data. SQLite"/>
</ConnectionStrings> 2: MAction adds the query function of the specified column: SetSelectColumnsExample: [include: Query, paging, binding]Protected void BindData ()
{
Int count;
Using (MAction action = new MAction (TableNames. Blog_Class ))
{
Action. SetSelectColumns (selectColumns); // specifies the column
Action. Select (Pager1.PageIndex, Pager1.PageSize, string. Empty, out count). Bind (gvClass );
Pager1.Count = count;
Pager1.BindName = "BindData ";
}
}3: added the AppDebug class to globally output executed SQL statements.Example: [in the page base class, you can easily process it]Public class PageBase: System. Web. UI. Page
{
Protected override void OnInit (EventArgs e)
{
AppDebug. Start (); // enable the SQL statement on the record page
Base. OnInit (e );
}
Protected override void OnPreRenderComplete (EventArgs e)
{
Base. OnPreRenderComplete (e );
Response. Write (AppDebug. Info); // The SQL statement of the output record page
AppDebug. Stop (); // Stop the SQL statement on the record page
}
}Page effect:650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/1T04I121-0.jpg "align =" absMiddle "border =" 0 "/> Other examples are written as example projects: Example solution:650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/1T04K540-1.jpg "align =" absMiddle "border =" 0 "/>Complete Example page:650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/1T04L639-2.jpg "align =" absMiddle "border =" 0 "/> Finally:CYQ. Data framework home: http://www.cyqdata.com/cyqdata CYQ. Data framework download includes examples): http://www.cyqdata.com/download/article-detail-426 

This article from the "passing by autumn" blog, please be sure to keep this source http://cyq1162.blog.51cto.com/2127378/637690