Mysoft. Data v2.7.3 stable is released. Some features are added and known bugs are fixed.

This version simplifies some common operations and does not use interfaces for data return. It enhances the functions of sourcelist and sourcetable.

I would like to thank the netizens for providing good suggestions and helping me fix a lot of bugs and improve functions.

Nickname: Berin-230760 QQ: 100538511

Nickname: Melody QQ: 377526853

Nickname: uxspy QQ: 13970711

Nickname: Wang Hao QQ: 24097543

Nickname: fengyan Fengyu QQ: 95340299

Another friend in the garden is very helpful to me. I don't know how much QQ he is.

Forever azhe URL: http://www.cnblogs.com/ljzforever/

Thank you for your support. I will continue to serve you!

 

Version: 2.7.3 (First Amendment to 2.7.3)

1. Fixed the bug where the bool field cannot be updated when the new object is released.
Perform special processing on new object updates.
All submitted values are updated when the new object is updated.
If an object is read from the database, only the modified value is updated.
2. Change the original object name to old to correct the incorrect old value assignment bug.
The old object is assigned a value only when the current object is read from the database and changed.

3. Add a torowreader Method to the entity object to read data by field name.

4. Fixed a bug in sourcelist. totable.
When the attribute of a list data item is a class or structure, an error occurs when totable () is called!
5. added the sourcetable interface dispose () for releasing managed resources ();

Version: 2.7.3 (2.7.3 second correction)

1. Fixed the bug where the {} symbol exists in the condition during data query.
Because {} has a special purpose inside the component, it cannot perform special processing on the passed strings.

2. Add select, where, orderby and so on to tablerelation.
Tablerelation <A> TR = table. From <A> (). leftjoin <B> (A. _. ID = B. _. ID)
. Leftjoin <C> (B. _. PID = C. _. PID)
. Where (A. _. ID = 1)
. Orderby (A. _ id. DESC)
. Select (A. _. All, B. _. Name, C. _ pname)
Dbsession. Default. From (TR). tolist ();
3. The returned data is no longer returned as an interface, so that the original object can be used directly, saving the trouble of conversion, such:
The return value of tolist () is sourcelist, and sourcelist inherits from List
Totable () returns sourcetable, and sourcetable inherits from datatable
Toreader () returns sourcereader, and sourcereader accesses idatareader through the datasource attribute.

4. The Inline query syntax is supported as follows:
Select [products]. *, [categoryname] = (select [categories]. [categoryname] from [categories]
Where [categories]. [categoryid] = [products]. [categoryid]) from [products]
Tablerelation <Products> relation = table. From <Products> ()
. Select (products. _. All, New sysfield <categories> ("categoryname", table. From <categories> ()
. Select (categories. _. categoryname). Where (categories. _. categoryid = products. _. categoryid )));

Ilist <Products> List = dataaccess. defaultsession. From (relation). tolist ();

Version: 2.7.3 (2.7.3) stable

1. Fixed the bug of running an error when the string contains {} during the operation.

2. Corrected dbsession. Default. Update (field, field + 1, where) Errors During running.

3. Further enhancements to sourcelist and sourcetable Functions

4. The following describes how to transmit dictionary parameters in Stored Procedures and SQL syntax operations:
Idictionary <string, Object> parameters = new dictionary <string, Object> ();
Parameters ["$ userid"] = 1;
Dbsession. Default. fromsql ("select * from user where userid = $ userid", parameters );
Similar to stored procedures
5. Added sysvalue processing, such
Change the Update Time of user ID 1 to the current database time.
Dbsession. Default. Update (user. _. updatetime, new sysvalue ("getdate ()") user. _. userid = 1 );
6. Add MVPs from the original mysoft. Web to the mysoft. Data component to avoid referencing mysoft. Web in non-web projects.ProgramSet

 

This time for mysoft. DataCodeReleased after being changed again. Source Code download is not provided for the time being. Please forgive me!

If you have any questions, contact me directly. I will fix them in time.

Download mysoft 2.7.3 toolkit and dll library

Simpleguestbook(based on mvp .rar download

Mysoft. Data from entry to entry

Click here to go to mysoft feedback

 

QQ: 121849018

MSN: maoyong181@hotmail.com

Gmail: mysoft181@gmail.com

Qq discussion group (mysoft): Group 1: 27071789 group 2: 107193048