说起store procedure....

1年前有个面试，.net developer，interviewer是公司产品的architect，这个职位是帮他们把原来classic asp move到asp.net,介绍产品的时候，他特别兴奋的给我宣布：我们产品可好了，db那边特别干净，一个store procedure都没有。我当时特别茫然的看着他那张因为兴奋胀得通红的脸，说：very impressive， i guess next phase will be get rid of database altogether...

林子大了，真的什么鸟都有。

所有跟帖： 

• haha, good one -世界无童话- ♀ (0 bytes) () 10/17/2009 postreply 19:15:40

• FYI...It’s possible! -HappyNow?!- ♂ (430 bytes) () 10/17/2009 postreply 20:01:30

• 靠，真让我给蒙上了，这好像是外星人的approach... -撅着挺好- ♂ (53 bytes) () 10/17/2009 postreply 20:10:22

• FYI...5000+ transactions/second using COM+ ! -HappyNow?!- ♂ (136 bytes) () 10/17/2009 postreply 20:18:46

• 不是很明白它的架构.... -撅着挺好- ♂ (180 bytes) () 10/18/2009 postreply 01:20:19

• 要不是HappyNow提醒, 我还真没注意到这个. 我们的 -小谋- ♀ (105 bytes) () 10/17/2009 postreply 20:22:03

• not the same thing, though! -HappyNow?!- ♂ (271 bytes) () 10/17/2009 postreply 20:25:54

• CR 是啥? -小谋- ♀ (0 bytes) () 10/17/2009 postreply 20:32:28

• yeah, we use UID and PWD a lot. -小谋- ♀ (0 bytes) () 10/17/2009 postreply 20:15:30

• not the same thing, though! -HappyNow?!- ♂ (0 bytes) () 10/17/2009 postreply 20:20:42

• 哦~~ -小谋- ♀ (0 bytes) () 10/17/2009 postreply 20:23:35

• 真是无知者无畏呀，当然可以选择不用一个SP, 亏你说得出口 -waitGC- ♀ (0 bytes) () 10/17/2009 postreply 20:26:15

• at some point, he was absolutely RIGHT! -HappyNow?!- ♂ (53 bytes) () 10/17/2009 postreply 20:28:42

• Agree. It sounds the architect didn't understand DB. -ffppyy- ♂ (0 bytes) () 10/17/2009 postreply 21:20:13

• 原来两位都是搞数据库的. -小谋- ♀ (0 bytes) () 10/17/2009 postreply 20:34:18

• Hibernate, hibernate... -ncpga- ♂ (0 bytes) () 10/17/2009 postreply 22:29:47

• 你的回帖总是让人精神振奋，斗志昂扬，哈哈~~ -撅着挺好- ♂ (0 bytes) () 10/18/2009 postreply 01:04:11

• 我们现在做的这个项目基本上没有sp啊 -布衣之才- ♂ (16 bytes) () 10/17/2009 postreply 20:50:19

• entity framework是or mapping，你如何query against data？ -撅着挺好- ♂ (20 bytes) () 10/18/2009 postreply 01:06:45

• EF maps db tables, views and relationships into objects -布衣之才- ♂ (192 bytes) () 10/18/2009 postreply 18:55:10

• if u use profiler to check the query against ur database.. -撅着挺好- ♂ (224 bytes) () 10/18/2009 postreply 21:30:24

• You don't need stored proccedures at all if you want to ... -oneusdollar- ♂ (743 bytes) () 10/17/2009 postreply 22:27:06

• i assume u don't have access to datatable, right? -撅着挺好- ♂ (238 bytes) () 10/18/2009 postreply 01:13:56

• 这也太高深了。一点儿都不user friendly. 我有access to -小谋- ♀ (32 bytes) () 10/18/2009 postreply 06:49:07

• Why use database at all if you don't access table... -oneusdollar- ♂ (1873 bytes) () 10/18/2009 postreply 10:44:27

• excellent point, thank you for sharing! -HappyNow?!- ♂ (0 bytes) () 10/18/2009 postreply 10:54:38

• r u talking about BEST practice? -撅着挺好- ♂ (1698 bytes) () 10/18/2009 postreply 16:00:07

• accessing data table means access its schame.... -撅着挺好- ♂ (72 bytes) () 10/18/2009 postreply 17:07:37

• 回复：accessing data table means access its schame.... -海阔天空33- ♀ (708 bytes) () 10/18/2009 postreply 20:03:46

• The worst thing in industry is.... -撅着挺好- ♂ (783 bytes) () 10/18/2009 postreply 21:20:36

• I had the same feeling: the old day was the -HappyNow?!- ♂ (44 bytes) () 10/19/2009 postreply 10:42:04