开发者

Consume a WCF service from a console app as part of a SQL job?

I'm working with one WCF service which will be consuming records I queue up for it with another. Service A will package up an object containing a series of records (I guess an XML document, haven't nailed down the format yet) queried from a database, and submit it to Service B for processing.

Service B is on a separate department's system and is out of my control, so I'm using my service to package the data to conform to B's inputs.

I'm thinking of instantiating my service via a client in a console app, which would be cal开发者_StackOverflow社区led as part of a SQL job on MS SQL 2005.

Could someone please suggest alternatives and any better ideas?


You might want to consider packaging your service A code into SQLCLR and call it like another stored proc.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜