2.8使用EntityBase

傳回單個執行個體對象

/// <summary>  

/// 按指定的名字傳回城市對象  

/// </summary>  

/// <param name="cityName"></param>  

/// <returns></returns>  

[System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select, false)]  

public static City SelectByName(string cityName)  

{  

    DataProviders.IDataProvider provider = CreateDataProvider();  

    provider.SQL = "SELECT CityID as [Identity],Name,PostalCode,DistanceCode,Province,Longitude,Latitude,Version " +  

                    "FROM lt_dictionary.City WHERE Name=@name";  

    provider.AddParameters("@name", cityName);  

    return CreateInstance(provider.ExecuteDataTable());  

} 

傳回集合對象

/// 傳回所有禁用狀态的城市資訊  

public static List<City> SelectIsDisabled()  

                    "FROM lt_dictionary.City WHERE Enable=0";  

    //傳回List<City>  

    return CreateInstances(provider.ExecuteDataTable());  

本文轉自shyleoking 51CTO部落格，原文連結:http://blog.51cto.com/shyleoking/805778