Enumeration of the execution results of the Linq ExecuteQuery Method

Note:
1. The field name of the T class in IExecuteQuery <T> must be the same as the column name of the SQL statement in SQL _exp to fill in the object class.

 

2. The IExecuteQuery returned by executing ExecuteQuery () cannot be used for multiple (more than two) result set queries, and the IExecuteQuery read must be connecton open, therefore, consider converting to IList <T>.

You can first cache the results to the IList object. Example

IEnumerable <T> search = conn. ExecuteQuery <T> (sqlCommond );

IList <T> alist = new List <T> (search );