English 中文(简体)
利用XML作为装载多个物体的参数
原标题:Using XML as a SQL Parameter to load multiple objects

我就此说了一个新奇,我对我说了第二句话。

我有这样的口号:

var dict = new Dictionary<int, SalesStatistics>();

销售统计是一种习俗分类,包含各种产品信息。 主要领域是产品分类。

我需要对这一口语和每个产品进行分类。 排在字典上;我需要装上产品类别。 由于该词典包含约20 000份记录;我不想每当我需要产品标语时将我的数据库保存下来。 理想的情况是,我想通过Id s的XML清单,将其全部装入“聚合物”,然后将产品从我的装货中投放。 这将使我能够一度打数据库。

任何人都有一些ti/trick,让我走到正确的方向?

最佳回答

您可以把Id s作为 separated分离的var子,并用fn_Split(

或使用SQL XML,将其打成桌,Join ——我没有在家、ry里有更好的榜样。

问题回答

暂无回答




相关问题
Test "User Must Change Password" field in .Net 3.5

I m trying to perform some basic AD User managment tasks in C# using .Net 3.5 I ve got a System.DirectoryServices.AccountManagement.UserPrincipal object that contains the user details. I can call ...

Entity Framework - Many to many question

I have a table called ASB and a table called PeopleInvolved. There is a junction table called PeopleInvolved_ASB which simply contains an ASBID and a PeopleInvolvedID column. The columns act as a ...

WCF: DuplexChannelFactory timeout error

I m using a DuplexChannelFactory when accessing my WCF service so that my service can use a callBackChannel to communicate back to the client. That s all fine but I get a timeout error when creating ...

AutoResetEvent, ManualResetEvent vs Monitor

Lets say I have to orchestrate a synchronization algorithm in .Net 3.5 SP1 and any of the synchronization primitives listed in the title fit perfectly for the task. From a performance perspective, is ...

Managing multiple .Net-Frameworks on a webserver

So I m in charge to deploy my project on the productive server where some other ASP.NET-Websites are also set up. The problem now is that I wrote my whole project under .NET 3.5 but on the webserver ...

Unit Testing .NET 3.5 projects using MStest in VS2010

There s a bug/feature in Visual Studio 2010 where you can t create a unit test project with the 2.0 CLR. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=483891&wa=...

热门标签