Helper class called from map links get instantiated only once for a map or for every link that uses Helper class?

Question

Hi,

I am planning to pull some configuration data through helper class used inside map. Say from a xml file or database.

I need to know if it

gets instantiated for every links in the map that uses Helper class 

OR

gets instantiated only once in the execution of the map?

Regards

Vivek

Answer 1

Hi Vivek,

This has been discussed at length here, you will get lot of good ideas.

https://social.msdn.microsoft.com/Forums/en-US/ae81c324-ca10-4519-9dd2-ed854d6fef5d/caching-in-biztalk-map?forum=biztalkgeneral

---

Rachit Sikroria (Microsoft Azure MVP)

Answer 2

Helper classes are non-static per Transform execution...but you can make it work like static instances...

But you really shouldn't be worrying about that exactly.  What problem are you trying to solve?

Answer 3

John

We have a map that may call helper class in many links for configuration values.

The configuration values are residing in database. I thought I would pull data based on map from database only once when helper gets initiated and then use the values from local variable xmldoc in other links of the map.

I want to eliminate DB calls or configuration on each map links, I need to make it one DB call.

When there are so many configuration hard code values to pull into map, how generally application are designed ?

I don't want to hard code them in map directly, that becomes hard to maintain.

Regards

Vivek

Answer 4

Please have a look at the BizTalk XRef Data pattern a feature of BizTalk
Basically there are a set of tables within BizTalk which allow you to setup the mappings for reference data between systems
http://geekswithblogs.net/michaelstephenson/archive/2006/12/24/101995.aspx

Also check the reference links in the comments

hth  /Peter