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

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.
 
G

Greg Young

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASP.NET 2.0 vs Ruby on Rails? 2
IE6 not repopulating form fields on back button in Ruby on Rails a 4
Converting Ruby "each" iterator to C# 2
ASP.NET 2.0 Windows Authentication 1
General network error when making asynchronous calls to long sql 3
Finding full name in Active Directory from a given username 4
Set up db to lookup and concatenate large amounts of text 1
Movenext and ASP.net 5

Top