2.8使用EntityBase

返回单个实例对象

1. /// <summary>  
2. /// 按指定的名字返回城市对象  
3. /// </summary>  
4. /// <param name="cityName"></param>  
5. /// <returns></returns>  
6. [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)]  
7. public static City SelectByName(string cityName)  
8. {  
9.     DataProviders.IDataProvider provider = CreateDataProvider();  
10.     provider.SQL = "SELECT CityID as [Identity],Name,PostalCode,DistanceCode,Province,Longitude,Latitude,Version " +  
11.                     "FROM lt_dictionary.City WHERE Name=@name";  
12.     provider.AddParameters("@name", cityName);  
13.     return CreateInstance(provider.ExecuteDataTable());  
14. } 

返回集合对象

1. /// <summary>  
2. /// 返回所有禁用状态的城市信息  
3. /// </summary>  
4. /// <returns></returns>  
5. [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)]  
6. public static List<City> SelectIsDisabled()  
7. {  
8.     DataProviders.IDataProvider provider = CreateDataProvider();  
9.     provider.SQL = "SELECT CityID as [Identity],Name,PostalCode,DistanceCode,Province,Longitude,Latitude,Version " +  
10.                     "FROM lt_dictionary.City WHERE Enable=0";  
11.     //返回List<City>  
12.     return CreateInstances(provider.ExecuteDataTable());  
13. } 

 

本文转自shyleoking 51CTO博客，原文链接:http://blog.51cto.com/shyleoking/805778