CODEWITHSUNDEEP
biztalkbiztalk-2010
Techie
Techie

Reputation: 1651

Biztalk SQL Adapter or a .NET SqlClient

My application has BizTalk orchestration which needs to do basic insert into a table. Which is the better way of doing it

I want to know the best way of inserting the data into a database in the BizTalk orchestration.

Upvotes: 1

Views: 264

Answers (2)

DTRT
DTRT

Reputation: 11040

The correct and best way to integrate with SQL Server in a BizTalk app is with the WCF SQL-Adapter.

Do not use the SQL Client in code since you have a greater chance of making things worse, operations, maintenance and performance, over using the built in tools.

Never guess or make assumptions about performance since without knowing exactly what to address, through test and measurement, you will either A) Spend time 'fixing' a problem that doesn't exist or B) make things worse by implementing something less optimized than the base product or C) both.

Use the WCF-SQL Adapter and if you measure a specific gap with an SLA, let us know, we can help you with that. 99.99%, the solution will not involve using the SQL Client directly.

Upvotes: 1

Dan Field
Dan Field

Reputation: 21661

You should always prefer using the SQL Adapter.

  1. It will be tracked in the Group Hub
  2. You'll get better diagnostics and tracking options around the port
  3. Retry logic is built in and configurable

The biggest downside is performance - it will create another persistence point in your orchestration on the send shape, whereas an inline SQL call would avoid that.

Upvotes: 0

Related Questions