我正在实现我的第一个Dapper.Net项目。现在我想知道初始化包含另一个对象(多映射)的对象最简单的方法。
这是我的代码:
public static IEnumerable<ShopPrefix> GetShopPrefixes(short fiSL)
{
using (var con = new SqlConnection(Properties.Settings.Default.RM2Con))
{
const String sql = @"
SELECT locShopPrefix.idShopPrefix,
locShopPrefix.fiSL,
locShopPrefix.fiShop,
locShopPrefix.Prefix,
locShopPrefix.Active,
locShop.idShop,
locShop.ShopName,
locShop.ContactPerson,
locShop.Street,
locShop.ZIP,
locShop.City,
locShop.Telephone,
locShop.Telefax,
locShop.Email,
locShop.ShopKey
FROM locShopPrefix
INNER JOIN locShop
ON locShopPrefix.fiShop = locShop.idShop
WHERE (locShopPrefix.fiSL = @fiSL);";
con.Open();
IEnumerable<Tuple<ShopPrefix,Shop>> shops =
con.Query<ShopPrefix, Shop, Tuple<ShopPrefix, Shop>>(
sql
, (shopPrefix, shop) => Tuple.Create(shopPrefix, shop)
, new { fiSL = fiSL }, splitOn: "idShop"
);
foreach (var shop in shops)
shop.Item1.Shop = shop.Item2;
return shops.Select(t => t.Item1);
}
}
每个 shopPrefix
都属于(拥有)一个 Shop
。
问题:这是映射两个对象的正确方式吗?因为使用 Tuple
方法并使用以下 foreach
初始化属性 Shop
看起来很麻烦?
Tuple
就可以解决这个问题。我会修改你的答案以展示我所做的更改(我需要ShopPrefixes
而不是Shops
)。 - Tim Schmeltercon.Query<ShopPrefix, Shop, ShopPrefix>
(和我的原始查询顺序相同)。非常感谢。 - Tim Schmelter