本文整理汇总了C#中System.Data.Common.DbConnection.GetList方法的典型用法代码示例。如果您正苦于以下问题:C# DbConnection.GetList方法的具体用法?C# DbConnection.GetList怎么用?C# DbConnection.GetList使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbConnection
的用法示例。
在下文中一共展示了DbConnection.GetList方法的14个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetItemsByRestaurant
public IList<Vote> GetItemsByRestaurant(int restaurantID)
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<Vote>(new {RestaurantID = restaurantID}).ToList();
}
}
示例2: GetAll
public IEnumerable<RestaurantType> GetAll()
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<RestaurantType>(new {});
}
}
示例3: GetList
public IEnumerable<Holiday> GetList(object parameters)
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<Holiday>(parameters);
}
}
示例4: GetAll
public IEnumerable<Veto> GetAll()
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<Veto>(new {});
}
}
示例5: GetItems
public IList<Search> GetItems(SearchDependencies? dependencies = null)
{
using (_connection = Utilities.Database.GetProfiledOpenConnection())
{
var result = _connection.GetList<Search>().ToList();
if (result.Any() && dependencies != null)
{
if ((dependencies & SearchDependencies.Logs) == SearchDependencies.Logs)
{
List<SearchHistoryLog> Logs = null;
var searchIds = (from s in result let searchId = s.SearchId select searchId).ToList();
if (searchIds.Any())
{
Logs = _searchHistoryLogRepository.GetItems(searchIds).ToList();
}
if (Logs != null && Logs.Any())
{
foreach (var search in result)
{
search.Logs = Logs.FindAll(s => s.SearchId == search.SearchId).ToList();
search.LastLog = search.Logs.OrderByDescending(l => l.SearchDate).FirstOrDefault();
}
}
}
}
return result.ToList();
}
}
示例6: GetItems
public IEnumerable<DBVersion> GetItems()
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<DBVersion>();
}
}
示例7: GetItems
public IList<IgnoreWord> GetItems()
{
using (_connection = Utilities.Database.GetProfiledOpenConnection())
{
var result = _connection.GetList<IgnoreWord>();
return result.ToList();
}
}
示例8: GetItems
public IList<ApiAccessHistoryLog> GetItems(int apiApplicationId)
{
using (_connection = Utilities.Database.GetProfiledOpenConnection())
{
var result = _connection.GetList<ApiAccessHistoryLog>(new { ApiApplicationId = apiApplicationId});
return result.ToList();
}
}
示例9: GetItems
public IList<SearchHistoryLog> GetItems(long searchId)
{
using (_connection = Utilities.Database.GetProfiledOpenConnection())
{
var result = _connection.GetList<SearchHistoryLog>(new { SearchId = searchId });
return result.ToList();
}
}
示例10: List
public ActionResult List()
{
IEnumerable<CarViewModel> result;
using (_connection = Utilities.GetOpenConnection())
{
result = _connection.GetList<CarViewModel>();
}
return View(result);
}
示例11: Index
public ActionResult Index()
{
IEnumerable<User> result;
using (_connection = Utilities.GetOpenConnection())
{
result = _connection.GetList<User>();
}
return View(UserAddEdit.MapListUserToUserAddEdit(result));
}
示例12: Get
public User Get(string email, UserDependencies? dependencies)
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
var user = _connection.GetList<User>(new { Email = email }).FirstOrDefault();
if ((dependencies & UserDependencies.Vetoes) == UserDependencies.Vetoes)
{
List<Veto> vetoes = null;
if (user != null) vetoes = _vetoRepository.GetAll(user.Id).ToList();
if (vetoes != null)
user.Vetoes = vetoes.FindAll(v => v.UserId == user.Id);
}
return user;
}
}
示例13: GetItemsByUser
public IList<Vote> GetItemsByUser(int userID)
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<Vote>(new {UserID = userID}).ToList();
}
}
示例14: GetList
public IEnumerable<User> GetList(object where)
{
using (_connection = Utilities.GetProfiledOpenConnection())
{
return _connection.GetList<User>(where);
}
}