是否有任何陷阱或充分理由不对存储过程调用使用autosproc? [英] Are there any gotchas or good reasons not to use autosproc for stored procedure calls?

问题描述

我已经实现了一个数据访问层，该数据访问层使用第三种猴子方法( http://www.codeproject.com/KB/database/DynamicMethod_ILGenerator.aspx ).这样可以很好地工作，执行得很好，并节省了我编写重复性代码以进行数据检索的工作量.

I've implemented a data access layer that populates generic entities from a datareader using a variation of the third monkey approach (http://www.codeproject.com/KB/database/DynamicMethod_ILGenerator.aspx). This works well, performs well and saves me writing loads of repetetive code for data retrieval.

现在，我想添加采用通用实体并将其转换为参数列表以馈送给存储的proc的方法，以便可以将数据持久性添加到猴子的把戏集合中.

Now I want to add methods that take a generic entity and convert it to a parameter list for feeding to a stored proc so that I can add data persistence to my monkey's trick collection.

我在以下位置找到了一些指导: http://msdn.microsoft.com/en-us/library/ms973259.aspx 以及autosproc解决方案中的一些示例代码.在纸面上看起来不错，我打算将其合并，但是一个快速的google在实现autosproc的用户体验方面并没有带来太多改善，我正在寻找曾经或曾经这样做的人表示赞许(或不赞成)已经.

I found some guidance at: http://msdn.microsoft.com/en-us/library/ms973259.aspx and some sample code in the autosproc solution. It looks good on paper and I intend to incorporate this but a quick google did not turn up much in the way of user experiences of implementing autosproc and I am looking for a thumbs up (or down) from anyone who has been there and done that already.

那么，您使用过autosproc吗?对您来说效果很好吗?在性能或其他方面是否存在任何明显的缺陷，这些缺陷将使其不适用于企业应用程序?

So, have you used autosproc? Did it work well for you? Are there any gaping flaws in performance or elsewhere that would make it unsuitable in an enterprise application?

建议受到赞赏.

推荐答案

我认为向您推荐这个问题比较容易，我的答案包含指向您的AutoSproc事物的链接:

I think it's easier to refer you to this question, where my answer contains links to your AutoSproc thing: TSQL - Parse Execution Plan to determine columns to be returned by a stored procedure

总而言之，我不喜欢它:它引起了太多问题.

To summarise, I didn't like it: it caused too many issues.

(只是四处寻找未解决的问题)

(Just poking around unanswered questions and found this one)

这篇关于是否有任何陷阱或充分理由不对存储过程调用使用autosproc?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！