开发者

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

开发者 https://www.devze.com 2022-12-10 04:24 出处:网络
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 n

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

精彩评论

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