SQL Compact 3.5 附加多个数据库/跨数据库查询? [英] SQL Compact 3.5 attach multiple DB/ cross-db query?
问题描述
是否可以将多个 DB 附加到 SQL CE 3.5(精简版),例如MasterData.sdf、Orders.sdf 并对它们应用查询,例如:选择 Orders.iOrderID、Orders.cItemID、MasterData.cItemDesc从 Orders.CustomerOrder 作为订单左加入 MasterData.Items 作为 Orders.cItemID = Items.cItemID 上的项目
Is it possible to attach multiple DBs to SQL CE 3.5 (Compact edition) e.g. MasterData.sdf, Orders.sdf and apply queries against them e.g.: select Orders.iOrderID, Orders.cItemID, MasterData.cItemDesc from Orders.CustomerOrder as Orders left join MasterData.Items as Items on Orders.cItemID = Items.cItemID
我需要这个是因为同步优化(许多小数据库与一个大数据库).
I need this because of sync optimization (many small databases vs. one big database).
是否有任何其他解决方案可以将两个(许多)sdf-s 合并为一个?
Is there any other solution to merge two (many) sdf-s into one ?
推荐答案
不,这是不可能的 - 但您可以将每个表作为业务对象列表加载,并使用 LINQ 跨这些集合进行查询.(需要更多内存)
No, this is not possible - but you could load each table as a list of business objects, and use LINQ to query cross these collections. (Requires more memory)
这篇关于SQL Compact 3.5 附加多个数据库/跨数据库查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!