Database Connectivity

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Database Connectivity

Viewing 1 reply thread
  • Author
    Posts
    • February 22, 2006 at 9:34 AM #12941
      community-content

        Hi,
        I have created custom functoid to insert values into database table using C# code. In the class file I do database connectivity.
        But I wanted to know how I can connect and open the database at a one time instead of connecting and opening at each time in the operation in map. That is connect and open the database while the process is executing itself, it can be open only once and after the target transformation is done, closes and disconnects.

        Does any one have a solution

        Thanx.

      • February 22, 2006 at 5:40 PM #12942
        community-content

          I don’t know the answer to your question, but it raises the question as to whether the map is the best place to put this kind of logic.

          Neal Walters
          http://Biztalk-Training.com

          • February 23, 2006 at 5:23 AM #12943
            community-content

              Hi,
              That is the doubt even I have. But Can databse connectivity be done at orchestration level? If so how to do that?

              Thanx

              • February 23, 2006 at 5:48 PM #12944
                community-content

                  You can make database calls inside the Orchestration.

                  I think .net has its own connection pooling so even if you had 20 maps or Orchestrations running you would not see 20 database connections.

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.