BLToolkit:多个结果集? [英] BLToolkit: Multiple resultsets?

问题描述

我还没有找到一种方法，可以使用两个select语句从SP检索对象的两个列表. BLToolkit是否有可能，还是只能以这种方式获取分层数据?

I haven't found a way to retrieve two lists of objects from an SP with two select statements. Is it possible with BLToolkit, or can only hierarchical data be fetched in such a manner?

我正在尝试替换包含两个不相关表的数据集.

I'm trying to replace a dataset containing two unrelated tables.

推荐答案

事实证明这确实很简单. :)

It turns out it was really simple. :)

这是使用BLToolkit返回多个不相关结果集的方式.

Here's how you return multiple unrelated resultsets using BLToolkit.

List<Apple> apples = new List<Apple>();
List<Orange> oranges = new List<Orange>();

MapResultSet[] sets = new MapResultSet[2];
sets[0] = new MapResultSet(typeof(Apple), apples);
sets[1] = new MapResultSet(typeof(Orange), oranges); //Make sure both lists are added

//Skip adding relations

using (DbManager db = new DbManager())
{
    db
        .SetSpCommand("usp_Fruit_GetBySomething",
            db.Parameter("someParam", someParam))
        .ExecuteResultSet(sets);
}

foreach(Apple apple in apples)
{
  profit(apple);
}

foreach(Orange orange in oranges)
{
  profit(orange);
}

这篇关于BLToolkit:多个结果集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！