|
Home > Archive > BizTalk Server Applications Integration > June 2004 > I have a Problem with Biztalk Mapper
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I have a Problem with Biztalk Mapper
|
|
|
| I have to create a Parent Child relationship when i insert data into SQL
Server tables, I create GUID as primary key and i need the same GUID as the
Foreign key for insertion into another table, I am unable to achieve this
since the Functiod that uses Inline C# is being executed once for each call
and hence i have two seperate GUIDs,
Is there any way out
Thanks in advance
Raj
| |
| Prasad Sripathi Panditharadhya [MSFT] 2004-06-26, 10:53 am |
| In your Inline C# you can maintain global variables that can remember the
state information across different functoid calls, and thus you can
remember if you have already generated a GUID before.
The code that you put in a InlineC# functoid would probably look something
like:
bool _globalDidWorkBefore = false; //global variables to remember state
string _globalGuid = null; //global variable to remember state
string GetMeGuid()
{
if (! _globalDidWorkBefore)
{
_globalDidWorkBefore = true;
_globalGuid = GenerateNewGuid();
}
return _globalGuid;
}
Thanks....
--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl[vbcol=seagreen]
the[vbcol=seagreen]
call[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|