Click here to Skip to main content
15,882,598 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 20:43
Ravindra Bisen16-Jun-14 20:43 
GeneralRe: How to Search a Text into a Database objects Pin
$*Developer - Vaibhav*$16-Jun-14 20:45
$*Developer - Vaibhav*$16-Jun-14 20:45 
AnswerRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 21:07
Ravindra Bisen16-Jun-14 21:07 
AnswerRe: How to Search a Text into a Database objects Pin
Richard Deeming17-Jun-14 2:09
mveRichard Deeming17-Jun-14 2:09 
QuestionData Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 6:02
Member 1088784816-Jun-14 6:02 
AnswerRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Mycroft Holmes16-Jun-14 12:49
professionalMycroft Holmes16-Jun-14 12:49 
GeneralRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 22:41
Member 1088784816-Jun-14 22:41 
QuestionORM Rant Pin
Tomaž Štih16-Jun-14 0:55
Tomaž Štih16-Jun-14 0:55 
At the end of the 90ties we somehow got into ORM. At the time - no matter how hard we tried - we always ended up with a messy and complicated code and filthy compromises. And it hasn't changed. But somehow frameworks like NHibernate and EntityFramework are becoming very popular.

So here is my rant.

Some time ago I worked on large projects and things were pretty predictable. You've got DB model. You generate your SQL procedure layer and your C# layer. Then you create your component / web service / wcf service / restful service and serialize results of your C# calls as POCOs.

Now try to do this with fancy NHibernate objects with auto-resolving proxy objects for related entities. It won't work. Because when objects are serialized their auto-resolving lazy evaluating proxies aren't. To solve it you duplicate /I'll write it again, for drama effect: duplicate/ your objects to create serializable POCOs. And then you create them CRUD functions on top of object models. Or even separate the entities /drama: dereference them having no two entities connected/... And, hey, you are back where you were with the stored procedures - only with lousier performance and three layers of crap on top of it.

So next time someone comes with a fancy-schmancy ORM wrapper it better already include web service / wcf service or restful service abstraction and work on top of it; rather then bellow it! Because otherwise we just off-load drudgery to the web services and call it "business layer" when in fact it is really a freaking "ORM back to stored procedures layer."

There. Hhhh...shhhh... I already feel better.
AnswerRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 3:37
mveRichard MacCutchan16-Jun-14 3:37 
GeneralRe: ORM Rant Pin
Tomaž Štih16-Jun-14 3:51
Tomaž Štih16-Jun-14 3:51 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 4:10
mveRichard MacCutchan16-Jun-14 4:10 
GeneralRe: ORM Rant Pin
Jörgen Andersson16-Jun-14 6:58
professionalJörgen Andersson16-Jun-14 6:58 
GeneralRe: ORM Rant Pin
Mycroft Holmes16-Jun-14 12:43
professionalMycroft Holmes16-Jun-14 12:43 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 21:20
mveRichard MacCutchan16-Jun-14 21:20 
AnswerRe: ORM Rant Pin
Bernhard Hiller16-Jun-14 21:06
Bernhard Hiller16-Jun-14 21:06 
QuestionDistinct records on old school foxpro database file Pin
jkirkerx15-Jun-14 12:22
professionaljkirkerx15-Jun-14 12:22 
AnswerRe: Distinct records on old school foxpro database file Pin
GuyThiebaut15-Jun-14 22:03
professionalGuyThiebaut15-Jun-14 22:03 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:08
professionaljkirkerx16-Jun-14 6:08 
AnswerRe: Distinct records on old school foxpro database file Pin
Jörgen Andersson15-Jun-14 22:27
professionalJörgen Andersson15-Jun-14 22:27 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:11
professionaljkirkerx16-Jun-14 6:11 
AnswerRe: Distinct records on old school foxpro database file Pin
NitinDhapte16-Jun-14 23:30
NitinDhapte16-Jun-14 23:30 
Answer[SOLVED], I finally go it Pin
jkirkerx19-Jun-14 18:42
professionaljkirkerx19-Jun-14 18:42 
QuestionUnable to establish a connection to sql database 2005 Pin
Otekpo Emmanuel14-Jun-14 11:57
Otekpo Emmanuel14-Jun-14 11:57 
AnswerRe: Unable to establish a connection to sql database 2005 Pin
Kornfeld Eliyahu Peter14-Jun-14 19:22
professionalKornfeld Eliyahu Peter14-Jun-14 19:22 
QuestionSelective queries? Pin
Member 448708313-Jun-14 7:00
Member 448708313-Jun-14 7:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.