updategram多个表 [英] updategram multiple tables

查看:58
本文介绍了updategram多个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述



我有需要插入3张桌子的情况。这3个表的所有列都为null,没有标识或唯一列。我正计划使用UpdateGram。我不知道如何使用at-identity和import,如 http:/ /blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx 是否需要拥有身份或唯一密钥或主键目标表
恭喜,
Rashmi


sfsf

Hi,

I have a situation where I need to insert into 3 tables. These 3 tables have all columns with null and no identity or unique column. I was planning using UpdateGram. I don't know how to use the at-identity and import as explained here http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx  Is it a necessary to have a identity or unique key or primary key destination tables
Thanks,
Rashmi


sfsf

推荐答案

我发现在业务流程中使用多个地图对我来说效果更好。我最终创建了一个C#函数,它将分配一个PK,并且在整个业务流程中使用该密钥来插入值。我这样做的原因是因为我在更新数据报时遇到了困难。我确信它有效,但我最终使用了编排,因为我发现这种方法从长远来看更加强大。
I have found that using multiple maps in the orchestration worked better for me. I ended up creating a C# function that would assign a PK and that key woudl be used throughout the orchestration to insert the values. The reason I did it that way was becuase I was having a dificult time with the update datagram. I am sure it works, but I ended up using the orchestration becuase I found that method more robust in the long run.


这篇关于updategram多个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆