ASP.NET ORM (e.g., Active Record / Ruby on Rails)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm developing a large website with a substantial number of large forms -
containing 40+ fields each. Writing the INSERT and UPDATE statements by hand
is extremely laborious and time consuming. I can't simply bind to a datagrid
-- each form is wrapped in a custom design and extensive business and
presentation logic prevents me from using generic controls. Instead, I'm
writing SQL Statements and passing each field as a separate command parameter
-- after sanitizing and running checks -- which leads to mountains of code to
accomplish a relatively simple task.

I've worked with Ruby on Rails and Active Record is a joy. I dream of the
day when I can create an object, assign properties, and run a save method on
the object which "automagically" writes the INSERT or UPDATE sql for me.

I want to find out what tools other developers are using to solve this
problem. I can't believe that there isn't a better way to accomplish this
task.

I'm not interested in Castle on Rails, or other projects that require a
non-ASP.NET workflow. I like the .NET framework and I want the ORM layer to
be as minimal as possible.

I'm not interested in Code Generation either. It's unacceptable to have to
"re-generate" code for every change. I should be able to quickly add an
attribute and not worry about having to deploy a large number of
supplementary files.

I'm looking for something that is secure and very lightweight. Does anything
exist? What tools do you use for ORM?

Thanks in advance for your advice.
 
There are hordes of such tools. You should have taken a closer look at
castle project who have a library ActiveRecord which is built on top of
nhibernate that does exactly what you are describing. You can use this
library with a normal ASP.NET workflow (i.e. you don't have to use
everything they have).

Cheers,

Greg Young
MVP - C#
http://codebetter.com/blogs/gregyoung
 
Thanks Greg.

I was under the impression that Active Record / Monorail was tightly
coupled, but it appears that I can use Active Record without modifying the
ASP.NET workflow.

The links and guidance are appreciated.

-Brenden
 
Back
Top