How Random Babbling Becomes Corporate Policy (t3knomanser) wrote,
How Random Babbling Becomes Corporate Policy
t3knomanser

.NET ORM

Has anyone worked with any .NET ORM products? NHibernate is looking pretty good and I know people really like its Java cousin, Hibernate- but I'd like to benefit from the experience of others.

The problem I'm trying to solve is this:
I have an Oracle DB. The schema is... complex. More complex than it needs to be. When we can get funding, one of our "todos" is to refactor the schema and make it something easier to access and maintain. In the meantime, there's a new project coming down the pipe that wants me to create an interface between a third-party application and that Oracle DB. Obviously, if we refactor the DB, I don't want to rewrite all of that integration code. Also, I'm pushing to do a full rewrite of the application that sits in-front of this DB anyway (it's in classic ASP). If I get the go-ahead to start that project, I'd like to be able to reuse the code from this integration project.

I want to take the "meet-in-the-middle" approach. I'd like to build the object model for the app-side without thinking about the database. I'd like a lightweight mapper to link that abstract model back to the more concrete database. The big hurdle is the fact that, when the DB schema changes, it will probably be nigh unrecognizable. Keeping the object model and the DB in sync through mapping may be too ambitious.
Tags: programming, work
Subscribe

  • Strange Things People Say About Me (to my face)

    Recently, I've been at the center of a trend. That trend is complete strangers asking me "Are you ____?" A quick summary. For example: Are you…

  • Writer's Block: If I could find my way

    -10,000 years, at minimum. Tomorrow is always better than today, especially when you can't fact-check.

  • Bob Morlang

    When I was working at Tri-Mount, we had these camp trucks. They were army surplus, and while they could take a beating, they only sort of worked. And…

  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded 

  • 2 comments