說起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