Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jheywood
Starting Member
1 Post |
 Posted - 2009-08-05 : 16:05:15
|
| Hi all,I work for a company using MS SQL databases exclusively, but we integrate with varying technologies and applications. I am trying to design a data abstraction layer based on ORM to alleviate tightly coupled code development. I was hoping to get some feedback from other DB professionals about likes/dislikes/recommendations for what to use to develop this (i.e. Hibernate, ObJectRelationalBridge, self-developed, etc). Does anyone have any thoughts about it?Thanks in advance! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-05 : 20:50:35
|
| While my experience with ORMs is limited, I can say that self-developed should be avoided. Especially if you're trying to decouple your app from your data; you'll likely as not end up with a ORM that's tightly coupled to both. I would almost say it would be better to try an existing ORM and have it fail miserably, and THEN go self-developed, if you had to do it at all. You'd find a lot more problems with your app and data layers that way. |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2009-08-06 : 08:54:37
|
| Do you really have such a disconnect between your data and your applications? In an internal application you know a fair amount about what you are doing and how you will need to adapt it. I'd actually recommend using the strengths of the DB to your advantage and acknowledging the fact you will write code against it. Otherwise you end up treating your DB as a "big bucket of stuff" full of unnecessary abstractions rather than applying the power you have already paid for. First try using SPs, views etc before getting too carried away.Not a popular opinion, but give it some thought. |
|
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 09:07:11
|
| You might dig this post: http://blog.seerobcode.com/2007/08/im-orm-convert.html========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
|
|
|
|
|
|
|
|
ORM and Data Abstraction Layer